Exit DP-203 Data Engineering on Microsoft Azure
Question 1 of 5
0% complete
Q1 Single choice

You have an Azure Synapse Analytics dedicated SQL pool named Pool1. Pool1 contains a table named table1.

You load 5 TB of data into table1.

You need to ensure that columnstore compression is maximized for table1.

Which statement should you execute?

  • A

    DBCC INDEXDEFRAG (pool1, table1)

  • B

    DBCC DBREINDEX (table1)

  • C

    ALTER INDEX ALL on table1 REORGANIZE

  • D

    ALTER INDEX ALL on table1 REBUILD

Previous Next