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