nerdexam
MicrosoftMicrosoft

DP-700 · Question #93

DP-700 Question #93: Real Exam Question with Answer & Explanation

The correct answer is B: Configure retries for the Copy data activity.. To resolve intermittent connectivity issues for a Copy data activity in a data pipeline with minimal development effort, configuring retries for the activity is the most appropriate solution.

Design and implement data ingestion and transformation

Question

You need to recommend a solution to resolve the MAR1 connectivity issues. The solution must minimize development effort. What should you recommend?

Options

  • AAdd a ForEach activity to the data pipeline.
  • BConfigure retries for the Copy data activity.
  • CCall a notebook from the data pipeline.
  • DConfigure Fault tolerance for the Copy data activity.

Explanation

To resolve intermittent connectivity issues for a Copy data activity in a data pipeline with minimal development effort, configuring retries for the activity is the most appropriate solution.

Common mistakes.

  • A. Adding a ForEach activity is for iterating over a collection and would not directly address intermittent connectivity issues of a single activity.
  • C. Calling a notebook from the data pipeline might involve custom logic but introduces more development effort and complexity than simply configuring retries for the existing activity.
  • D. Fault tolerance for a Copy data activity (e.g., skip incompatible rows) is related to handling data inconsistencies or errors during the copy process, not to re-attempting connection for transient connectivity issues.

Concept tested. Data pipeline activity retry policy

Reference. https://learn.microsoft.com/en-us/fabric/data-factory/pipeline-activities

Topics

#Azure Synapse Pipelines#Error Handling#Retries#Copy Data Activity

Community Discussion

No community discussion yet for this question.

Full DP-700 PracticeBrowse All DP-700 Questions