HOTSPOT You have a 50-TB Microsoft SQL Server database named DB1. You need to reduce the time it takes to perform database consistency checks of DB1. Which Transact-SQL command should you run? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Q: 6
Your Answer
Discussion
azure_blob_storage
azure_blob_storage
Nah, I think file_target is a trap. Use azure_blob_storage for minimal impact and direct storage to Azure.
I think NOREPAIR and TABLOCK is the trap, I'd go with NOINDEX and DATA_PURITY.
Clear question, similar to what I've seen in some practice sets. I'd say use Blob storage for the target location.
Be respectful. No spam.
Question 6 of 35
