Microsoft DP-700 Practice Test 22
Question 210
A source and destination use different column names. Where should the copy mapping be corrected?
- Configure the Copy Data activity's explicit source-to-sink column mapping.
- Use supported source filtering or parameterized paths to select the intended incremental file set.
- Tune copy parallelism and source concurrency within the service's documented limits.
- Add a Dataflow activity dependent on successful Copy Data completion.
Explanation
Correct Answer
A:Column mapping aligns source fields to the target schema; changing the schedule does not repair a name mismatch. Run a test copy and inspect field-level values.
Incorrect Answers
B:Narrowing source selection reduces avoidable transfer and keeps the extraction aligned to the actual batch.
C:Excessive concurrent reads can cause throttling; maximum parallelism is not always optimal throughput.
D:The pipeline can coordinate ingestion and subsequent dataflow transformation as separate dependent steps.
Question 211
A copy into a warehouse fails with an authentication message after credential rotation. What should be updated?
- Inspect activity rows read and written plus source filters and mapping statistics.
- Bind the destination table reference to a validated pipeline parameter or expression.
- Refresh the connection credentials referenced by the relevant pipeline activity.
- Use supported source filtering or parameterized paths to select the intended incremental file set.
Explanation
Correct Answer
C:Pipeline data movement uses saved connections; a changed password or secret invalidates activity authentication. Test the connection before replaying the failed load.
Incorrect Answers
A:Success means the transfer operation completed according to its configuration, not necessarily that business completeness matched expectations.
B:Parameterizing the sink avoids duplicated copy definitions for each target while controlling the resolved destination.
D:Narrowing source selection reduces avoidable transfer and keeps the extraction aligned to the actual batch.
Question 212
A storage source supplies only recently modified files, but copying its entire folder wastes time. What should be adjusted?
- Bind the destination table reference to a validated pipeline parameter or expression.
- Tune copy parallelism and source concurrency within the service's documented limits.
- Use supported source filtering or parameterized paths to select the intended incremental file set.
- Refresh the connection credentials referenced by the relevant pipeline activity.
Explanation
Correct Answer
C:Narrowing source selection reduces avoidable transfer and keeps the extraction aligned to the actual batch. Compare source files selected across consecutive runs.
Incorrect Answers
A:Parameterizing the sink avoids duplicated copy definitions for each target while controlling the resolved destination.
B:Excessive concurrent reads can cause throttling; maximum parallelism is not always optimal throughput.
D:Pipeline data movement uses saved connections; a changed password or secret invalidates activity authentication.
Question 213
A large copy job is saturating a constrained source API. Which control should be adjusted first?
- Refresh the connection credentials referenced by the relevant pipeline activity.
- Tune copy parallelism and source concurrency within the service's documented limits.
- Use supported source filtering or parameterized paths to select the intended incremental file set.
- Add a Dataflow activity dependent on successful Copy Data completion.
Explanation
Correct Answer
B:Excessive concurrent reads can cause throttling; maximum parallelism is not always optimal throughput. Watch source throttling alongside throughput.
Incorrect Answers
A:Pipeline data movement uses saved connections; a changed password or secret invalidates activity authentication.
C:Narrowing source selection reduces avoidable transfer and keeps the extraction aligned to the actual batch.
D:The pipeline can coordinate ingestion and subsequent dataflow transformation as separate dependent steps.
Question 214
A pipeline should invoke a Dataflow Gen2 refresh after raw ingestion completes. What activity sequence fits?
- Use supported source filtering or parameterized paths to select the intended incremental file set.
- Add a Dataflow activity dependent on successful Copy Data completion.
- Tune copy parallelism and source concurrency within the service's documented limits.
- Bind the destination table reference to a validated pipeline parameter or expression.
Explanation
Correct Answer
B:The pipeline can coordinate ingestion and subsequent dataflow transformation as separate dependent steps. Validate a deliberate failure prevents the downstream refresh.
Incorrect Answers
A:Narrowing source selection reduces avoidable transfer and keeps the extraction aligned to the actual batch.
C:Excessive concurrent reads can cause throttling; maximum parallelism is not always optimal throughput.
D:Parameterizing the sink avoids duplicated copy definitions for each target while controlling the resolved destination.
Question 215
A reusable copy pipeline must select the target table based on a run parameter. What should its destination use?
- Bind the destination table reference to a validated pipeline parameter or expression.
- Use supported source filtering or parameterized paths to select the intended incremental file set.
- Tune copy parallelism and source concurrency within the service's documented limits.
- Inspect activity rows read and written plus source filters and mapping statistics.
Explanation
Correct Answer
A:Parameterizing the sink avoids duplicated copy definitions for each target while controlling the resolved destination. Test two table names against a nonproduction workspace.
Incorrect Answers
B:Narrowing source selection reduces avoidable transfer and keeps the extraction aligned to the actual batch.
C:Excessive concurrent reads can cause throttling; maximum parallelism is not always optimal throughput.
D:Success means the transfer operation completed according to its configuration, not necessarily that business completeness matched expectations.
Question 216
A pipeline's copy activity reports success, but an analyst sees fewer records than the source. What should be compared?
- Add a Dataflow activity dependent on successful Copy Data completion.
- Tune copy parallelism and source concurrency within the service's documented limits.
- Inspect activity rows read and written plus source filters and mapping statistics.
- Bind the destination table reference to a validated pipeline parameter or expression.
Explanation
Correct Answer
C:Success means the transfer operation completed according to its configuration, not necessarily that business completeness matched expectations. Reconcile source and target counts for the run.
Incorrect Answers
A:The pipeline can coordinate ingestion and subsequent dataflow transformation as separate dependent steps.
B:Excessive concurrent reads can cause throttling; maximum parallelism is not always optimal throughput.
D:Parameterizing the sink avoids duplicated copy definitions for each target while controlling the resolved destination.
Question 217
A dashboard frequently joins five tiny lookup tables to display one order view. What curated pattern can simplify the read path?
- Normalize event timestamps to an agreed timezone before computing monthly buckets.
- Use COUNT DISTINCT on the customer key at the intended reporting grain.
- Materialize a controlled denormalized serving table at a declared order grain.
- Preaggregate events by site and day using a suitable grouped query.
Explanation
Correct Answer
C:Denormalization can reduce repetitive read-time joins when duplicate dimension attributes are managed deliberately. Validate the order key remains unique.
Incorrect Answers
A:Month boundaries can differ by timezone; consistent conversion prevents cross-region reporting discrepancies.
B:Counting transaction rows overstates the population when a customer has multiple events.
D:Aggregates reduce scanned rows for common reporting grains while retaining raw data elsewhere for detail.
Question 218
A report needs daily site-level event totals rather than billions of individual events. What transformation cuts query volume?
- Preaggregate events by site and day using a suitable grouped query.
- Join the dimension on both business key and the applicable effective-date range.
- Standardize category values using a maintained mapping before GROUP BY.
- Materialize a controlled denormalized serving table at a declared order grain.
Explanation
Correct Answer
A:Aggregates reduce scanned rows for common reporting grains while retaining raw data elsewhere for detail. Compare sums against the raw event population.
Incorrect Answers
B:Temporal joins identify the correct historical version and prevent multiplying facts across dimension versions.
C:Canonical categories prevent semantic duplicates that would otherwise split business totals.
D:Denormalization can reduce repetitive read-time joins when duplicate dimension attributes are managed deliberately.
Question 219
A metric should count distinct customer accounts, not transaction lines. Which grouping expression is necessary?
- Join the dimension on both business key and the applicable effective-date range.
- Use COUNT DISTINCT on the customer key at the intended reporting grain.
- Standardize category values using a maintained mapping before GROUP BY.
- Materialize a controlled denormalized serving table at a declared order grain.
Explanation
Correct Answer
B:Counting transaction rows overstates the population when a customer has multiple events. Test one customer with several transactions.
Incorrect Answers
A:Temporal joins identify the correct historical version and prevent multiplying facts across dimension versions.
C:Canonical categories prevent semantic duplicates that would otherwise split business totals.
D:Denormalization can reduce repetitive read-time joins when duplicate dimension attributes are managed deliberately.
Question 220
A product category table has multiple effective-dated versions. Joining it to facts without date criteria doubles revenue. What should be added?
- Preaggregate events by site and day using a suitable grouped query.
- Resolve promotion allocation or bridge grain before aggregating additive fact measures.
- Keep transaction-level raw or curated detail alongside the aggregated serving table.
- Join the dimension on both business key and the applicable effective-date range.
Explanation
Correct Answer
D:Temporal joins identify the correct historical version and prevent multiplying facts across dimension versions. Check historical transactions around a version boundary.
Incorrect Answers
A:Aggregates reduce scanned rows for common reporting grains while retaining raw data elsewhere for detail.
B:Many-to-many joins multiply amounts unless the relationship and allocation are handled explicitly.
C:A summary supports fast trends but cannot replace detailed records needed to explain a total or investigate anomalies.
