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? 

Answer options:

A.DBCC PDW_SHOWSPACEUSED
B.DBCC PDW_SHOWPARTITIONSTATS
C.DBCC PDW_SHOWEXECUTIONPLAN
D.None of the above

Correct Answer: A 

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