DP-203 · Question #69
DP-203 Question #69: Real Exam Question with Answer & Explanation
The correct answer is C: replicated. A replicated table has a full copy of the table accessible on each Compute node. Replicating a table removes the need to transfer data among Compute nodes before a join or aggregation. Since the table has multiple copies, replicated tables work best when the table size is less th
Question
You plan to create a dimension table in Azure Synapse Analytics that will be less than 1 GB. You need to create the table to meet the following requirements: - Provide the fastest Query time. - Minimize data movement during queries. Which type of table should you use?
Options
- Ahash distributed
- Bheap
- Creplicated
- Dround-robin
Explanation
A replicated table has a full copy of the table accessible on each Compute node. Replicating a table removes the need to transfer data among Compute nodes before a join or aggregation. Since the table has multiple copies, replicated tables work best when the table size is less than 2 GB compressed. 2 GB is not a hard limit. https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/design-guidance- for-replicated-tables
Community Discussion
No community discussion yet for this question.