DP-300 Certification Practice Question #138

Question

You have an Azure SQL database named sqldb1.
You need to minimize the amount of space by the data and log files of sqldb1.
What should you run?

Accepted Answer

The question asks to minimize space used by *data and log files* of an Azure SQL database together. DBCC SHRINKDATABASE (A) shrinks all data files and the log file in a single operation and is explicitly supported in Azure SQL Database per the MS Learn file-space-manage documentation. DBCC SHRINKFILE (D) operates on a single file at a time and would require multiple invocations; while valid, the exam specifically asks for a single action covering both data and log files, making A the best answer. The stored procedures in B and C are for clearing ghost records, not for reclaiming file space.

More DP-300 practice questions