nerdexam
ExamsSK0-003Questions#825
CompTIA

SK0-003 · Question #825

SK0-003 Question #825: Real Exam Question with Answer & Explanation

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.

Security and disaster recovery

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.

Explanation

Database security patches failed while OS patches succeeded, most likely due to insufficient permissions for the account attempting the database update.

Common mistakes.

  • A. Database patches are designed to update existing software, not to necessitate a complete reinstallation, which would be a highly disruptive and incorrect patching method.
  • B. If the server were unavailable, none of the patches, including the successfully applied OS patches, would have been able to install.
  • C. 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.

Concept tested. Database patch management permissions

Reference. https://learn.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-updates?view=sql-server-ver16#security

Topics

#patch management#database security#permissions#troubleshooting patches

Community Discussion

No community discussion yet for this question.

Full SK0-003 Practice