Explanation:To perform archival compression, SQL Server runs the Microsoft XPRESS compression algorithm on the data. 4. To remove archival compression and restore the data to columnstore compression :
A. Use ALTER TABLE
B. Use ALTER COLUMN
C. Use ALTER DATABASE
D. All of the mentioned
Answer:A
Explanation:To perform archival compression, SQL Server runs the Microsoft XPRESS compression algorithm on the data. 4. To remove archival compression and restore the data to columnstore compression :
A. Use ALTER TABLE B. Use ALTER COLUMN C. Use ALTER DATABASE D. All of the mentioned
Explanation:use ALTER TABLE (Transact-SQL) or ALTER INDEX (Transact-SQL) with the REBUILD option and DATA COMPRESSION = COLUMNSTORE. 5. Point out the wrong statement :