DP-203 · Question #34
DP-203 Question #34: Real Exam Question with Answer & Explanation
Sign in or unlock DP-203 to reveal the answer and full explanation for question #34. The question stem and answer options stay visible for context.
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?
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
Unlock DP-203 to see the answer
You've previewed enough free DP-203 questions. Unlock DP-203 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.