Implementing an Azure Data Solution (legacy) — Question 17

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?

Answer options

• A. hash distributed
• B. heap
• C. replicated
• D. round-robin

Correct answer: D

Explanation

The round-robin distribution method is optimal for this scenario as it evenly distributes data across all nodes without the need for data movement, leading to faster query times. In contrast, hash distributed tables require data shuffling for joins, heaps do not optimize data retrieval, and replicated tables are better suited for smaller datasets where the entire table is copied, which isn't necessary in this case.