DP-203 Certification Practice Question #15

Question

You have a SQL pool in Azure Synapse.
You plan to load data from Azure Blob storage to a staging table. Approximately 1 million rows of data will be loaded daily. The table will be truncated before each daily load.
You need to create the staging table. The solution must minimize how long it takes to load the data to the staging table.
How should you configure the table? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Accepted Answer

This is a textbook transient staging-table scenario in dedicated SQL pool: load quickly, then discard and reload the next day. Microsoft Learn explicitly recommends round-robin distribution for staging tables because it loads fast, and a heap because there is no index maintenance overhead during ingestion. Since the table is truncated before every load, partitioning provides no operational benefit and only adds complexity. The overwhelming community consensus matches the official guidance.

More DP-203 practice questions