NEW QUESTION 1
To who, and in which order, are dedicated Exadata Infrastructure resources provisioned?

• A. Fleet Administrator, Autonomous Exadata Infrastructure -> Database Administrator -> Autonomous Container DB -> Autonomous DB
• B. Database Administrator, Autonomous Container DB -> Autonomous DB -> Fleet Administrator -> Autonomous Exadata Infrastructure
• C. Fleet Administrator, Autonomous Exadata Infrastructure -> Autonomous Container DB -> Database Administrator -> Autonomous DB
• D. Database Administrator, Autonomous Exadata Infrastructure -> Fleet Administrator -> Autonomous Container DB -> Autonomous DB

Answer: A

NEW QUESTION 2
Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?

• A. TPPERFORMANT
• B. MEDIUM
• C. HIGH
• D. LOW
• E. TPURGENT

Answer: A

Explanation:
Predefined Database Service Names for Autonomous Transaction Processing
The tnsnames.ora file provided with the credentials zip file contains five database service names identifiable as tpurgent, tp, high, medium, and low. The predefined service names provide different levels of performance and concurrency for Autonomous Transaction Processing.
• tpurgent: The highest priority application connection service for time critical transaction processing operations. This connection service supports manual parallelism.
• tp: A typical application connection service for transaction processing operations. This connection service does not run with parallelism.
• high: A high priority application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing.
• medium: A typical application connection service for reporting and batch operations. All operations run in parallel and are subject to queuing. Using this service the degree of parallelism is limited to four (4).
• low: A lowest priority application connection service for reporting or batch processing operations. This connection service does not run with parallelism.
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/manage-priorities.html#GUID-80E464A7-8ED4-45BB-A

NEW QUESTION 3
A new Python developer has joined your team and needs to access the Autonomous Database (ADB) data. How does the developer connect to and interact with ADB from Python?

• A. SQL Developer
• B. JAVA JDK
• C. You can't use Python with ADB.
• D. The Oracle Client and the cx_Oracle interface for Python

Answer: B

NEW QUESTION 4
Which statement is correct with respect to required action to move Autonomous Database resources to a different compartment?

• A. Autonomous Exadata Infrastructure instances and Autonomous Container Databases have no dependent resources that move with the
• B. Associated (non-dependent) resources remain in their current compartments.
• C. Moving an Autonomous Database instance does not include its automatic backups.
• D. You do not need to have sufficient access permissions on the compartment that the resource is being moved to.
• E. Moving the compartment of the Autonomous Database will also move the Autonomous Container Database and Autonomous Exadata Infrastructure.

Answer: A

NEW QUESTION 5
Which two license types does the customer need to benefit from BYOL when leveraging on-premise Enterprise Database licenses in Oracle Autonomous Database?

• A. Exadata
• B. Active Data Guard
• C. RAC, but only when scaling beyond 16 OCPUs
• D. Transparent Data Encryption
• E. Multitenant

Answer: BC

NEW QUESTION 6
Which three security features are available in Oracle Autonomous Database Shared Infrastructure?

• A. Transparent Data Encryption
• B. Database Vault
• C. Customer Managed Keys
• D. Data Redaction
• E. Audit Vault

Answer: ABC

Explanation:
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpfg/security-features-adb1.html#GUID-89E3C22E-D4EB-472

NEW QUESTION 7
Which TWO statements are TRUE about using an Autonomous Database with Private Endpoints

• A. A Network Security Group is required within your Virtual Cloud Network before you can provision a Shared Autonomous Database to use Private Endpoints
• B. An Autonomous Database with private endpoints can be accessed from the public internet byadding your ip address to an Access Control List.
• C. Private Endpoints can be configured when you clone a Shared Autonomous Database that was initially created with public endpoints.
• D. You can configure Private Endpoints for an Always Free Autonomous Database

Answer: BC

NEW QUESTION 8
What is the correct way to list all files in the default data pump directory?

