Hot Area:

HOTSPOT
You manage a Microsoft SQL Server environment. A server fails and writes the following event to the
application event log:
MSG_AUDIT_FORCED_SHUTDOWN
You configure the SQL Server startup parameters as shown in the following graphic:

Use the drop-down menus to select the answer choice that answers each question.
NOTE: Each correct selection is worth one point.
Hot Area:

HOTSPOT
You manage a Microsoft SQL Server environment. A server fails and writes the following event to the
application event log:
MSG_AUDIT_FORCED_SHUTDOWN
You configure the SQL Server startup parameters as shown in the following graphic:

Use the drop-down menus to select the answer choice that answers each question.
NOTE: Each correct selection is worth one point.
Hot Area:

Answer:

Explanation:
Box 1: single-user
The startup option -m starts an instance of SQL Server in single-user mode.
Box 2: sysadmin
Starting SQL Server in single-user mode enables anymember of the computer’s local Administrators group to
connect to the instance of SQL Server as a member of the sysadmin fixed server role.
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/database-engine-servicestartup-options



Leave a Reply 0

Your email address will not be published. Required fields are marked *