1z0-931-20 Free Practice Test

Which statement is FALSE about Autonomous Database Maintenance on dedicated Exadata infrastructure?

1. A. If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedule the container database maintenance for the following quarter.
2. B. Autonomous Exadata Infrastructure maintenance takes place at least once each quarter and is mandatory.
3. C. You can change your container database maintenance window or reschedule a single container database maintenance run to ensure that your container database maintenance runs follow infrastructure maintenance within the same quarter.
4. D. Autonomous Exadata Infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates), and include database patching.

Correct Answer: D

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

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

Correct Answer: BC
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

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

1. A. Transparent Data Encryption
2. B. Database Vault
3. C. Customer Managed Keys
4. D. Data Redaction
5. E. Audit Vault

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

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

1. A. TPPERFORMANT
2. B. MEDIUM
3. C. HIGH
4. D. LOW
5. E. TPURGENT

Correct Answer: A
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

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

1. A. Oracle GoldenGate
2. B. Transportable Tablespace
3. C. RMAN Restore
4. D. Oracle Data Pump
5. E. SQL*Loader

Correct Answer: ADE
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