An administrator wants to apply patches to the Microsoft SQL Server databases in an NDB environment. What needs to be done in NDB to accomplish this?

Question

Options

• ACreate a Maintenance window schedule and associate the SQL server with that maintenance
• BApply the patch to the database VM then create a new software profile using that updated VM as
• CApply the patch to the database VM, then create a new software profile version using that updated
• DCreate a new software profile version with the downloaded cumulative update from Microsoft,

• A
  14% (3)
• B
  9% (2)
• C
  5% (1)
• D
  73% (16)

Explanation

To apply patches to Microsoft SQL Server databases in an NDB environment, the administrator should follow a structured process: Create a new software profile version: Download the latest cumulative update (CU) or patch from Microsoft and use it to create a new version of the existing SQL Server Software Profile in NDB. This ensures the patch is integrated into NDB's management framework. Publish the updated software profile: Promote the new version to "Published" status, making it available for use across the environment. Apply the update: Navigate to the "Database VM Menu" for each database server, select the updated software profile, and apply the patch. This automates the patching process while maintaining database consistency and allowing rollback if needed.

No community discussion yet for this question.