DP-203 Certification Practice Question #290

Question

You need to design an analytical storage solution for the transactional data. The solution must meet the sales transaction dataset requirements.
What should you include in the solution? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Accepted Answer

Retail store data behaves like a relatively small dimension table, which is best replicated across distributions to avoid data movement during joins. Promotional data is the larger/join-oriented dataset, so hash distribution is the preferred design for scalable analytical performance. That matches the strong community consensus and the Synapse distribution guidance.

More DP-203 practice questions