Using Archival Compression for Columnstore Tables
Question
You are working on a Columnstore table.
Although the columnstore indexes and tables are saved with the columnstore compression always, you are interested in further decreasing the columnstore data size.
For this purpose, you decide to configure an add-on compression known as archival compression.
Which of the following method would you use to compress the data by using the archival compression?
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D. E.Correct Answer: B
COLUMNSTORE_ARCHIVE data compression is used to compress columnstore data with the help of archival compression.
For example:
/answer/imgckeditor_5.png)
Option A is incorrect.
COLUMNSTORE data compression is used to decompress the archival compression.
Option B is correct.
COLUMNSTORE_ARCHIVE data compression is used to compress columnstore data using archival compression.
Option C is incorrect.
There is no valid method like COLUMNSTORE_COMPRESS.
Option D is incorrect.
The right method is COLUMNSTORE_ARCHIVE, not COLUMNSTORE_ARCHIVECOMPRESS.
Option E is incorrect.
Archival compression can be configured for the columnstore data.
It will further decrease the columnstore data size.
Reference:
To know more about Data Compression, please visit the below-given link:
Archival compression is an additional compression method that can be used to further decrease the data size of columnstore tables in Microsoft Azure. The archival compression method is different from the columnstore compression that is applied by default to columnstore indexes and tables.
To use archival compression, the COLUMNSTORE_ARCHIVE option should be used. Therefore, the correct answer to this question is option B: COLUMNSTORE_ARCHIVE.
Option A, COLUMNSTORE, is the default compression method used for columnstore indexes and tables, but it does not refer to the archival compression method.
Option C, COLUMNSTORE_COMPRESS, is not a valid compression option for columnstore tables. It is possible that this option could be confused with the built-in compression used for rowstore indexes and tables.
Option D, COLUMNSTORE_ARCHIVECOMPRESS, is not a valid compression option for columnstore tables. This option is a combination of the two compression methods and is not supported.
Finally, option E, stating that archival compression can't be configured for the columnstore data, is incorrect. Archival compression is a valid option for reducing the data size of columnstore tables in Microsoft Azure.