nerdexam
Microsoft

DP-700 · Question #93

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

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.

How the community answered

(57 responses)
  • A
    5% (3)
  • B
    70% (40)
  • C
    7% (4)
  • D
    18% (10)

Why each option

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.

AAdd a ForEach activity to the data pipeline.

Adding a ForEach activity is for iterating over a collection and would not directly address intermittent connectivity issues of a single activity.

BConfigure retries for the Copy data activity.Correct

Configuring retries for a Copy data activity allows the activity to automatically attempt execution again a specified number of times if a transient failure, such as a connectivity issue, occurs. This built-in feature handles intermittent problems without requiring additional custom logic or complex development.

CCall a notebook from the data pipeline.

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.

DConfigure Fault tolerance for the Copy data activity.

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

Source: 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 Practice