Posted by: Pdfprep
Post Date: May 7, 2021
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?
A . DBCC SHRINKDATABASE
B . sp_clean_db_free_space
C . sp_clean_db_file_free_space
D . DBCC SHRINKFILE
Answer: A
Explanation:
DBCC SHRINKDATABASE shrinks the size of the data and log files in the specified database.
Reference: https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-shrinkdatabase-transact-sql
Leave a Reply