An administrator needs to deploy a cumulative update (CU) for SQL Server. What steps would the administrator take to prepare this deployment with NDB?

Question

Options

• AApply the patch to the profile VM, delete the existing Software Profile and create a new Software
• BCreate a new Software Profile version using the CU executable and publish that version.
• CApply the patch to the profile VM, then create a new Software Profile version using the profile VM
• DCreate a new Software Profile using the CU executable and publish that profile.

• A
  14% (4)
• B
  7% (2)
• C
  72% (21)
• D
  7% (2)

Explanation

The correct answer is C because it follows the recommended procedure for applying a CU to a SQL Server Software Profile in NDB. By applying the patch to the profile VM, the administrator ensures that the CU is compatible with the existing Software Profile settings and configuration. By creating a new Software Profile version, the administrator preserves the previous version of the Software Profile for rollback purposes and allows the new version to be tested and published. Option A is incorrect because it deletes the existing Software Profile, which may cause data loss and prevent rollback. Option B is incorrect because it does not apply the patch to the profile VM, which may result in errors or inconsistencies in the Software Profile. Option D is incorrect because it creates a new Software Profile instead of a new version, which may cause confusion and duplication.

No community discussion yet for this question.