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. - Minimi

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

Submitted by skyler.x· Mar 30, 2026Design and implement data storage

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

How the community answered

(49 responses)

A
10% (5)
B
2% (1)
C
84% (41)
D
4% (2)

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

Topics

#replicated table#table distribution#Synapse dedicated pool#query performance

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice