10/200 questions · Unlock full access
Q1

A financial analytics firm is migrating its on-premises Oracle Database to an Autonomous Data Warehouse (ADW) on shared infrastructure. To meet strict data residency and security policies, they must ensure all connections to the ADW originate from within their existing Virtual Cloud Network (VCN) and never traverse the public internet. Which configuration is required to achieve this?

Q2

A marketing team wants to enable their analysts, who are not proficient in SQL, to query customer data stored in an Autonomous Transaction Processing (ATP) database using conversational language. For example, they want to ask, "Show me total sales for the last quarter by region." Which new Autonomous Database feature directly facilitates this capability?

Q3

A database administrator is provisioning a new Autonomous Database on Shared Exadata Infrastructure. The workload is expected to be highly variable, with significant peaks during month-end processing. To handle these peaks without overprovisioning for the entire month, the administrator enables auto-scaling. What is the maximum number of OCPUs the database can scale up to with this feature enabled?

Q4

A logistics company is using Autonomous Graph to analyze its supply chain network. They need to identify critical distribution hubs that, if disrupted, would cause the most significant impact on delivery routes. Which type of graph analysis would be most effective for this task?

Q5Multiple answers

A developer is creating an external table in an Autonomous Database to query Parquet files stored in OCI Object Storage. The process fails. Which TWO of the following are mandatory prerequisites for successfully creating and querying an external table on Object Storage? (Select TWO)

Q6

True or False: When you provision an Autonomous Database on Dedicated Exadata Infrastructure, you are responsible for applying quarterly database patches and updates yourself.

Q7

A hospital is deploying a critical patient records application on an Autonomous Transaction Processing (ATP) database. To comply with regulations, they need to implement a disaster recovery solution with the lowest possible Recovery Point Objective (RPO) and Recovery Time Objective (RTO). Which Autonomous Database feature should they configure?

Q8

A data migration specialist is using Oracle Data Pump to move a large, multi-terabyte database from an on-premises Exadata machine to an Autonomous Data Warehouse (ADW). To minimize the transfer time and cost, the specialist exports the data directly to an OCI Object Storage bucket. Which Data Pump parameter is essential for this operation?

Q9

A developer is using SQL Developer Web (Database Actions) to manage an Autonomous Database. They need to create several REST endpoints for a new application. Which specific component within Database Actions should they use to build, test, and manage these RESTful services?

Q10

A startup is building a new mobile application that stores user profiles and activity logs as schemaless JSON documents. They require a fully-managed database optimized for this data type with elastic scaling and minimal administrative effort. Which Autonomous Database offering is specifically designed for this use case?