ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-1067-21 All Questions

View all questions & answers for the 1z0-1067-21 exam
Go to Exam

Exam 1z0-1067-21 topic 1 question 5 discussion

Actual exam question from Oracle's 1z0-1067-21
Question #: 5
Topic #: 1
[All 1z0-1067-21 Questions]

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

  • A. 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.
  • B. 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.
  • C. 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.
  • D. 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.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by nasa86 at Sept. 27, 2021, 1:53 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
maxoci
3 years, 3 months ago
Selected Answer: D
datapump doesnt use csv
upvoted 1 times
...
Royal_CT
3 years, 4 months ago
Selected Answer: D
YEs 'D" is correct
upvoted 1 times
...
GeisonSilva
3 years, 5 months ago
Selected Answer: D
D is correct
upvoted 1 times
...
akr14feb
3 years, 5 months ago
I will go with D
upvoted 1 times
...
exam67
3 years, 5 months ago
Selected Answer: D
D is correct. Using Object Storage and COPY_DATA is the standard recommended method for fetching data into ADW. Furthermore using CLI over web has the benefit of multipart upload, that is chunk upload of large files, thus reducing the chance of a transfer failure
upvoted 2 times
...
nasa86
3 years, 7 months ago
Answer is A I believe https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/load-data-cloud-copy.html#GUID-76FC5A15-7ACC-4B59-87C0-20D4778E522D
upvoted 2 times
Ganmook
3 years, 7 months ago
How about C than A? https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/load-data-cloud-data-pump.html#GUID-9E5199B2-30C2-4ECA-AB63-44D4D0D23F5D
upvoted 1 times
nasa86
3 years, 6 months ago
Def not C. but can be D. For Data Pump Import it has to be dump files. but here there are .csv files. But on second thought Answer Should be D. Since for larger files OCI CLI is the recommended options. Just my thoughts.
upvoted 2 times
Minghon
3 years, 6 months ago
D is the correct answer. Since the CSV file is a 20 GB large file, we need to upload by "multipart uploads". And we can perform multipart uploads using the API, the Software Development Kits and Command Line Interface, or the Command Line Interface (CLI).
upvoted 3 times
...
...
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago