Exam DP-300 topic 7 question 2 discussion

for Box 2, the answer is correct. However the wrong option is high-lighted.

For any Admins or Admins to be...these answers present the wrong way of doing this in the real world. The correct real world methodology (assuming you have all the time in the world which you seldom will have) is to recover from last known good backup. If you want to fix the database then first set the database in emergency mode not single_user. This prevents another thread grabbing the access to the database before you. Then you would run DBCC CHECKDB with the REPAIR_REBUILD option. This will not cause data loss. After that because you're the only one with access from a query window now issue the ALTER DATABASE SET SINGLE_USER statement and, if approved, use the REPAIR_ALLOW_DATA_LOSS statement and then set the database back to multiuser.

SINGLE_USER REPAIR_ALLOW_DATA_LOSS MULTI USER is correct!

Repair_Fast does nothing: https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql?view=sql-server-ver15 So it should be REPAIR_ALLOW_DATA_LOSS

SINGLE_USER REPAIR_ALLOW_DATA_LOSS MULTI USER REPAIR_FAST doesn't actually make any changes.

https://www.stellarinfo.co.in/kb/checksum-error-in-sql-server.php REPAIR_ALLOW_DATA_LOSS is correct answer for BOX 2

So misleading.. some of the discussions here. The correct answer is mentioned in the explanation itself. Incorrect Answers: REPAIR_FAST - Maintains syntax for backward compatibility only. No repair actions are performed. REPAIR_ALLOW_DATA_LOSS is correct answer for Box2

single_user repair_fast multi_user

Which is the correct answer? Thanks for you help.

https://azure.microsoft.com/en-us/blog/data-integrity-in-azure-sql-database/

REPAIR_ALLOW_DATA_LOSS is correct answer but instead of doing repair doe all database we can know the the issue in which table then we can repair these tables only add in your note this option can cause data loss check this link for more information https://www.stellarinfo.co.in/kb/checksum-error-in-sql-server.php

Attaching a link for the reference. REPAIR_ALLOW_DATA_LOSS is correct answer for BOX 2. REPAIR_ALLOW_DATA_LOSS Tries to repair all reported errors. These repairs can cause some data loss. REPAIR_FAST Maintains syntax for backward compatibility only. No repair actions are performed. https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql?view=sql-server-ver15

Yes you are tight