DS0-001 · Question #23
DS0-001 Question #23: Real Exam Question with Answer & Explanation
The correct answer is C: Batch into small loads and run in parallel.. The best way to migrate a large data load from one table to another, considering total time and blocking, is to batch into small loads and run in parallel. This means that the large data load is divided into smaller chunks that can be processed simultaneously by multiple threads
Question
Which of the following is the best way to migrate a large data load from one table to another, considering total time and blocking?
Options
- ASplit the load size into many transactions.
- BSplit the load size in half and run simultaneously.
- CBatch into small loads and run in parallel.
- DBatch large loads into one transaction.
Explanation
The best way to migrate a large data load from one table to another, considering total time and blocking, is to batch into small loads and run in parallel. This means that the large data load is divided into smaller chunks that can be processed simultaneously by multiple threads or processes. This reduces the total time required for the migration and also minimizes the blocking of other operations on the tables involved. The other options are either less efficient or more prone to blocking. For example, splitting the load size into many transactions may increase the overhead and latency of each transaction; splitting the load size in half and running simultaneously may still cause blocking or contention; batching large loads into one transaction may take longer and lock the tables for longer periods.
Topics
Community Discussion
No community discussion yet for this question.