Explanation:SQL Server 2014 supports columnstore and columnstore archival compression for columnstore tables and indexes. 2. Point out the correct statement :
A. The details of data compression are subject to change without notice in service packs or subsequent releases
B. Compression is not available for system tables
C. If you specify a list of partitions or a partition that is out of range, an error will be generated.
D. All of the mentioned
Answer:A
Explanation:SQL Server 2014 supports columnstore and columnstore archival compression for columnstore tables and indexes. 2. Point out the correct statement :
A. The details of data compression are subject to change without notice in service packs or subsequent releases B. Compression is not available for system tables C. If you specify a list of partitions or a partition that is out of range, an error will be generated. D. All of the mentioned
Explanation:These are considerations made before using row and page compression. 3. Use _________ data compression to compress columnstore data with archival compression.