Oracle Oracle Autonomous Database 1Z0-931-22 Questions & Answers

• Question 1:

  Which three of the following data sources are available when using the Data Load page on Database Actions?

  A. Files in Oracle Cloud Storage

  B. Backup files in block storage

  C. Local Files

  D. Files in AWS S3 Storage

  E. REST endpoints

  Correct Answer: ACD

• Question 2:

  Which management operation is correct about Autonomous Databases on shared Exadata infrastructure?

  A. You can skip a scheduled maintenance run. For Autonomous Databases on shared Exadata infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed.

  B. You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your about Autonomous Databases on shared Exadata infrastructure.

  C. You cannot configure the scheduling for your Autonomous Databases on shared Exadata infrastructure.

  D. You can perform a "rolling restart" on all the Autonomous Databases. During a rolling restart, each node of an Autonomous Database is restarted separately while the remaining nodes continue to be available.

  Correct Answer: C

• Question 3:

  Data Guard is enabled for your Autonomous Database and the Lifecycle State field for the primary database indicates that it is stopped.

  Which statement is true?

  A. The standby database is terminated.

  B. The standby database is also stopped.

  C. Switchover is automatically initiated.

  D. Failover is automatically initiated.

  Correct Answer: B

• Question 4:

  Which two statements are true about Data Insights?

  A. You can retrieve previously executed Data Insights searches.

  B. Data Insights is available with on-premises deployments of Oracle Database.

  C. Data Insights is an additional priced option.

  D. You can search for Data Insights against a base table or business model.

  Correct Answer: AD

• Question 5:

  Which two cloud services are supported to import Data Pump files to Autonomous Database on Dedicated Infrastructure?

  A. Oracle Cloud Infrastructure Object Storage Classic

  B. Oracle Cloud Infrastructure Object Storage

  C. Google Cloud Storage

  D. Amazon S3

  E. Azure Blob Storage

  Correct Answer: AB

• Question 6:

  Which is NOT needed to manage Oracle Autonomous Database with REST APIS?

  A. User's OCID

  B. Tenancy's OCID

  C. Database ADMIN password

  D. Fingerprint of the public key

  Correct Answer: C

• Question 7:

  Which workload type does the Autonomous Database on dedicated infrastructure service currently support?

  A. Autonomous Transaction Processing only

  B. ATP and ADW

  C. Autonomous Data Warehouse only

  D. Hybrid Columnar compression

  Correct Answer: B

• Question 8:

  

  In which four ways can Oracle Database optimally access data in Object Storage?

  A. optimized data archive using partitioned external tables

  B. optimized data archive using hybrid partitioned tables

  C. scan avoidance using block skipping when reading parquet and ore files

  D. scan avoidance using columnar pruning for columnar stores like parquet and orc

  E. scan avoidance using partitioned external tables

  F. scan avoidance using columnar pruning for .csv files

  Correct Answer: ABDE

• Question 9:

  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 pumpdirectory 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 ' ) ;

  Correct Answer: A

• Question 10:

  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

  Correct Answer: AB