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?

Answer options:

A.COLUMNSTORE 
B.COLUMNSTORE_ARCHIVE
C.COLUMNSTORE_COMPRESS
D.COLUMNSTORE_ARCHIVECOMPRESS
E.Archival compression can’t be configured for the columnstore data.

Correct Answer: B 
COLUMNSTORE_ARCHIVE data compression is used to compress columnstore data with the help of archival compression. 
For example: 

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: 

https://docs.microsoft.com/en-us/sql/relational-databases/data-compression/data-compression?view=sql-server-ver15