
Ultimate access to all questions.
You have an Azure Synapse Analytics dedicated SQL pool named Pool1 that contains a table named table1. After loading 5 TB of data into table1, you need to maximize columnstore compression for the table.
Which Transact-SQL 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