Podcast Beta
Questions and Answers
What type of graphical data presentation capabilities does Data Insights provide?
When provisioning a dedicated Autonomous Container Database, which backup retention period cannot be implemented?
Which patch type is offered to be applied during maintenance after creating an Autonomous Container Database on dedicated infrastructure?
Which resources need to be provisioned by the fleet administrator and the database administrator before a developer can connect to an Autonomous Database on Dedicated Infrastructure as a database user?
Signup and view all the answers
Which API is NOT available for developing with spatial on Autonomous Database?
Signup and view all the answers
Which statement about enabling Autonomous Data Guard is true?
Signup and view all the answers
Which tool is used for automating data exploration and creating pivot tables in the context of analyzing sales data in an Autonomous Data Warehouse instance?
Signup and view all the answers
In the context of Oracle Cloud Infrastructure (OCI), which resource is required to configure before provisioning an Autonomous Database with a Private Endpoint?
Signup and view all the answers
What distinguishes Autonomous Data Warehouse (ADW) from Autonomous Transaction Processing (ATP) databases?
Signup and view all the answers
When creating a business model, which feature can you enable or disable to control Business Object Security?
Signup and view all the answers
In the context of Autonomous Database on Dedicated Infrastructure, what does the fleet administrator use to manage OCPU utilization?
Signup and view all the answers
Which interface can be used to interact with Oracle Client for database connectivity in APEX Administration Services?
Signup and view all the answers
Where are customer-managed encryption keys stored for Autonomous Database on Dedicated Infrastructure?
Signup and view all the answers
Which statement is FALSE regarding provisioning an Autonomous Database and configuring private endpoints with security rules?
Signup and view all the answers
What is true about the use of Access Control Lists (ACLs) with an Autonomous Database on Shared Infrastructure?
Signup and view all the answers
What does Degree of Parallelism (DoP) refer to in the context of provisioning an Autonomous Database?
Signup and view all the answers
When configuring private endpoints for an Autonomous Database, what happens when setting up a stateless ingress rule?
Signup and view all the answers
Where can you configure Access Control Lists (ACLs) for an Autonomous Database on Shared Infrastructure?
Signup and view all the answers
Study Notes
Data Insights
- O Data Insights provides a wide range of graphical data presentation capabilities.
- The results of the insight analysis appear as a series of bar charts in the Data Insights dashboard.
Autonomous Container Database
- While provisioning a dedicated Autonomous Container Database, 120 days backup retention cannot be implemented.
- Quarterly Bundle Patch (QBP) is offered to be applied during maintenance after creating an Autonomous Container Database on dedicated infrastructure.
Autonomous Database on Dedicated Infrastructure
- Four resources need to be provisioned by the fleet administrator and the database administrator before a developer can connect to an Autonomous Database on Dedicated Infrastructure as a database user:
- Autonomous Exadata Infrastructure
- Autonomous Container Database
- Oracle Database licenses
- Network Security Group(s) and Identity and Access Management (IAM) policy rules that allow access to the database
- Virtual Cloud Network and Subnet
Spatial on ADB
- Gremlin API is not available for developing with spatial on ADB.
Autonomous Data Guard
- Two true statements about enabling Autonomous Data Guard are:
- The primary database is available for read/write operations.
- The primary database is restarted for the new network configuration to be enabled.
Business Model
- Three advanced options can be enabled or disabled while creating a business model:
- Analytic View Base Table
- Query Transformation
- Display Private Tables
- Business Object Security Feature
- Autonomous Aggregate Cache
- Analytic View Transparency Views
Data Analysis
- To automate data exploration and create pivot tables, use Business Models.
Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) databases
- The difference between Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP) databases is that only ADW uses columnar compression by default.
Oracle Cloud Infrastructure (OCI) Resources
- Three OCI resources need to be configured before provisioning an Autonomous Database with Private Endpoint:
- Subnet
- VCN
- Network Security Group (NSG)
- Security List
Autonomous Database on Dedicated Infrastructure Service
- The fleet administrator uses Resource Manager settings to control OCPU utilization.
Concurrency and Resources
- Low provides highest concurrency and lowest resources, and Degree of Parallelism (DoP) is 1.
Customer-Managed Encryption Keys
- Customer-managed encryption keys are stored in a separate key vault external to the Exadata Infrastructure.
Provisioning an Autonomous Database
- A false statement regarding provisioning an Autonomous Database and configuring private endpoints with security rules to allow incoming and outgoing traffic to and from the Autonomous Database instance is that a stateless ingress rule is created to allow connections from the source to the Autonomous Database instance.
Access Control Lists (ACLs) with an Autonomous Database on Shared Infrastructure
- A true statement about the use of Access Control Lists (ACLs) with an Autonomous Database on Shared Infrastructure is that when you restore a database, the existing ACLs are not overwritten by the restore action.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Test your knowledge on Autonomous Database Dedicated Infrastructure, including topics like concurrency, resources, and customer-managed encryption keys storage. Questions cover information about Degree of Parallelism (DoP), Exadata Infrastructure, and key vaults.
