Microsoft DP-700 Practice Test 13
Question 120
A notebook activity must receive the pipeline's run date. How should the value cross the activity boundary?
- Use explicit expression-language type conversion before the numeric comparison.
- Use a dynamic expression referencing supported pipeline run metadata.
- Use an If Condition activity with an expression against the prior activity's result.
- Map a pipeline parameter or expression into the notebook activity's base parameters.
Explanation
Correct Answer
D:Notebook arguments must be explicitly supplied by the orchestrator; a notebook cannot safely assume the pipeline's parameter is a global variable. Inspect notebook parameter values in execution logs.
Incorrect Answers
A:String comparisons can produce incorrect threshold decisions when numeric values have not been converted.
B:Run metadata is available to pipeline expressions and creates traceable, per-run destinations.
C:Conditional branching expresses execution logic based on data or metadata instead of running both branches unconditionally.
Question 121
An activity should write to a folder based on the current pipeline run ID. Which feature constructs the name?
- Use explicit expression-language type conversion before the numeric comparison.
- Externalize the environment-specific endpoint through a parameter or supported variable library.
- Use an If Condition activity with an expression against the prior activity's result.
- Use a dynamic expression referencing supported pipeline run metadata.
Explanation
Correct Answer
D:Run metadata is available to pipeline expressions and creates traceable, per-run destinations. Verify two runs produce different intended paths.
Incorrect Answers
A:String comparisons can produce incorrect threshold decisions when numeric values have not been converted.
B:Configuration values should vary by stage without hand-editing core orchestration logic.
C:Conditional branching expresses execution logic based on data or metadata instead of running both branches unconditionally.
Question 122
A copy activity needs a value produced by a preceding lookup activity. What should its expression reference?
- Define a country parameter and use it in a dynamic dataset or path expression.
- Use an If Condition activity with an expression against the prior activity's result.
- Externalize the environment-specific endpoint through a parameter or supported variable library.
- Read the upstream activity output using the pipeline expression language after enforcing success dependency.
Explanation
Correct Answer
D:Activity outputs can parameterize downstream operations when their completion and output schema are handled explicitly. Inspect the lookup output and resolved copy source.
Incorrect Answers
A:Runtime parameters separate variable input paths from reusable activity logic.
B:Conditional branching expresses execution logic based on data or metadata instead of running both branches unconditionally.
C:Configuration values should vary by stage without hand-editing core orchestration logic.
Question 123
A generic ingestion pipeline should branch based on whether a returned row count is zero. Which mechanism should route the branches?
- Use an If Condition activity with an expression against the prior activity's result.
- Map a pipeline parameter or expression into the notebook activity's base parameters.
- Externalize the environment-specific endpoint through a parameter or supported variable library.
- Use explicit expression-language type conversion before the numeric comparison.
Explanation
Correct Answer
A:Conditional branching expresses execution logic based on data or metadata instead of running both branches unconditionally. Test zero-row and nonzero-row cases.
Incorrect Answers
B:Notebook arguments must be explicitly supplied by the orchestrator; a notebook cannot safely assume the pipeline's parameter is a global variable.
C:Configuration values should vary by stage without hand-editing core orchestration logic.
D:String comparisons can produce incorrect threshold decisions when numeric values have not been converted.
Question 124
A pipeline expression unexpectedly treats an integer source value as text during a comparison. What should be corrected?
- Use explicit expression-language type conversion before the numeric comparison.
- Use an If Condition activity with an expression against the prior activity's result.
- Map a pipeline parameter or expression into the notebook activity's base parameters.
- Define a country parameter and use it in a dynamic dataset or path expression.
Explanation
Correct Answer
A:String comparisons can produce incorrect threshold decisions when numeric values have not been converted. Test values such as 9 and 12 to detect lexical ordering.
Incorrect Answers
B:Conditional branching expresses execution logic based on data or metadata instead of running both branches unconditionally.
C:Notebook arguments must be explicitly supplied by the orchestrator; a notebook cannot safely assume the pipeline's parameter is a global variable.
D:Runtime parameters separate variable input paths from reusable activity logic.
Question 125
A promoted pipeline references a development storage endpoint embedded in its expression. What should be introduced?
- Use a dynamic expression referencing supported pipeline run metadata.
- Use explicit expression-language type conversion before the numeric comparison.
- Read the upstream activity output using the pipeline expression language after enforcing success dependency.
- Externalize the environment-specific endpoint through a parameter or supported variable library.
Explanation
Correct Answer
D:Configuration values should vary by stage without hand-editing core orchestration logic. Confirm the deployed stage resolves its own endpoint.
Incorrect Answers
A:Run metadata is available to pipeline expressions and creates traceable, per-run destinations.
B:String comparisons can produce incorrect threshold decisions when numeric values have not been converted.
C:Activity outputs can parameterize downstream operations when their completion and output schema are handled explicitly.
Question 126
A transform should start only after two independent extracts have both succeeded. Which orchestration rule is required?
- Set the transform activity's success dependencies on both extraction activities.
- Configure a bounded retry policy with delay on the affected activity.
- Invoke the child pipeline with its declared parameter values.
- Control iteration concurrency and execution batching rather than launching every partition simultaneously.
Explanation
Correct Answer
A:Explicit dependencies prevent downstream work from consuming incomplete upstream outputs. Simulate failure in either extract and verify transform is skipped.
Incorrect Answers
B:Transient errors can be retried safely when the operation and destination are idempotent; infinite immediate retries are unsafe.
C:Parameter passing makes reusable child pipelines context-aware without cloning their definition.
D:Bounded parallelism protects capacity and source throttling while retaining throughput for independent partitions.
Question 127
An API copy fails briefly because the service throttles requests. Which recovery design is appropriate?
- Use a conditional branch and a Fail activity for the rejected validation outcome.
- Invoke the child pipeline with its declared parameter values.
- Configure a bounded retry policy with delay on the affected activity.
- Encapsulate the sequence in a parameterized child pipeline invoked from parent pipelines.
Explanation
Correct Answer
C:Transient errors can be retried safely when the operation and destination are idempotent; infinite immediate retries are unsafe. Confirm a retry succeeds without duplicated target records.
Incorrect Answers
A:An explicit failure state prevents a bad batch from appearing successfully processed to downstream monitoring.
B:Parameter passing makes reusable child pipelines context-aware without cloning their definition.
D:Child pipeline composition centralizes execution logic and supports reuse with different inputs.
Question 128
A child pipeline is reused by multiple parent workflows and needs a different batch identifier per invocation. What should the parent do?
- Configure a bounded retry policy with delay on the affected activity.
- Set the transform activity's success dependencies on both extraction activities.
- Attach a failure-path activity that performs the approved cleanup or notification.
- Invoke the child pipeline with its declared parameter values.
Explanation
Correct Answer
D:Parameter passing makes reusable child pipelines context-aware without cloning their definition. Inspect the child's recorded parameter values.
Incorrect Answers
A:Transient errors can be retried safely when the operation and destination are idempotent; infinite immediate retries are unsafe.
B:Explicit dependencies prevent downstream work from consuming incomplete upstream outputs.
C:A failure dependency handles the abnormal path; a success-only branch cannot guarantee cleanup on errors.
Question 129
A long-running notebook fails and a compensating cleanup must execute. Which dependency branch should be configured?
- Control iteration concurrency and execution batching rather than launching every partition simultaneously.
- Invoke the child pipeline with its declared parameter values.
- Configure a bounded retry policy with delay on the affected activity.
- Attach a failure-path activity that performs the approved cleanup or notification.
Explanation
Correct Answer
D:A failure dependency handles the abnormal path; a success-only branch cannot guarantee cleanup on errors. Force a test failure and observe the recovery activity.
Incorrect Answers
A:Bounded parallelism protects capacity and source throttling while retaining throughput for independent partitions.
B:Parameter passing makes reusable child pipelines context-aware without cloning their definition.
C:Transient errors can be retried safely when the operation and destination are idempotent; infinite immediate retries are unsafe.
Question 130
A data pipeline processes hundreds of partitions but must limit concurrent runs to protect the source. What should be designed?
- Use a conditional branch and a Fail activity for the rejected validation outcome.
- Invoke the child pipeline with its declared parameter values.
- Set the transform activity's success dependencies on both extraction activities.
- Control iteration concurrency and execution batching rather than launching every partition simultaneously.
Explanation
Correct Answer
D:Bounded parallelism protects capacity and source throttling while retaining throughput for independent partitions. Monitor active partition count and source limits.
Incorrect Answers
A:An explicit failure state prevents a bad batch from appearing successfully processed to downstream monitoring.
B:Parameter passing makes reusable child pipelines context-aware without cloning their definition.
C:Explicit dependencies prevent downstream work from consuming incomplete upstream outputs.
