Data Engineering on Microsoft Azure — Question 138

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. replicated
• B. hash distributed
• C. heap
• D. round-robin

Correct answer: A

Explanation

A replicated table is the best choice for this scenario as it ensures that every compute node has a full copy of the table, which significantly speeds up query performance and minimizes data movement. Hash distributed and round-robin tables may not provide the same level of performance efficiency for queries, and a heap table lacks the structured organization needed for optimal querying.