ExamGecko
Question list
Search
Search

Question 32 - DS0-001 discussion

Report
Export

Which of the following is the best way to migrate a large data load from one table to another, considering total time and blocking?

A.
Split the load size into many transactions.
Answers
A.
Split the load size into many transactions.
B.
Split the load size in half and run simultaneously.
Answers
B.
Split the load size in half and run simultaneously.
C.
Batch into small loads and run in parallel.
Answers
C.
Batch into small loads and run in parallel.
D.
Batch large loads into one transaction.
Answers
D.
Batch large loads into one transaction.
Suggested answer: C

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.Reference:CompTIA DataSys+ Course Outline, Domain 3.0 Database Management and Maintenance, Objective 3.3 Given a scenario, migrate data between databases.

asked 02/10/2024
Marcin Piotrowski
40 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first