You save $34.99
DP-700 Premium Bundle
- Premium File 160 Questions & Answers
- Last Update: Nov 15, 2026
- Training Course 160 Lectures
You save $34.99
An enterprise Fabric solution must resolve this issue: A customer pipeline failed overnight and operators need the exact failing Copy activity, duration and source error. The acceptance criterion is: the report identifies the failing activity, run ID, error and elapsed time. Which implementation should be selected?
Run-level status does not replace individual activity diagnostics for failure localization. Verify that the report identifies the failing activity, run ID, error and elapsed time.
Editing/publishing validation and scheduled refresh are distinct operational states. However, this alone does not show that the report identifies the failing activity, run ID, error and elapsed time.
SQL query monitoring provides query-level facts rather than only Fabric item health. However, this alone does not show that the report identifies the failing activity, run ID, error and elapsed time.
Notebook failures can originate in the Spark job rather than pipeline orchestration. However, this alone does not show that the report identifies the failing activity, run ID, error and elapsed time.
A Fabric engineer has implemented the following change: Define a type-safe source-to-target schema mapping and test conversion behavior. The original requirement was: A pipeline copy lands decimal amounts as strings and analytics totals are incorrect. Which observation best validates that the change works?
Explicit conversion protects numerical fidelity during ingestion.
Deterministic precedence avoids unpredictable retained records. It does not show that decimal sums match source totals and malformed values enter an exception path.
Mirroring replicates supported source changes into Fabric with managed synchronization. It does not show that decimal sums match source totals and malformed values enter an exception path.
A Lakehouse combines file storage with Delta tables and Spark development. It does not show that decimal sums match source totals and malformed values enter an exception path.
A data engineer must validate the completed action: Configure bounded retries with an appropriate delay and reduce parallelism if needed. It targets this failure: A Copy activity returns HTTP 429 during a burst but source credentials and schema are valid. Which test outcome should be accepted?
Rate limiting is generally transient and worsens with uncontrolled immediate retries.
Conflicting source matches prevent unambiguous one-target-row updates. It does not show that an injected 429 recovers within the retry limit without duplicate target rows.
Shortcut path references are not automatically rewritten when source folders are relocated. It does not show that an injected 429 recovers within the retry limit without duplicate target rows.
A missing or renamed column breaks Spark analysis before valid execution. It does not show that an injected 429 recovers within the retry limit without duplicate target rows.
A Fabric release must resolve two independent technical requirements. Requirement A: A pipeline must pass an environment-specific Lakehouse name into the notebook it invokes. Requirement B: A Dataflow Gen2 refresh must land transformed rows into a Warehouse and fails because its staging prerequisites were removed. Select TWO actions that directly satisfy both requirements.
Warehouse destinations in Dataflow Gen2 can require staging before the destination write. Confirm that the refreshed dataflow loads into the target Warehouse with no staging validation warning.
Explicit parameter mapping makes notebook execution independent of hardcoded environment names. Confirm that a test run logs the target environment identifier and writes only to that destination.
Spark code supports programmable distributed transforms and Delta upsert patterns.
Parameterized notebook execution separates business run context from transformation logic.
A team is working on two related Fabric work items. Work item A: A data engineering team needs a common Spark runtime and Python library versions across 12 notebooks, without editing each notebook independently. Work item B: A team needs to control which external destinations OneLake-enabled workspace items can connect to for sensitive datasets. Select TWO specific implementation steps.
Environment-backed workspace defaults provide reusable Spark runtime and library configuration. Confirm that a new notebook using Workspace default loads the approved library versions.
Outbound protection restricts data egress paths independently of ordinary item-level read permissions. Confirm that an approved endpoint remains reachable and an unapproved outbound connection is blocked.
Domain assignment supports discoverability and governance but is not the row or item authorization boundary.
Domains group analytics content by business ownership rather than granting fine-grained data permissions.
The data platform team needs a narrowly scoped fix: A Dataflow Gen2 refresh must land transformed rows into a Warehouse and fails because its staging prerequisites were removed. Which approach satisfies the documented test that the refreshed dataflow loads into the target Warehouse with no staging validation warning?
Warehouse destinations in Dataflow Gen2 can require staging before the destination write. Verify that the refreshed dataflow loads into the target Warehouse with no staging validation warning.
Conditional orchestration can route execution based on prior activity outputs. However, this alone does not show that the refreshed dataflow loads into the target Warehouse with no staging validation warning.
Event-based orchestration reacts to completed arrival events instead of polling a fixed schedule. However, this alone does not show that the refreshed dataflow loads into the target Warehouse with no staging validation warning.
Explicit parameter mapping makes notebook execution independent of hardcoded environment names. However, this alone does not show that the refreshed dataflow loads into the target Warehouse with no staging validation warning.
The Fabric engineering team must address this requirement: An analyst may query only sales rows for their region across supported OneLake engines. Which implementation meets the requirement and provides this acceptance evidence: the region A account cannot retrieve region B records through the supported query path?
Row-level security filters table rows for eligible reader identities. Verify that the region A account cannot retrieve region B records through the supported query path.
Promotion is a discoverability signal; certification requires an authorized organizational review process. However, this alone does not show that the region A account cannot retrieve region B records through the supported query path.
Item audit events do not alone identify each source row or transformation step. However, this alone does not show that the region A account cannot retrieve region B records through the supported query path.
Endorsement communicates content quality and ownership rather than encryption or data authorization. However, this alone does not show that the region A account cannot retrieve region B records through the supported query path.
The operations team has applied: Use GROUP BY with aggregate functions in a supported warehouse query. Its purpose was: A T-SQL transformation needs one row per customer using grouped spend totals. Which of the following provides the strongest direct evidence of success?
Relational aggregation collapses transactional detail into grouped measures.
Mirroring is a replication pattern, not a general bidirectional transaction editor. It does not show that customer totals reconcile with a reference sum of source transactions.
A shortcut is a reference to data, not an independently secured copy with unlimited access. It does not show that customer totals reconcile with a reference sum of source transactions.
Shortcuts present source data under OneLake paths without physically duplicating the source files. It does not show that customer totals reconcile with a reference sum of source transactions.
The data platform team needs a narrowly scoped fix: An engineer plans to solve a batch nightly sales reconciliation using Eventstream solely because the records are in JSON. Which approach satisfies the documented test that one complete nightly batch reconciles totals without unnecessary continuous event processing?
Streaming imposes state and always-on operation costs that a finite batch task may not need. Verify that one complete nightly batch reconciles totals without unnecessary continuous event processing.
Make-series generates regular time bins, including configured defaults for empty periods. However, this alone does not show that one complete nightly batch reconciles totals without unnecessary continuous event processing.
Tumbling windows partition time into fixed, nonoverlapping intervals. However, this alone does not show that one complete nightly batch reconciles totals without unnecessary continuous event processing.
Overlapping hopping windows recompute aggregates over sliding intervals. However, this alone does not show that one complete nightly batch reconciles totals without unnecessary continuous event processing.
The data platform team needs a narrowly scoped fix: A pipeline should start only when the upstream source delivery is complete rather than at an arbitrary time. Which approach satisfies the documented test that the correct event starts exactly one intended pipeline run for the delivered file?
Event-based orchestration reacts to completed arrival events instead of polling a fixed schedule. Verify that the correct event starts exactly one intended pipeline run for the delivered file.
Parameterized notebook execution separates business run context from transformation logic. However, this alone does not show that the correct event starts exactly one intended pipeline run for the delivered file.
Warehouse destinations in Dataflow Gen2 can require staging before the destination write. However, this alone does not show that the correct event starts exactly one intended pipeline run for the delivered file.
Query transformations and data destination settings are separate deployment concerns. However, this alone does not show that the correct event starts exactly one intended pipeline run for the delivered file.
An auditor reviews the applied Fabric control: Create a Fabric Environment with the approved runtime and packages and set it as the workspace default. It was selected to address: A data engineering team needs a common Spark runtime and Python library versions across 12 notebooks, without editing each notebook independently. Which evidence demonstrates the intended result?
Environment-backed workspace defaults provide reusable Spark runtime and library configuration.
Domains group analytics content by business ownership rather than granting fine-grained data permissions. It does not show that a new notebook using Workspace default loads the approved library versions.
Outbound protection restricts data egress paths independently of ordinary item-level read permissions. It does not show that a new notebook using Workspace default loads the approved library versions.
Airflow configuration belongs to the workspace/orchestration setup rather than individual Spark SQL statements. It does not show that a new notebook using Workspace default loads the approved library versions.
Please check your mailbox for a message from support@examlabs.com and follow the directions.