Sail E0 Webinar
Question
To remove archival compression and restore the data to columnstore compression :
Options:
A .  Use ALTER TABLE
B .  Use ALTER COLUMN
C .  Use ALTER DATABASE
D .  All of the mentioned
Answer: Option A


use ALTER TABLE (Transact-SQL) or ALTER INDEX (Transact-SQL) with the REBUILD option and DATA COMPRESSION = COLUMNSTORE.



Was this answer helpful ?
Next Question

Submit Solution

Your email address will not be published. Required fields are marked *

Latest Videos

Latest Test Papers