Question
Why are columnstore structures particularly suitable for large warehouse fact tables?
Select an option. Your answer will be checked instantly.
Correct Answer: B. They compress and scan selected columns efficiently for analytical queries
Explanation:
Analytical queries often read a few columns across many rows.
Column-oriented storage improves compression, batch processing, and scan performance.
Leave a Reply