SK0-003 · Question #825
Security patches that were issued to address a security flaw in the database server software have failed to install. All other OS security patches applied successfully. Which of the following is the M
The correct answer is D. The account used does not have permission to patch the database software.. Database security patches failed while OS patches succeeded, most likely due to insufficient permissions for the account attempting the database update.
Question
Security patches that were issued to address a security flaw in the database server software have failed to install. All other OS security patches applied successfully. Which of the following is the MOST likely cause of the failure?
Options
- ADatabase patches typically require a reinstall of the database server software.
- BThe server was unavailable during the patch window.
- CThe OS patches and database patches cannot be deployed together.
- DThe account used does not have permission to patch the database software.
How the community answered
(23 responses)- A4% (1)
- B13% (3)
- C4% (1)
- D78% (18)
Why each option
Database security patches failed while OS patches succeeded, most likely due to insufficient permissions for the account attempting the database update.
Database patches are designed to update existing software, not to necessitate a complete reinstallation, which would be a highly disruptive and incorrect patching method.
If the server were unavailable, none of the patches, including the successfully applied OS patches, would have been able to install.
While often managed separately for best practice, there is no technical limitation preventing OS and database patches from being deployed within the same maintenance window if dependencies and permissions are correctly handled.
Database software often requires specific, elevated administrative privileges to modify its core components and apply patches, which can be different from the permissions needed for operating system updates. If the account used for patching lacks these specific database-level permissions, the installation will fail, even if OS patches, which rely on different system permissions, installed successfully.
Concept tested: Database patch management permissions
Source: https://learn.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-updates?view=sql-server-ver16#security
Topics
Community Discussion
No community discussion yet for this question.