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

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.
B . Split the load size in half and run simultaneously.
C . Batch into small loads and run in parallel.
D . Batch large loads into one transaction.

View Answer

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.