Which one of the following T-SQL commands is useful to check the disk space usage, data skew used for tables in the SQL data warehouse database?

The correct answer is A. DBCC PDW_SHOWSPACEUSED. Option A is correct because the DBCC PDW_SHOWSPACEUSED T-SQL command is used to display the number of rows, disk space used for tables in SQL DW DBs. Option B is incorrect because DBCC PDW_SHOW PARTITIONSTATS T-SQL command is to display the number of rows & size of each partition

Submitted by tunde_lagos· Mar 30, 2026Secure, monitor, and optimize data storage and data processing

Question

Options

ADBCC PDW_SHOWSPACEUSED
BDBCC PDW_SHOWPARTITIONSTATS
CDBCC PDW_SHOWEXECUTIONPLAN
DNone of the above

How the community answered

(33 responses)

A
76% (25)
B
9% (3)
C
12% (4)
D
3% (1)

Explanation

Option A is correct because the DBCC PDW_SHOWSPACEUSED T-SQL command is used to display the number of rows, disk space used for tables in SQL DW DBs. Option B is incorrect because DBCC PDW_SHOW PARTITIONSTATS T-SQL command is to display the number of rows & size of each partition in the SQL DW table. Option C is incorrect because DBCC PDW_SHOWEXECUTIONPLAN T-SQL command is used to provide SQL server query execution plans in Synapse analytics / PDW. https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-pdw- showexecutionplan-transact-sql?view=azure-sqldw-latest https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-pdw- showpartitionstats transact-sql?view=azure-sqldw-latest https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-pdw- showspaceused transact-sql?toc=/azure/synapse-analytics/sql-data- warehouse/toc.json&bc=/azure/synapse analytics/sql-data- warehouse/breadcrumb/toc.json&view=azure-sqldw-latest&preserve-view=true

Topics

#DBCC PDW_SHOWSPACEUSED#data skew#Azure Synapse#disk space monitoring

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice