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

The correct answer is B. The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob C. A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure. Explanation/Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbms-cloud.html#GUID- 9428EA51-5DDD-43C2-B1F5-CD348C156122

Loading and Transforming Data

Question

Options

AThe source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the
BThe source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob
CA valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.
DThe source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure
EThe target table will be created in Autonomous Database if it does not already exist.

How the community answered

(51 responses)

A
12% (6)
B
80% (41)
D
6% (3)
E
2% (1)

Explanation

Explanation/Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbms-cloud.html#GUID- 9428EA51-5DDD-43C2-B1F5-CD348C156122

Topics

#DBMS_CLOUD.COPY_DATA#Object Storage#credentials#data loading

Community Discussion

No community discussion yet for this question.

Full 1Z0-931-20 Practice