DP-203 · Question #263
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…
The correct answer is A. Yes. 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 There are two advantages of using this while comparing with a traditional row-oriented Data…
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?
Options
- AYes
- BNo
How the community answered
(33 responses)- A76% (25)
- B24% (8)
Explanation
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 There are two advantages of using this while comparing with a traditional row-oriented Data 10x performance in query performance 10 x data compression Option A is correct: Using clustered columnstore will increase the query performance. https://docs.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes- overview?view=sql-server-ver15
Topics
Community Discussion
No community discussion yet for this question.