An Eventstream in Microsoft Fabric fails to process events with an error indicating 'Deserialization error'. What does this error typically indicate?

The eventstream has insufficient throughput

The event data does not match the expected format or schema

The destination is not available

The eventstream is not connected to a source

A OneLake shortcut to an external ADLS Gen2 account shows a 'PathNotFound' error when a user browses it in Fabric. The shortcut was created with a service principal that has Storage Blob Data Reader on the container. The service principal's secret expired last week. What should you do?

Update the shortcut's credentials with a new valid service principal secret

Change the shortcut's path to use the container's public endpoint

Grant the user's account Storage Blob Data Reader on the container

Recreate the shortcut with a user-assigned managed identity

A Dataflow Gen2 that appends to an existing table fails with 'Expression.Error: The key didn't match any rows in the table.' The dataflow uses a merge operation to combine new data with a reference table. The reference table is loaded from a Lakehouse table that was rebuilt yesterday. What is the most likely cause?

The reference table's key column values changed or were removed during the rebuild

The dataflow's query folding is disabled

The destination table's schema has more columns than the source

The dataflow's refresh type is set to 'Refresh only' instead of 'Full refresh'

A OneLake shortcut to an external ADLS Gen2 account is used by multiple Fabric workloads. The shortcut was created with a service principal that has Storage Blob Data Reader on the container. The service principal's secret is about to expire. You need to avoid disruption without changing the shortcut's path. What should you do?

Rotate the service principal's secret and update the shortcut's credentials before the expiration

Change the shortcut's authentication to use the user's Azure AD account

Grant the service principal Storage Blob Data Contributor on the container

Create a new shortcut with a user-assigned managed identity and update all workloads to use the new path

A Fabric pipeline copies Parquet files from an Azure Data Lake Storage Gen2 account to a Lakehouse table. The pipeline ran successfully last week but now fails at the Copy activity with a 'FileNotFound' error for a source file that exists. The source folder is mounted as a OneLake shortcut in the Lakehouse. What should you investigate first?

Whether the destination Lakehouse table has a partition column mismatch

Whether the pipeline's scheduled trigger time zone is set correctly

Whether the shortcut's source path or credentials have changed

Whether the pipeline's retry policy is set to zero

Microsoft Certified:Fabric Data Engineer Associate

Domain 3Objective 2

Identify and Resolve Errors DP-700 Practice Questions (Page 11)

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 60 practice questions to prepare you well beyond it. (estimate)

60questions here

12free pages

14concepts

30–35%of the exam

Questions 51–55

51foundation · easy
An Eventstream in Microsoft Fabric fails to process events with an error indicating 'Deserialization error'. What does this error typically indicate?
Select an answer first
52application · medium
A OneLake shortcut to an external ADLS Gen2 account shows a 'PathNotFound' error when a user browses it in Fabric. The shortcut was created with a service principal that has Storage Blob Data Reader on the container. The service principal's secret expired last week. What should you do?
Select an answer first
53application · medium
A Dataflow Gen2 that appends to an existing table fails with 'Expression.Error: The key didn't match any rows in the table.' The dataflow uses a merge operation to combine new data with a reference table. The reference table is loaded from a Lakehouse table that was rebuilt yesterday. What is the most likely cause?
Select an answer first
54expert · hard
A OneLake shortcut to an external ADLS Gen2 account is used by multiple Fabric workloads. The shortcut was created with a service principal that has Storage Blob Data Reader on the container. The service principal's secret is about to expire. You need to avoid disruption without changing the shortcut's path. What should you do?
Select an answer first
55application · medium
A Fabric pipeline copies Parquet files from an Azure Data Lake Storage Gen2 account to a Lakehouse table. The pipeline ran successfully last week but now fails at the Copy activity with a 'FileNotFound' error for a source file that exists. The source folder is mounted as a OneLake shortcut in the Lakehouse. What should you investigate first?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back 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.

Identify and Resolve Errors DP-700 Practice Questions (Page 11)

Questions 51–55

An Eventstream in Microsoft Fabric fails to process events with an error indicating 'Deserialization error'. What does this error typically indicate?

A OneLake shortcut to an external ADLS Gen2 account shows a 'PathNotFound' error when a user browses it in Fabric. The shortcut was created with a service principal that has Storage Blob Data Reader on the container. The service principal's secret expired last week. What should you do?

Keep studying — Monitor and optimize an analytics solution