CV0-002 · Question #209
An organization is converting a physical SQL server into a virtual server. The SQL database has been in use for several years and contains critical data for the organization. Which of the following co
The correct answer is D. Automated online. For converting a critical, long-standing physical SQL database to a virtual server, an automated online method is the most appropriate choice.
Question
An organization is converting a physical SQL server into a virtual server. The SQL database has been in use for several years and contains critical data for the organization. Which of the following conversion methods would be MOST appropriate?
Options
- AAutomated offline
- BManual offline
- CManual online
- DAutomated online
How the community answered
(35 responses)- A6% (2)
- B9% (3)
- C11% (4)
- D74% (26)
Why each option
For converting a critical, long-standing physical SQL database to a virtual server, an automated online method is the most appropriate choice.
Automated offline conversion would require the critical SQL server to be unavailable for an extended period, which is unacceptable for a production database.
Manual offline conversion introduces both significant downtime and a higher risk of human error, making it unsuitable for a critical system.
Manual online conversion still carries a higher risk of human error compared to automated methods and may not be as efficient, despite allowing the server to remain online.
An automated online conversion minimizes downtime for the critical SQL database by allowing the server to remain operational during the transfer. This approach also reduces human error and ensures efficient, consistent data migration to the new virtual server.
Concept tested: P2V conversion methods for critical systems
Topics
Community Discussion
No community discussion yet for this question.