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

Exam 70-765 All Questions

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

Exam 70-765 topic 4 question 30 discussion

Actual exam question from Microsoft's 70-765
Question #: 30
Topic #: 4
[All 70-765 Questions]

You have a database named DB1 and an application named App1. App1 queries DB1.
You discover that a non-clustered index in DB1 is corrupt.
You need to repair the index. App1 must be able to query DB1 while the index is being repaired.
What should you do?

  • A. Run CHECKDB REPAIR DATABASE and specify the REPAIR_REBUILD parameter.
  • B. Run CHECKDB REPAIR DATABASE and specify the ALLOW_DATA_LOSS parameter.
  • C. Restore DB1 from a backup.
  • D. Drop and recreate the index.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by cmps at May 20, 2020, 7:36 a.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
wyxh
Highly Voted 5 years ago
D. Drop and recreate the index. because with dbcc checkdb you must set the db in single_user and this is exclusive for the session setting the option, while the question asks to let the other session able to query the db while fixing.
upvoted 11 times
...
Kurtis24K
Most Recent 4 years, 9 months ago
the correct answer should be B
upvoted 1 times
...
cmps
5 years ago
It all seems incorrect. Should'nt there be an option for REORGANIZE index ? Cause thats the operation where db is still
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