Question

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?

A. DBCC PDW_SHOWSPACEUSED

B. DBCC PDW_SHOWPARTITIONSTATS

C. DBCC PDW_SHOWEXECUTIONPLAN

D. None of the above

Answer 1

Correct Answer: A

Reason:-

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.

Sources:: 

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