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 :
A. You can enable or disable ROW or PAGE compression in online state only
B. When you are compressing indexes, leaf-level pages can be compressed with both row and page compression
C. Non–leaf-level pages do not receive page compression.
D. None of the mentioned
Answer:A
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 :
A. You can enable or disable ROW or PAGE compression in online state only B. When you are compressing indexes, leaf-level pages can be compressed with both row and page compression C. Non–leaf-level pages do not receive page compression. D. None of the mentioned
Explanation:Enabling compression on a heap is single threaded for an online operation. 6. The data_compression and data_compression_desc columns include :