You have an Azure Synapse Analytics dedicated SQL pool named Pool1. Pool1 contains a table named table1. You load 5 TB of data intotable1. You need to ensure that columnstore compression is…

The correct answer is B. ALTER INDEX ALL on table1 REBUILD. This statement will rebuild all indexes on table1, which can help to maximize columnstore compression. The other options are not appropriate for this task. DBCC INDEXDEFRAG (pool1, table1) is for defragmenting the indexes and DBCC DBREINDEX (table1) is for recreating the…

Submitted by chen.hong· Mar 30, 2026Secure, monitor, and optimize data storage and data processing

Question

You have an Azure Synapse Analytics dedicated SQL pool named Pool1. Pool1 contains a table named table1. You load 5 TB of data intotable1. You need to ensure that columnstore compression is maximized for table1. Which statement should you execute?

Options

AALTER INDEX ALL on table1 REORGANIZE
BALTER INDEX ALL on table1 REBUILD
CDBCC DBREINOEX (table1)
DDBCC INDEXDEFRAG (pool1, table1)

How the community answered

(14 responses)

B
79% (11)
C
7% (1)
D
14% (2)

Explanation

This statement will rebuild all indexes on table1, which can help to maximize columnstore compression. The other options are not appropriate for this task. DBCC INDEXDEFRAG (pool1, table1) is for defragmenting the indexes and DBCC DBREINDEX (table1) is for recreating the indexes. ALTER INDEX ALL on table1 REORGANIZE is for reorganizing the indexes.

Topics

#Synapse Analytics#columnstore compression#index rebuild#SQL pool

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice