Explanation:These are considerations made before using row and page compression. 3. Use _________ data compression to compress columnstore data with archival compression.
A. COLUMNSTOREARCHIVE
B. COLUMNSTORE_ARCHIVE
C. COLUMNSTORE
D. All of the mentioned
Answer:A
Explanation:These are considerations made before using row and page compression. 3. Use _________ data compression to compress columnstore data with archival compression.
A. COLUMNSTOREARCHIVE B. COLUMNSTORE_ARCHIVE C. COLUMNSTORE D. All of the mentioned
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 :