DP-700 - Monitor and Optimize an Analytics Solution - Section 3.4

Identify and resolve notebook, Eventhouse, and Eventstream errors.

Read Spark notebook error logs and stack traces to isolate executor and driver failures, and resolve Eventhouse ingestion failures caused by ingestion mapping errors. Diagnose Eventstream runtime errors by tracing events through the processing topology to identify the failing component.

Spark notebook error logs and stack tracesEventhouse ingestion failuresEventstream runtime errorsexecutor and driver failuresingestion mapping errors

Practice question for this objective

Free sampleMonitor and Optimize an Analytics Solutionmedium

An engineer ingests a JSON event feed into a Microsoft Fabric Eventhouse table. Ingestion reports failures, and the ingestion failures view shows the reason 'BadRequest_MappingError' for the affected rows while other rows land correctly. The source recently added a nested field that does not exist as a column in the target table. The engineer must get the new field stored without dropping the rows that are still failing. Which action resolves the mapping error described?

  • ALower the table's ingestion batching latency so smaller batches are committed more often, giving the affected rows another chance to be parsed successfully.
  • BIncrease the ingestion timeout so the engine has longer to process the larger payloads, which lets the previously failing rows complete their ingestion.
  • CUpdate the ingestion mapping and table schema to add a column for the new nested field, mapping its JSON path so the previously rejected rows ingest correctly. Correct
  • DPause the source Eventstream and resume it so the connection re-reads the feed from the beginning and re-applies the existing mapping to the failed rows.
An Eventhouse mapping error means the ingestion mapping or schema lacks a column for a source field, fixed by extending the mapping. Eventhouse ingestion validates each record against the ingestion mapping that binds source paths to table columns; a 'BadRequest_MappingError' means a field in the payload has no corresponding column and mapping entry, so those records are rejected while conforming rows succeed. Adding the target column and a mapping entry for the nested JSON path lets the engine store the new field and ingest the previously failing rows.

Why A is wrong: Batching latency only controls how often data is committed, not how fields map to columns; the rows fail because a referenced field has no target column, which more frequent batches cannot fix.

Why B is wrong: A mapping error is a schema mismatch raised immediately during parsing, not a slow operation; extending the timeout does nothing because the rows are rejected on validation rather than timing out.

Why C is correct: The mapping error is raised because the JSON references a field that has no matching column and path in the mapping; adding the column and mapping the nested JSON path lets the engine place the value and ingest the rows that were failing.

Why D is wrong: Replaying the same feed against the same mapping reproduces the same mismatch, so the rows fail again; the error is in the mapping definition, which a restart leaves unchanged.

See more DP-700 practice questions, answers explained.

More in this domain

Back to all Monitor and Optimize an Analytics Solution objectives, or the DP-700 cert hub.

Examworthy is not affiliated with or endorsed by Microsoft. Original, blueprint-aligned practice material only.