Question

You have a traditional data warehouse storage with a snowflake schema with row-oriented storage that takes considerable time and low performance during queries. You plan to use clustered columnstore indexing. Will it improve query performance?

A. Yes

B. No

Answer 1

Correct Answer: A

Reason:-

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 of 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 query performance.