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

Question

You have a Fabric workspace that contains a lakehouse and a semantic model named Model1. You use a notebook named Notebook1 to ingest and transform data from an external data source. You need to execute Notebook1 as part of a data pipeline named Pipeline1. The process must meet the following requirements: - Run daily at 07:00 AM UTC. - Attempt to rerun Notebook1 twice if the notebook fails. - After Notebook1 executes successfully, refresh Model1. Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Options

• APlace the Semantic model refresh activity after the Notebook activity and link the activities by using the On success condition.
• BFrom the Schedule setting of Pipeline1, set the time zone to UTC.
• CSet the Retry setting of the Notebook activity to 2.
• DFrom the Schedule setting of Notebook1, set the time zone to UTC.
• ESet the Retry setting of the Semantic model refresh activity to 2.
• FPlace the Semantic model refresh activity after the Notebook activity and link the activities by using an On completion condition.

Explanation

To orchestrate a daily data pipeline in Fabric that runs a notebook, retries on failure, and then conditionally refreshes a semantic model, you must configure the pipeline's schedule, set retries on the notebook activity, and link the refresh activity on success.

Common mistakes.

• D. Setting the schedule for Notebook1 directly is not how notebooks are scheduled within a pipeline; the pipeline's schedule controls its execution.
• E. The retry requirement specifically states for 'Notebook1 if the notebook fails,' not for the Semantic model refresh activity.
• F. Linking activities with an 'On completion' condition would trigger the semantic model refresh regardless of whether the notebook succeeded or failed, which violates the requirement to refresh after Notebook1 executes successfully.

Concept tested. Fabric pipeline orchestration, scheduling, retries, and conditional execution

Reference. https://learn.microsoft.com/en-us/fabric/data-factory/orchestrate-data-pipelines#schedule-your-pipeline

No community discussion yet for this question.