CV0-003 · 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. Automated online P2V conversion minimizes downtime and reduces human error, making it the safest choice for migrating a critical, long-running production SQL database.
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
(26 responses)- A8% (2)
- B12% (3)
- C4% (1)
- D77% (20)
Why each option
Automated online P2V conversion minimizes downtime and reduces human error, making it the safest choice for migrating a critical, long-running production SQL database.
An automated offline conversion requires the SQL server to be taken completely offline, causing downtime that is unacceptable for a critical production database with ongoing organizational use.
A manual offline conversion combines the risk of full service downtime with the added risk of human error during the migration of years of critical, irreplaceable data.
A manual online conversion avoids downtime but relies on human execution of each migration step, introducing a higher risk of error when handling critical long-standing production data.
An automated online conversion keeps the source SQL server operational during the migration process, ensuring continuous access to the critical data and minimizing service disruption to the organization. Automation reduces the risk of manual errors that could corrupt or cause data loss on a database containing years of critical organizational data. Together, online availability and automated tooling provide the safest and most reliable path for migrating a business-critical system.
Concept tested: Physical to virtual P2V migration methods for critical systems
Source: https://docs.vmware.com/en/VMware-vCenter-Converter-Standalone/index.html
Topics
Community Discussion
No community discussion yet for this question.