DP-203 Certification Practice Question #71

Question

You are incrementally loading data into fact tables in an Azure Synapse Analytics dedicated SQL pool.

Each batch of incoming data is staged before being loaded into the fact tables.

You need to ensure that the incoming data is staged as quickly as possible.

How should you configure the staging tables? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Accepted Answer

For transient staging in a dedicated SQL pool, Microsoft guidance is straightforward: use round-robin distribution for the fastest loading pattern, then move data into production structures later. Pairing that with a heap keeps inserts cheap by avoiding clustered index or columnstore maintenance during the ingest step. The community answer and official design guidance align closely here.

More DP-203 practice questions