Implementing an Azure Data Solution (legacy) — Question 13

You are designing an enterprise data warehouse in Azure Synapse Analytics. You plan to load millions of rows of data into the data warehouse each day.
You must ensure that staging tables are optimized for data loading.
You need to design the staging tables.
What type of tables should you recommend?

Answer options

• A. Round-robin distributed table
• B. Hash-distributed table
• C. Replicated table
• D. External table

Correct answer: A

Explanation

The Round-robin distributed table is ideal for staging as it evenly distributes data across all distributions, which is beneficial for high-volume data loading. Hash-distributed tables require a specific distribution key, which can complicate the loading process, while replicated tables are not suitable for large datasets due to their limitations in handling massive data efficiently. External tables are used for querying data stored outside of the data warehouse and are not meant for staging purposes.