A company has a Power BI semantic model that refreshes from a Fabric warehouse. The refresh sometimes fails due to a temporary connection issue. The business users want to know as soon as a refresh fails, but they do not want to be alerted for scheduled maintenance windows. What should the administrator configure?

An alert on the warehouse's data ingestion pipeline

A refresh alert that triggers on any refresh completion

A custom email notification in the semantic model's refresh script

A Fabric alert rule on the semantic model refresh with a condition for failure and a custom schedule that excludes maintenance windows

A data engineer uses a Fabric dataflow (Gen2) to transform data. The dataflow runs successfully, but the output data is incorrect. The engineer suspects that a specific transformation step is not working as expected. What should the engineer do to identify the issue?

Use the Fabric monitoring hub to see the dataflow's status and duration.

Review the dataflow run history and inspect the output of each transformation step.

Check the semantic model refresh history to see if the refresh is using the correct data.

Review the pipeline run details if the dataflow is part of a pipeline.

A data engineering team has a Fabric pipeline that ingests data from a source system and then runs a dataflow to transform it. The pipeline runs successfully, but the team notices that the transformed data has duplicate rows. They suspect the source system sent duplicate files. The team wants to be alerted if duplicates are detected in the future. What should they do?

Add a dataflow step to remove duplicates and then configure an alert on the dataflow's row count

Configure an alert rule on the pipeline that triggers when the number of files ingested exceeds a threshold

Use a dataflow's built-in duplicate detection and configure an alert on the dataflow's output

Add a custom notebook after the dataflow that checks for duplicate rows and sends an alert if any are found

Microsoft Certified:Fabric Data Engineer Associate

Domain 3Objective 1

Monitor Fabric Items DP-700 Practice Questions (Page 4)

Part of the Monitor and optimize an analytics solution domain, which accounts for 30–35% of the DP-700 exam. Microsoft does not publish an official question count, but from its 100-minute exam (~40–65 total, ~12–23 in this domain), expect 4–8 from this objective — we provide 18 practice questions to prepare you well beyond it. (estimate)

18questions here

4free pages

4concepts

30–35%of the exam

Questions 16–18

16application · medium
A company has a Power BI semantic model that refreshes from a Fabric warehouse. The refresh sometimes fails due to a temporary connection issue. The business users want to know as soon as a refresh fails, but they do not want to be alerted for scheduled maintenance windows. What should the administrator configure?
Select an answer first
17application · medium
A data engineer uses a Fabric dataflow (Gen2) to transform data. The dataflow runs successfully, but the output data is incorrect. The engineer suspects that a specific transformation step is not working as expected. What should the engineer do to identify the issue?
Select an answer first
18expert · medium
A data engineering team has a Fabric pipeline that ingests data from a source system and then runs a dataflow to transform it. The pipeline runs successfully, but the team notices that the transformed data has duplicate rows. They suspect the source system sent duplicate files. The team wants to be alerted if duplicates are detected in the future. What should they do?
Select an answer first

Finished these 3 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to DP-700

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-700” is a trademark of its owner, used for identification only.

Monitor Fabric Items DP-700 Practice Questions (Page 4)

Questions 16–18

A data engineer uses a Fabric dataflow (Gen2) to transform data. The dataflow runs successfully, but the output data is incorrect. The engineer suspects that a specific transformation step is not working as expected. What should the engineer do to identify the issue?

Keep studying — Monitor and optimize an analytics solution