NEW QUESTION 1
What are the two methods that could be used during the migration of your existing Oracle database to Autonomous Database?

• A. CSV files copied to Autonomous Database block storage
• B. Data Pump
• C. Golden Gate
• D. Recovery Manager (RMAN)

Answer: D

NEW QUESTION 2
Your customer receives information in various formats like .csv files from their suppliers. The business user would like to collect all of this information and store it in a ATP environment. The Oracle adviser recommends to use Oracle Data Sync for this.
Which statement is true regarding Oracle Data Sync?

• A. Data Sync can only load files into tables (insert-only), the customer has to write the additional code.
• B. Data Sync can not transform your data while loading it into the destination table.
• C. Data Sync can load a combination of data source, such as xsv, .xlsx and Oracle relational files.
• D. Data Sync can only load data from one source into one destination table.

Answer: C

NEW QUESTION 3
Which statement is true regarding database client credentials file required to connect to your Autonomous Database?

• A. When you share the credential files with authorized users, mail the wallet password and the file in the same email.
• B. The Transparent Data Encryption (TDE) wallet can be used for your client credentials to connect to your database.
• C. Place the credential files on a share drive that all users can use to connect to the database.
• D. Store credential files in a secure location and share the files only with authorized users to prevent unauthorized access to the database.

Answer: B

NEW QUESTION 4
Which two options are available to restore an Autonomous Data Warehouse?

• A. Select the snapshot of the backup.
• B. Specify the point in time (timestamp) to restore
• C. Select the archived redo logs.
• D. Backup and recovery must be done using Recovery Manager(RMAN).
• E. Select the backup from which restore needs to be done.

Answer: AD

NEW QUESTION 5
Autonomous Data Warehouse configures and optimizes your database for you, therefore you do not need to perform some of the administration operations for configuring the database.
Which statement is true regarding the default configuration of the Autonomous Data Warehouse?

• A. Adding, removing, or modifying tablespaces is allowed.
• B. Degree of parallelism for SQL statements is set based on the number of OCPUs in the system and the database service the user is connecting to.
• C. In Autonomous Data Warehouse direct access to the database node and the local file system is allowed.
• D. Compression is not enabled by default and you must specify the compression method for your tables with the compression clause in your CREATE TABLE and ALTER TABLE commands.

Answer: A

NEW QUESTION 6
How many pre-defined service names are configured in tnsnames.ora for a single Autonomous Transaction Processing database instance, and what are they called?

• A. Fiv
• B. They are called tpurgent, tp, high, medium and low.
• C. Thre
• D. They are called high, medium and low.
• E. Non
• F. There are no pre-defined service names in tnsnames.ora.
• G. Tw
• H. They are called ATP and ADW.

Answer: A

NEW QUESTION 7
Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production.
How should the customer unplug their database to migrate to Autonomous Database (ADB)?

• A. Unplug into a pdb archive which can be uploaded to object storage.B Create a database link from source database to the ADB environment and clone the PDB.
• B. Pluggable databases cannot be migrated to ADB using plug, unplug or clone.
• C. Unplug to an xml file so database files and xml file can be uploaded to object storage.

Answer: B

NEW QUESTION 8
What two methods can you use to define Machine Learning Users?

• A. Use DBMS_CLOUD_ADMIN package
• B. SQL/Developer
• C. Oracle Cloud Infrastructure Console
• D. Client tools

Answer: AC

NEW QUESTION 9
When scaling OCPUs in Autonomous Database, which statement is true in regards to active transactions?

• A. Scaling cannot happen while there are active transactions in the database.
• B. Active transactions are terminated and rolled back.
• C. Active transactions are paused.
• D. Active transactions continue running unaffected.

Answer: A

NEW QUESTION 10
If you need to connect to Autonomous Data Warehouse (ADW) using Java Database Connectivity (JDBC) via an HTTP proxy, where do you set the proxy details?

• A. cwallet.sso
• B. keystore.jks
• C. ojdbc.properties
• D. sqlnet.ora
• E. tnsnames.ora

Answer: E

NEW QUESTION 11
Which three data dictionary views contain information about analytic view objects?

• A. ALL_ANALYTIC_VIEW_PATHS
• B. ALL_ANALYTIC_VIEW_DIM_CLASS
• C. ALL_ANALYTIC_VIEW_ID_ATTRS
• D. ALL_ANALYTIC_VIEW_LVLGRPS
• E. ALL_ANALYTIC_VIEW_KEYS

Answer: B

NEW QUESTION 12
Once you have a connection to the Autonomous Data Warehouse, how do you import tables into the Oracle Analytics Cloud (OAC)?

• A. Import Table
• B. Create a Data Set
• C. Replicate the table using Golden Gate
• D. Load data using Data Pump

Answer: D

NEW QUESTION 13
Users are required to select a service when connecting to Autonomous Data Warehouse and these services match to one of three different consumer groups: High, Medium, and Low.
Which statement about these consumer groups is correct?

• A. High provides highest concurrency and lowest resources, and DoP is i.
• B. Medium provides intermediate resource and concurrency, and queries run in a serial.
• C. High provides highest resources, lowest concurrency, and DoP is 1.
• D. Low provides highest concurrency, lowest resources, and DoP =1.

Answer: D

NEW QUESTION 14
What are the two methods that could be used during the migration of your existing Oracle database to Autonomous Database?

• A. CSV files copied to Autonomous Database block storage
• B. Data Pump
• C. Golden Gate
• D. Recovery Manager (RMAN)

Answer: AC

NEW QUESTION 15
Which two statements are true about the The Oracle Cloud Infrastructure (OCI)?

• A. Because availability domains do not share infrastructure such as power or cooling, or the internal availability domain network, a failure at one availability domain within a region is unlikely to impact the availability of the others within the same region.
• B. Regions are dependent on other regions and must be located with 5 thousand kilometers of each other.
• C. A single fault domain can be associated with multiple regions and availability domains.
• D. An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region.

Answer: AC

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

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

Answer: A

NEW QUESTION 17
Which open source orchestration tool can be used to provision autonomous database resources in Oracle Cloud Infrastructure?

• A. Terraform
• B. Enterprise Manager
• C. REST API
• D. Dlocker

Answer: A

Explanation:
https://blogs.oracle.com/cloud-infrastructure/getting-started-with-the-resource-manager-on-oracle-cloud-infrastr

NEW QUESTION 18
Which three statements are true about procedures in the DBMS_CLOUD package?

• A. The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.
• B. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
• C. The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.
• D. 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.
• 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: ACD

NEW QUESTION 19
Which method can be used to migrate on-premises databases to Autonomous Databases in cloud?

• A. RMAN backup & restore
• B. Physical migration method like database cloning
• C. Data Pump
• D. Original Import/Export tools

Answer: C

NEW QUESTION 20
Which Autonomous Database Cloud service ignores hints in SQL Statements by default?

• A. Autonomous Data Warehouse .
• B. Neither service ignores hints by default
• C. Autonomous Transaction Processing
• D. Both services ignore hints by default

Answer: C

NEW QUESTION 21
Which three tasks by default are taken care of by the Autonomous Database?

• A. Database Upgrades
• B. Application User Creation
• C. Backups
• D. Firmware Patching
• E. Data Loading

Answer: ADE

NEW QUESTION 22
Which can be Scaled independently of the number of CPUs in an Autonomous Database?

• A. Concurency
• B. Memory
• C. Parallelism
• D. Storage
• E. Sessions

Answer: B

NEW QUESTION 23
......