Online Access Free Oracle.1Z0-931.v2021-12-07.q70 Practice Test (Page 8)

1Z0-931 Exam Question 31

Which two statements are true about the Oracle Cloud Infrastructure (OCI)? (Choose two.)

A.An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region.

B.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.

C.A single fault domain can be associated with multiple regions and availability domains.

D.Regions are dependent on other regions and must be located with 5 thousand kilometers of each other.

1Z0-931 Exam Question 32

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.

1Z0-931 Exam Question 33

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

A.The DBMS_CLOUVALIDATE_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.

B.The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from 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.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.

E.The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the cloud. You can run queries on external data from the Autonomous Data Warehouse.

1Z0-931 Exam Question 34

A customer wants to migrate to Autonomous Database (ADB) but only allows for a very small window of downtime. Golden Gate was advised to be used during the migration. For maximum reassurance of their end-users, the customer also would like to use Golden Gate as a fall-back scenario for the first 6 months after the migration. If customers complain, the on-premise data can be synchronised with the ADB instance for a switch back.
Which statement about the migration using Golden Gate is correct?

A.Only the migration to ADB is possible from an on-premise installation of Golden Gate.

B.The described scenario is correct, can be used for migration and fallback scenarios.

C.Golden Gate on premise Is not certified with ADB because Golden Gate Cloud Service exists for this.

D.The fallback scenario is not possible using Golden Gate because the capture-process cannot be installed on ADB.

E.Migration to ADB is not possible using Golden Gate because the apply-process cannot be installed on ADB.

1Z0-931 Exam Question 35

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

A.Autonomous Transaction Processing.

B.Autonomous Data Warehouse.

C.Neither service ignores hints by default.

D.Both services ignore hints by default.

Latest Upload: 169ACSM.020-222.v2025-09-11.q48; 157VMware.5V0-31.23.v2025-09-10.q73; 131Oracle.1z0-915-1.v2025-09-10.q24; 160Citrix.1Y0-231.v2025-09-10.q87; 135SAP.C-THR85-2505.v2025-09-09.q29; 166Adobe.AD0-E727.v2025-09-09.q76; 130Oracle.1Z0-1123-25.v2025-09-09.q20; 135SAP.C_SIGPM_2403.v2025-09-08.q20; 254EXIN.ITIL.v2025-09-08.q161; 171BCS.PC-BA-FBA-20.v2025-09-08.q45

1Z0-931 Exam Question 31

1Z0-931 Exam Question 32

1Z0-931 Exam Question 33

1Z0-931 Exam Question 34

1Z0-931 Exam Question 35

Download PDF File