Administering a SQL Database Infrastructure — Question 28

You administer a Microsoft SQL Server 2016 instance.
After a routine shutdown, the drive that contains tempdb fails.
You need to be able to start the SQL Server.
What should you do?

Answer options

• A. Modify tempdb location in startup parameters.
• B. Start SQL Server in minimal configuration mode.
• C. Start SQL Server in single-user mode.
• D. Configure SQL Server to bypass Windows application logging.

Correct answer: B

Explanation

The correct answer is B, as starting SQL Server in minimal configuration mode allows it to start up without relying on the tempdb. Options A, C, and D are incorrect because modifying the tempdb location requires SQL Server to be running, single-user mode is not necessary for this scenario, and bypassing Windows application logging does not resolve the issue with tempdb.