Exam 70-764 topic 1 question 54 discussion

Actual exam question from Microsoft's 70-764

Question #: 54
Topic #: 1

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:

Show Suggested Answer

Suggested Answer:

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-engine-service-startup-options

by TheSwedishGuy at Jan. 24, 2020, 12:52 p.m.

Comments

Submit Cancel

TheSwedishGuy

5 years, 6 months ago

Talk about confusing. -m is not short for Multi user mode. It's actually single user mode. When SQL Server is in -m (single user) mode, then all Local Admins on the SQL Server can connect to the server, and they will be elevated to the SA role.

upvoted 1 times

...