Exam4Training

You manage a Microsoft SQL Server environment

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

NOTE: Each correct selection is worth one point.

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.

References: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/database-engineservice-startup-options

Latest 70-764 Dumps Valid Version with 451 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Exit mobile version