Question
Which workload benefits most from a columnstore index?
Select an option. Your answer will be checked instantly.
Correct Answer: C. Large analytical scans and aggregations over a fact table
Explanation:
Columnstore organizes and compresses data by column and processes it in batches.
This design is highly effective for warehouse-scale aggregation queries.
Leave a Reply