Correct Answer: A
Most of the traditional data warehouses use row-oriented storage. But columnstore indexes are used in modern data warehouses as the standard for storage and query in big data warehousing fact tables.
There are two advantages in using this while comparing with a traditional row-oriented Data warehouse. 10x performance in query performance
10 x data compression
Option A is correct: Using clustered columnstore will increase the data compression.
Reference:
For more details on columnstore indexes, please refer to the following document
https://docs.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-overview?view=sql-server-ver15