CompTIA
DS0-001 · Question #23
Which of the following is the best way to migrate a large data load from one table to another, considering total time and blocking?
Sign in or unlock DS0-001 to reveal the answer and full explanation for question #23. The question stem and answer options stay visible for context.
Database Management and Maintenance
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.
Unlock DS0-001 to see the answer
You've previewed enough free DS0-001 questions. Unlock DS0-001 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Data Migration#Performance Optimization#Concurrency Control#Batch Processing