Question 59
DP-203 voucher + Udemy course (lifetime access) = ₹3,500 for Indian ID card holders.
Details →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?
- ADBCC INDEXDEFRAG (pool1, table1)
- BDBCC DBREINDEX (table1)
- CALTER INDEX ALL on table1 REORGANIZE
- DALTER INDEX ALL on table1 REBUILD