Microsoft
DP-300 · Question #43
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?
The correct answer is A. DBCC SHRINKDATABASE. DBCC SHRINKDATABASE shrinks the size of the data and log files in the specified database. Incorrect Answers: D: To shrink one data or log file at a time for a specific database, execute the DBCC SHRINKFILE command…
Submitted by katya_ua· Mar 6, 2026Perform administration by using T-SQL
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?
Options
- ADBCC SHRINKDATABASE
- Bsp_clean_db_free_space
- Csp_clean_db_file_free_space
- DDBCC SHRINKFILE
How the community answered
(36 responses)- A92% (33)
- B6% (2)
- D3% (1)
Explanation
DBCC SHRINKDATABASE shrinks the size of the data and log files in the specified database. Incorrect Answers: D: To shrink one data or log file at a time for a specific database, execute the DBCC SHRINKFILE command. https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-shrinkdatabase-
Community Discussion
No community discussion yet for this question.