Oracle Cloud Infrastructure 2020 Architect Associate — Question 57

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

Answer options

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

Correct answer: B, E

Explanation

Option B is correct because DBMS_CLOUD.COPY_DATA supports source files from multiple cloud storage services. Option E is also correct as valid credentials are required for accessing the storage services. Options A, C, and D are incorrect; the source file is not automatically deleted, the target table is not created automatically, and the source file must be in Standard Storage specifically, not Archive Storage.