DP-300 Certification Practice Question #272

Question

You have an Azure SQL database named DB1.
You need to identify how much unused space in megabytes was allocated to DB1.
How should you complete the Transact-SQL query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Accepted Answer

To calculate the allocated but unused database space in MB in Azure SQL Database, we query the `sys.database_files` view which contains the size of each database file in 8-KB pages. To convert the size from 8-KB pages to Megabytes, we divide by `128.0` (8 KB / 1024 KB = 1/128 MB). Subtracting the used space (also divided by `128.0` to convert to MB) yields the allocated unused space in MB.

More DP-300 practice questions