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?
For staging tables in Azure Synapse Analytics, a round-robin distributed table is recommended. This is because round-robin distribution allows data to be evenly distributed across all nodes, which optimizes the loading performance by balancing the workload. This makes it ideal for scenarios involving the initial loading of large volumes of data before further processing or transformation.
From https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-overview: Use round-robin for the staging table. The load with CTAS is fast. Once the data is in the staging table, use INSERT...SELECT to move the data to production tables.
keyword is staging table
answer is correct its specifically asked for fast loading , not read, which leads to round robin being the correct answer
round robin is entirely correct for staging tables
keyword --> staging table --> round robin is best