Test Index

Administering Relational Databases on Microsoft Azure (DP-300) Test 3

© examsnet.com

Question : 26 of 33

Marks: +1, -0

HOTSPOT
You have a SQL Server on Azure Virtual Machines instance that hosts a 10-TB SQL database named DB1. You need to identify and repair any physical or logical corruption in DB1. The solution must meet the following
requirements:
• Minimize how long it takes to complete the procedure.
• Minimize data loss.
How should you complete the command? To answer, select the appropriate options in the answer area NOTE: Each correct selection is worth one point.
Hot Area:

DBCC CHECK [DB1], ______
NOINDEX
REPAIR_ALLOW_DATA_LOSS
REPAIR_FAST
REPAIR_REBUILD
) WITH ______
EXTENDED_LOGICAL_CHECKS;
PHYSICAL_ONLY;
TABLOCK;

Go to Question:

Prev Question

Next Question