WHEN YOU CHANGE THE AUTHENTICATION MODE, WHAT ACTION DO YOU NEED T...

13. When you change the Authentication Mode, what action do you need to

perform before the mode change takes effect?

A. Reboot the server operating system.

B. Lock out all the database users.

C. Restart SQL Server Agent.

D. Restart the SQL Server Instance.

The correct answer is D. You need to restart the SQL Server instance in order

for an authentication mode change to take effect. Answer A is incorrect since,

although rebooting the server operating system will shut down SQL Server

and start it when the operating system cycles back up, it is not necessary to do

this. Answers B and C are incorrect since taking either of these actions will

not cause the authentication mode to change.