A dedicated Synapse pool has expensive cross-node data movement during joins. What should the architect inspect before only increasing capacity?

Choose the single best answer.

A.Only ingestion schedule changes, assuming they fix every cross-node join
B.Table distribution, data movement, indexing, and query design
C.Only adding warehouse capacity, without examining distributed joins
D.Only the number of cataloged tables without inspecting data placement

Show the answer and explanation

✓ Correct answer

Table distribution, data movement, indexing, and query design

Distributed warehouse performance depends on table placement, movement, indexing, and queries. Catalog counts do not reveal the bottleneck. Capacity can help but may preserve inefficient data movement, and changing ingestion schedule does not automatically fix distributed join execution. Source guide: PDF page 34.

Read the source reference

This item is flagged for content review.

Read and review here, or open the app to practise and save your results on this device.

Practise in the app

Unofficial study aid; not affiliated with or endorsed by Microsoft. Original practice questions are not real examination questions and do not guarantee an exam result.