Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Oracle Exam 1Z0-1067-24 Topic 5 Question 7 Discussion

Actual exam question for Oracle's 1Z0-1067-24 exam
Question #: 7
Topic #: 5
[All 1Z0-1067-24 Questions]

You have created an Autonomous Data Warehouse (ADW) service in your company 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.)

Show Suggested Answer Hide Answer
Suggested Answer: A, D

Contribute your Thoughts:

Adell
2 months ago
I'm not sure which option to choose. Can someone explain why attaching a block volume to each instance and enabling replication is not a good idea?
upvoted 0 times
...
Ma
2 months ago
This question is a real head-scratcher. I wonder if the exam authors have ever tried to set up a shared file system in the cloud. *chuckles*
upvoted 0 times
...
Joye
2 months ago
C is out, replicating block volumes doesn't solve the shared state requirement.
upvoted 0 times
Shaunna
28 days ago
D) Attach a single block volume in read/write shared mode to all the instances. Use a cluster aware system such as Oracle Cluster File System version 2 (OCFS2) to coordinate access to the shared volume.
upvoted 0 times
...
Sheron
28 days ago
B) Attach a single block volume in read/write shared mode to all the instances. Enable the cluster plug-in on the Oracle Cloud Agent to coordinate access to the shared volume.
upvoted 0 times
...
Berry
1 months ago
A) Create a file system in the File Storage service. Create a mount target and export the file system. Mount the export onto all of the instances.
upvoted 0 times
...
...
Ryan
2 months ago
I'm not sure about B. Coordinating access to a shared block volume sounds like it could be tricky.
upvoted 0 times
...
Leatha
2 months ago
I disagree, I believe option D is the way to go. Using a cluster aware system like OCFS2 can better coordinate access to the shared volume.
upvoted 0 times
...
Hassie
2 months ago
D looks good too, using a cluster-aware file system like OCFS2 to manage the shared block volume access.
upvoted 0 times
Willie
1 months ago
D) Attach a single block volume in read/write shared mode to all the instances. Use a cluster aware system such as Oracle Cluster File System version 2 (OCFS2) to coordinate access to the shared volume.
upvoted 0 times
...
Maryrose
2 months ago
A) Create a file system in the File Storage service. Create a mount target and export the file system. Mount the export onto all of the instances.
upvoted 0 times
...
...
Latia
2 months ago
Option A seems like the way to go. Creating a shared file system on the File Storage service and mounting it on all instances is a straightforward solution.
upvoted 0 times
Wilda
2 months ago
B) Attach a single block volume in read/write shared mode to all the instances. Enable the cluster plug-in on the Oracle Cloud Agent to coordinate access to the shared volume.
upvoted 0 times
...
Virgina
2 months ago
A) Create a file system in the File Storage service. Create a mount target and export the file system. Mount the export onto all of the instances.
upvoted 0 times
...
...
Shayne
2 months ago
I think option A is the best choice because it involves creating a file system in the File Storage service and mounting it onto all instances.
upvoted 0 times
...

Save Cancel