Easy — DP-700 Practice Quiz

Question 1

A nightly Fabric data pipeline that copies data from an on-premises SQL Server to a lakehouse has started failing intermittently. You need to determine which specific activity is failing and view the detailed error message and input/output for that activity run without adding custom logging. Which action should you take first?

Accepted Answer

Open the pipeline's run history in the Monitor hub and drill into the failed run to inspect the individual activity output and error details

Answer

Enable diagnostic settings to stream pipeline logs to an Azure Log Analytics workspace and rebuild dashboards

Answer

Add a Fail activity and a Set Variable activity to capture error messages into a lakehouse table

Answer

Increase the retry count and retry interval on the Copy activity to prevent the failure

Question 2

A data engineer manages a Direct Lake semantic model in Fabric that is scheduled to refresh every morning. Business users have complained that on several occasions they viewed stale data without knowing the scheduled refresh had failed silently overnight. The engineer wants to be automatically notified by email whenever a scheduled refresh of this semantic model fails, without writing custom code. What is the most appropriate approach?

Accepted Answer

Enable the built-in refresh failure notifications in the semantic model's scheduled refresh settings and specify the recipients.

Answer

Create a Data Activator (Activator) reflex triggered on the semantic model's dataset query results to detect stale rows.

Answer

Write a notebook that queries the model daily and sends an email using a Python SMTP library.

Answer

Configure a Fabric pipeline with a Web activity that polls the refresh history REST API and emails on failure.