DP-203 · Question #34
You implement an enterprise data warehouse in Azure Synapse Analytics. You have a large fact table that is 10 terabytes (TB) in size. Incoming queries use the primary key SaleKey column to retrieve da
The correct answer is B. hash distributed table with clustered Columnstore index. Hash-distributed tables improve query performance on large fact tables. Columnstore indexes can achieve up to 100x better performance on analytics and data warehousing workloads and up to 10x better data compression than traditional rowstore indexes. Incorrect Answers: C, D: Roun
Question
You implement an enterprise data warehouse in Azure Synapse Analytics. You have a large fact table that is 10 terabytes (TB) in size. Incoming queries use the primary key SaleKey column to retrieve data as displayed in the following table:
You need to distribute the large fact table across multiple nodes to optimize performance of the table. Which technology should you use?
Exhibit
Options
- Ahash distributed table with clustered index
- Bhash distributed table with clustered Columnstore index
- Cround robin distributed table with clustered index
- Dround robin distributed table with clustered Columnstore index
- Eheap table with distribution replicate
How the community answered
(55 responses)- A7% (4)
- B75% (41)
- C2% (1)
- D15% (8)
- E2% (1)
Explanation
Hash-distributed tables improve query performance on large fact tables. Columnstore indexes can achieve up to 100x better performance on analytics and data warehousing workloads and up to 10x better data compression than traditional rowstore indexes. Incorrect Answers: C, D: Round-robin tables are useful for improving loading speed. https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-tables-distribute https://docs.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-query-
Topics
Community Discussion
No community discussion yet for this question.