• A. By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');
• B. You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW).
• C. Log onto ADW server and issue is -al on the command line.
• D. By executing select * from utl_file . list ( ‘DATA_PUMP_DIR ' ) ;

Answer: A

NEW QUESTION 9
What are three methods to load data into the Autonomous Database?

• A. Oracle GoldenGate
• B. Transportable Tablespace
• C. RMAN Restore
• D. Oracle Data Pump
• E. SQL*Loader

Answer: ADE

Explanation:
https://www.oracle.com/database/technologies/datawarehouse-bigdata/adb-faqs.html#ATPD https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/load-data-intro.html#GUID-5D2F

NEW QUESTION 10
You have a requirement to create an Autonomous Transaction Processing database that can support at least 200 concurrent statements per OCPU as well as parallelism.
Which service will you need to connect to?

• A. TPURGENT
• B. TP
• C. MEDIUM
• D. LOW

Answer: A

Explanation:
tpurgent: The highest priority application connection service for time critical transaction processing operations. This connection service supports manual parallelism.
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/connect-predefined.html#GUID-9747539B-FD46-44F1-8

NEW QUESTION 11
When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported?

• A. Data
• B. Schemas
• C. Tablespaces
• D. Reports

Answer: AB

NEW QUESTION 12
What is the default port number for accessing a newly created Autonomous Database?

• A. A.-1524B.1522C.1521D.1523E.1526

Answer: B

Explanation:
https://www.oracle.com/a/ocom/docs/cloud/autonomous-database-100.pdf

NEW QUESTION 13
What REST verb is used to create an Autonomous Database service using REST APIs?

• A. An "INSERT" REST call
• B. A "GET" REST call
• C. A "POST" REST call
• D. A "PUT" REST call

Answer: C

Explanation:
https://docs.oracle.com/en/cloud/paas/integration-cloud/rest-api/SendRequests.html

NEW QUESTION 14
Which statement is true when the Autonomous Database has auto scaling enabled?

• A. Database concurrency is scaled up when needed by the workload.
• B. Increases the number of sessions available to the database.
• C. Scales the PGA and SGA size when needed for the workload.
• D. Enables the database to use up to 3x CPU/IO resources immediately when needed by the workload.

Answer: D

NEW QUESTION 15
How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?

• A. It cannot be done.
• B. Using Database Configuration Assistant (DBCA) on the database server.
• C. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.
• D. Connecting to the Cloud Infrastructure Command console via SSH wallet.

Answer: C

Explanation:
The CLI is a small footprint tool that you can use on its own or with the Console to complete Oracle Cloud Infrastructure tasks. The CLI provides the same core functionality as the Console, plus additional commands.
https://blogs.oracle.com/datawarehousing/managing-autonomous-data-warehouse-using-oci-curl Examples of using Autonomous Database managing by REST API
https://oracle.github.io/learning-library/workshops/autonomous-transaction-processing/LabGuide900ConfigureO

NEW QUESTION 16
For someone that is not a service administrator to use SQL Developer Web, what package would you need to use to give them access?

• A. SQLDEV_ADMIN.GRANT_SCHEMA
• B. ORDS_ADMIN.ENABLE_SCHEMA
• C. ORDS_ADMIN.GRANT_SCHEMA
• D. ORDS_PRIV.ENABLE_SCHEMA

Answer: C

NEW QUESTION 17
Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure?

• A. Parallelism is not enabled by default.
• B. Compression is enabled by defaul
• C. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.
• D. Oracle Database Result Cache is enabled by default for all SQL statements.
• E. You have direct access to the database node.

Answer: AB

NEW QUESTION 18
Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)

• A. The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.
• B. The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage.
• C. A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.
• D. The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully.
• E. The target table will be created in Autonomous Database if it does not already exist.

Answer: BC

Explanation:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/file-uri-formats.html#GUID-5D3 https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbms-cloud.html#GUID-9428EA

NEW QUESTION 19
Which statement is true about connecting an OCI compute instance to a Shared Autonomous Database?

• A. The Autonomous Database must be in the same VCN and Subnet as the Compute instance.
• B. The OCI compute instance does not support connecting to a Shared Autonomous Database.
• C. The Autonomous Database must belong to a Network Security Group (NSG).
• D. The OCI compute instance can be used with an Always-Free Autonomous Database account.
• E. A Private Endpoint is required to connect to the Shared-Autonomous Database.

