Oracle Cloud Infrastructure 2019 Architect Associate — Question 3

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

Answer options

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

Correct answer: A, C

Explanation

Options A and C are correct because DBMS_CLOUD.COPY_DATA supports files in both Oracle Standard and Archive Storage, and requires valid credentials before execution. Options B, D, and E are incorrect as they either misrepresent the supported storage types, inaccurately state file removal behavior, or suggest automatic table creation which is not guaranteed.