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
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