Answer: A

NEW QUESTION 20
According to Oracle documentation, it is a best practice when planning and instituting Access Controls for your Autonomous Dedicated environment regarding Subnets, Compartments and User Groups.
Which statement is true?

• A. Create a separate VCN that contains only public subnets
• B. Only 1 of each is allowed to be allocated per environment.
• C. Only 1 Subnet and 1 Compartment are allowed, multiple Groups highly advised.
• D. Create at least 2 of each resource

Answer: C

NEW QUESTION 21
What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure?

• A. alter database set application_continuity=true
• B. alter session set application_continuity=true
• C. exec dbms_cloucl_admi
• D. enable_app_cont ( ' <service_name> ' ) ;
• E. alter system set application_continuity=true

Answer: D

NEW QUESTION 22
Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)

• A. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.
• B. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
• C. The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Data Warehouse.
• D. The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.
• E. The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the clou
• F. You can run queries on external data from the Autonomous Data Warehouse.

Answer: BCE

Explanation:

DELETE_FILE Procedure
This procedure removes the specified file from the specified directory on Autonomous Data Warehouse. CREATE_CREDENTIAL Procedure
This procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database. Use stored credentials for data loading or for querying external data residing in the Cloud.
PUTJDBJECT Procedure
This procedure copies a file from Autonomous Data Warehouse to the Cloud Object Storage. The maximum file size allowed in this procedure is 5 gigabytes (GB).
VALIDATE EXTERNAL TABLE Procedure
This procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Data Warehouse.
CREATE_EXTERNAL_TABLE Procedure
This procedure creates an external table on files in the Cloud. This allows you to run queries on external data from Autonomous Data Warehouse.
To use Data Pump from ADB, a credential identifying the Object Storage bucket to use must be defined with a DBMS_CLOUD.CREATE_CREDENTIAL function. This will allow ADB to access objects that are stored in the object store , including dump files. To export an existing database to prepare for import into ADB, use the XTP command and add the ex elude option for database functionality that is not recommended or supported in ADB. This will prevent errors during the imp oil process.
This process is not automatic. And if the logs are not moved, you will receive a warning when running the MDB that the logs are not there. In this example, we're
moving the log import.log to object store with a DBMS_CLOUD.PUT_OBJECT command.
VALIDATE_EXTERNAL_TABLE Procedure
This procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Database. The overloaded form enables you to use the operation_id parameter.
PUT_OBJECT Procedure
This procedure copies a file from Autonomous Database to the Cloud Object Storage. The maximum file size allowed in this procedure is 5 gigabytes (GB)
DELETE FILE Procedure
This procedure removes the specified file from the specified directory on Autonomous Database.
CREATE_EXTERNAL_TABLE Procedure
This procedure creates an external table on files in the Cloud. This allows you to run queries on external data from Autonomous Database.

NEW QUESTION 23
Oracle Data Safe is a unified control center for your Oracle databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements.
Which statement is FALSE?

• A. Oracle Data Safe only supports Autonomous Databases.
• B. Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations.
• C. Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary.
• D. Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user.

Answer: A

NEW QUESTION 24
While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?

• A. Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations.
• B. Autonomous Data Warehouse workloads are optimized for mixed workloads.
• C. Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.
• D. Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.

Answer: D

Explanation:
- Both ADW and ATP share the Autonomous Database platform of Oracle Database on Exadata Cloud infrastructure.
The difference is how the services have been optimized within the database. When you start loading data into the autonomous database, we store the data in the appropriate format for the workload.
* If it is ADW, then we store data in columnar format because that's the best format for analytics processing.
• If it is ATP, then we store the data in row format because that's the best format for fast single row lookups.
- Oracle Autonomous Database is offered in two workload-optimized flavors
* Autonomous Data Warehouse (ADW), which has been optimized for analytic workloads
• Autonomous Transaction Processing (ATP). ATP is optimized for transaction processing or mixed workload https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/autonomous-intro-atp.html#GUID-B90147B2-EA04-414 https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/autonomous-intro-atp.html#GUID-B90147B2-EA04-414

NEW QUESTION 25
......