Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)

The correct answer is B. The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the D. The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data E. The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the. Explanation/Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbms-cloud.html#GUID- 930632E1-B7BF-4ECA-8F78-5E5A205C0865

Loading and Transforming Data

Question

Options

AThe DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the
BThe DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the
CThe DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE procedure validates the source files for an
DThe DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data
EThe DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the

How the community answered

(44 responses)

A
16% (7)
B
75% (33)
C
9% (4)

Explanation

Explanation/Reference: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/dbms-cloud.html#GUID- 930632E1-B7BF-4ECA-8F78-5E5A205C0865

Topics

#DBMS_CLOUD#external tables#object storage credentials#cloud data loading

Community Discussion

No community discussion yet for this question.

Full 1Z0-931-20 Practice