DP-203 Certification Practice Question #8

Question

You have a data model that you plan to implement in a data warehouse in Azure Synapse Analytics as shown in the following exhibit.

All the dimension tables will be less than 2 GB after compression, and the fact table will be approximately 6 TB. The dimension tables will be relatively static with very few data inserts and updates.
Which type of table should you use for each table? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Accepted Answer

For a small dimension that is joined repeatedly to larger fact tables, Microsoft Learn guidance is clear: replication is usually the best distribution strategy in dedicated SQL pool. It places the full table on each compute node and avoids data movement during joins, which is exactly the optimization intended for small dimensions. That makes the replicated-table option the strongest answer.

More DP-203 practice questions