nerdexam
CompTIA

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.

Deployment

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)
  • A
    8% (2)
  • B
    12% (3)
  • C
    4% (1)
  • D
    77% (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.

AAutomated offline

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.

BManual offline

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.

CManual online

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.

DAutomated onlineCorrect

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

#P2V migration#SQL server#automated online migration#critical data

Community Discussion

No community discussion yet for this question.

Full CV0-003 Practice