Does the solution meet the goal?

You have a data warehouse that stores sales data. One fact table has 100 million rows. You must reduce storage needs for the data warehouse. You need to implement a solution that uses column-based storage and provides real-time

analytics for the operational workload.

Solution: You implement a columnstore index on the fact table.

Does the solution meet the goal?
A . Yes
B . No

View Answer

Answer: A

Explanation:

Columnstore indexes are the standard for storing and querying large data warehousing fact tables. It uses column-based data storage and query processing to achieve up to 10x query performance gains in your data warehouse over traditional row-oriented storage, and up to 10x data compression over the uncompressed data size.

In SQL Server, rowstore refers to table where the underlying data storage format is a heap, a clustered index, or a memory-optimized table.

References: https://docs.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-overview