DP-203 Certification Practice Question #258

Question

You manage an enterprise data warehouse in Azure Synapse Analytics.
Users report slow performance when they run commonly used queries. Users do not report performance changes for infrequently used queries.
You need to monitor resource utilization to determine the source of the performance issues.
Which metric should you monitor?

Accepted Answer

If the scenario requires structured data to land in a defined target schema instead of copying files unchanged, explicit mapping is the right answer because it lets the pipeline align source fields to sink columns deliberately. Binary copy is only correct when the file should be transferred as-is. Because nearby questions in this domain can swing between those two patterns, I keep confidence moderate rather than extremely high.

More DP-203 practice questions