Microsoft Exam DP-300 Topic 8 Question 20 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 20
Topic #: 8

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?

ADBCC SHRINKDATABASE

Bsp_clean_db_free_space

Csp_clean_db_file_free_space

DDBCC SHRINKFILE

Show Suggested Answer

Suggested Answer: A

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.

by Staci at May 08, 2022, 12:36 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!