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?
Correct Answer: D
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.