Question 5
Topic 1
You have created an Autonomous Data Warehouse (ADW) service in your company's Oracle Cloud
Infrastructure (OCI) tenancy and you now have
to load historical data into it. You have already extracted this historical data from multiple data marts
and data warehouses. This data is stored in
multiple CSV text files and these files are ranging in size from 25 MB to 20 GB.
Which is the most efficient and error tolerant method for loading data into ADW? (Choose the best
answer.)
Create Auth token, use it to create an object storage credential by executing
DBMS_CLOUD.CREATE_CREDENTIAL, using the web console
upload the CSV files to an OCI object storage bucket, create the tables in the ADW database and then
execute DBMS_CLOUD.COPY_DATA for
each CSV file to copy the contents into the corresponding ADW database table.
Create the tables in the ADW database and then execute SQL*Loader for each CSV file to load the
contents into the corresponding ADW
database table.
Create Auth token, use it to create an object storage credential by executing
DBMS_CLOUD.CREATE_CREDENTIAL, using OCI CLI upload the
CSV files to an OCI object storage bucket, create the tables in the ADW database and then execute Data
Pump Import for each CSV file to copy
the contents into the corresponding ADW database table.
Create Auth token, use it to create an object storage credential by executing
DBMS_CLOUD.CREATE_CREDENTIAL, using OCI CLI upload the
CSV files to an OCI object storage bucket, create the tables in the ADW database and then execute
DBMS_CLOUD.COPY_DATA for each CSV
file to copy the contents into the corresponding ADW database table.
Ans: D
Correct answer: A