nerdexam
CompTIA

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.

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

(35 responses)
  • A
    6% (2)
  • B
    9% (3)
  • C
    11% (4)
  • D
    74% (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.

AAutomated offline

Automated offline conversion would require the critical SQL server to be unavailable for an extended period, which is unacceptable for a production database.

BManual offline

Manual offline conversion introduces both significant downtime and a higher risk of human error, making it unsuitable for a critical system.

CManual online

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.

DAutomated onlineCorrect

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

#P2V conversion#SQL server virtualization#Migration strategy#Automated migration

Community Discussion

No community discussion yet for this question.

Full CV0-002 Practice