ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-764 All Questions

View all questions & answers for the 70-764 exam
Go to Exam

Exam 70-764 topic 1 question 121 discussion

Actual exam question from Microsoft's 70-764
Question #: 121
Topic #: 1
[All 70-764 Questions]

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?

  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by Guest at Nov. 25, 2019, 3:47 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
norbert1
4 years, 9 months ago
because i think microsoft prefers using a feature instead of - freestyle "try whatever comes to your mind" which is often necessary and works..;-)
upvoted 1 times
...
norbert1
4 years, 9 months ago
hi - i tend to minimal too - i could not find significantly what minimal mode is doing with temp db i am not achieving with changing location. and change location is possible - see - move system databases..;-) https://docs.microsoft.com/en-us/sql/relational-databases/databases/move-system-databases?view=sql-server-ver15
upvoted 1 times
...
TheSwedishGuy
5 years, 3 months ago
If you have configuration problems that prevent the server from starting, you can start an instance of Microsoft SQL Server by using the minimal configuration startup option. This is the startup option -f. Starting an instance of SQL Server with minimal configuration automatically puts the server in single-user mode.
upvoted 1 times
...
Guest
5 years, 6 months ago
Answer A makes more sense TempDB is recreated on every startup So just configuring a new location should solve the issue
upvoted 1 times
Guest
5 years, 6 months ago
Well, as the tempdb is not a parameter, it not possible So minimal mode is indeed the correct solution https://www.sqlshack.com/overview-of-sql-server-startup-parameters-for-the-sql-database-engine-service/
upvoted 4 times
...
TheSwedishGuy
5 years, 4 months ago
Yeah, you can't tell SQL Server to start up without the TempDB database, nor tell the server where TempDB is supposed to be stored, therefore minimal configuration mode is the correct answer.
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel