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
A production analytics workflow has this requirement: A pipeline retry is in progress and operators might prematurely report it as fully failed. What is the most appropriate change if success must be shown by this test: the run is marked successful only after a successful final attempt and dependencies complete?
Intermediate failed attempts can be recovered by bounded retries. Verify that the run is marked successful only after a successful final attempt and dependencies complete.
SQL query monitoring provides query-level facts rather than only Fabric item health. However, this alone does not show that the run is marked successful only after a successful final attempt and dependencies complete.
Source activity does not prove a downstream destination is consuming messages. However, this alone does not show that the run is marked successful only after a successful final attempt and dependencies complete.
A healthy final status does not rule out performance regression. However, this alone does not show that the run is marked successful only after a successful final attempt and dependencies complete.
An auditor reviews the applied Fabric control: Enable supported item-level compute customization and assign the larger workload an appropriately sized environment. It was selected to address: A memory-heavy PySpark join fails on default Spark driver sizing, while smaller workloads must retain the workspace default. Which evidence demonstrates the intended result?
An environment can override workspace compute only when the administrator permits per-item customization.
Outbound protection restricts data egress paths independently of ordinary item-level read permissions. It does not show that the heavy job completes with the assigned resources and other jobs retain default compute.
Domain metadata and endorsement communicate ownership and trust, not write grants. It does not show that the heavy job completes with the assigned resources and other jobs retain default compute.
Airflow tasks rely on configured connections and runtime settings independent of a Fabric pipeline definition. It does not show that the heavy job completes with the assigned resources and other jobs retain default compute.
The data platform team needs a narrowly scoped fix: A business asks to denormalize small product attributes into a gold sales table for faster analyst queries. Which approach satisfies the documented test that the gold table includes valid product labels and agrees with dimensional source counts?
Denormalization trades duplication for simpler downstream analytic reads. Verify that the gold table includes valid product labels and agrees with dimensional source counts.
Eventhouse supports KQL-based event exploration and real-time analytics. However, this alone does not show that the gold table includes valid product labels and agrees with dimensional source counts.
Distributed Spark processing supports large programmable transforms beyond simple portal mapping. However, this alone does not show that the gold table includes valid product labels and agrees with dimensional source counts.
Shortcuts present source data under OneLake paths without physically duplicating the source files. However, this alone does not show that the gold table includes valid product labels and agrees with dimensional source counts.
The Fabric engineering team must address this requirement: A data pipeline has to branch based on an extracted row-count threshold before loading a warehouse. Which implementation meets the requirement and provides this acceptance evidence: a low-row-count test takes the exception path and a valid count follows the load branch?
Conditional orchestration can route execution based on prior activity outputs. Verify that a low-row-count test takes the exception path and a valid count follows the load branch.
Spark code supports programmable distributed transforms and Delta upsert patterns. However, this alone does not show that a low-row-count test takes the exception path and a valid count follows the load branch.
Dataflow Gen2 provides visual ingestion/transformation, reducing the need for custom Spark code. However, this alone does not show that a low-row-count test takes the exception path and a valid count follows the load branch.
Parameterized notebook execution separates business run context from transformation logic. However, this alone does not show that a low-row-count test takes the exception path and a valid count follows the load branch.
An enterprise Fabric solution must resolve this issue: A Dataflow Gen2 staging Lakehouse is V-Order compressing transient intermediate data that downstream queries never reuse. The acceptance criterion is: refresh CPU declines without changing the optimized destination output. Which implementation should be selected?
Staging data typically has few rereads, so its write compression overhead may outweigh read benefit. Verify that refresh CPU declines without changing the optimized destination output.
Fabric Warehouse manual statistics support is narrower than general SQL Server feature assumptions. However, this alone does not show that refresh CPU declines without changing the optimized destination output.
Data layout optimization can improve file pruning for selective queries. However, this alone does not show that refresh CPU declines without changing the optimized destination output.
V-Order organizes Parquet layout to favor supported Fabric analytic readers. However, this alone does not show that refresh CPU declines without changing the optimized destination output.
A Fabric release must resolve two independent technical requirements. Requirement A: A team needs one reusable child pipeline called by several source-specific parent pipelines. Requirement B: A dataflow refresh succeeds in the editor but writes to the wrong test destination after a source-control merge. Select TWO actions that directly satisfy both requirements.
Pipeline reuse reduces duplicated workflows while retaining explicit input contracts. Confirm that two parents invoke the same child with separate source IDs and results stay isolated.
Query transformations and data destination settings are separate deployment concerns. Confirm that a controlled refresh writes to only the intended environment and table.
Parameterized notebook execution separates business run context from transformation logic.
Spark code supports programmable distributed transforms and Delta upsert patterns.
The operations team has applied: Inspect the transformation/filter conditions and compare source and derived-stream event counters. Its purpose was: An Eventstream source is active but output stops after a filter was changed to reject all records. Which of the following provides the strongest direct evidence of success?
Stream routing can discard records during transformations before they reach a sink.
Unbalanced shuffle partitions can exhaust one executor while others remain underutilized. It does not show that a valid test event passes the corrected filter and arrives at the destination.
Shortcut path references are not automatically rewritten when source folders are relocated. It does not show that a valid test event passes the corrected filter and arrives at the destination.
Expired source access interrupts ingestion even if the KQL query syntax is valid. It does not show that a valid test event passes the corrected filter and arrives at the destination.
The project has two blockers. Blocker A: A telemetry producer publishes data to an Eventstream but a consumer reads no events because its destination is disconnected. Blocker B: An engineer plans to solve a batch nightly sales reconciliation using Eventstream solely because the records are in JSON. What pair of actions resolves both blockers?
Step 1 resolves requirement A: The stream must have an active compatible destination for events to be materialized there. Step 2 resolves requirement B: Streaming imposes state and always-on operation costs that a finite batch task may not need. Both acceptance tests are required: a test message travels from source through the configured path to the sink; and one complete nightly batch reconciles totals without unnecessary continuous event processing.
The stream must have an active compatible destination for events to be materialized there. The other proposed action (enable supported query acceleration over the shortcut and set an appropriate caching period) addresses a different operation. Streaming imposes state and always-on operation costs that a finite batch task may not need.
The stream must have an active compatible destination for events to be materialized there. Streaming imposes state and always-on operation costs that a finite batch task may not need. The proposed steps (Configure the supported custom endpoint and Eventhouse destinations from the intended eventstream; enable supported query acceleration over the shortcut and set an appropriate caching period) address other capabilities instead of this required pair.
Streaming imposes state and always-on operation costs that a finite batch task may not need. The other proposed action (Configure the supported custom endpoint and Eventhouse destinations from the intended eventstream) does not implement the first control. The stream must have an active compatible destination for events to be materialized there.
The project has two blockers. Blocker A: An existing operational database needs near-real-time analytical copies without a hand-built polling ETL pipeline. Blocker B: A data frame needs daily grouped amounts by business date and region without collecting all rows to the Spark driver. What pair of actions resolves both blockers?
Step 1 resolves requirement A: Mirroring replicates supported source changes into Fabric with managed synchronization. Step 2 resolves requirement B: Spark aggregation executes across partitions instead of a single local Python loop. Both acceptance tests are required: an inserted and updated source row appear after the expected replication delay; and the distributed output matches known region-day totals.
Mirroring replicates supported source changes into Fabric with managed synchronization. Spark aggregation executes across partitions instead of a single local Python loop. The proposed steps (Choose a Fabric Warehouse for the SQL-oriented dimensional serving workload; create a governed denormalized projection from fact and dimension source tables) address other capabilities instead of this required pair.
Spark aggregation executes across partitions instead of a single local Python loop. The other proposed action (Choose a Fabric Warehouse for the SQL-oriented dimensional serving workload) does not implement the first control. Mirroring replicates supported source changes into Fabric with managed synchronization.
Mirroring replicates supported source changes into Fabric with managed synchronization. The other proposed action (create a governed denormalized projection from fact and dimension source tables) addresses a different operation. Spark aggregation executes across partitions instead of a single local Python loop.
A shared Fabric backlog includes two mandatory controls. First: A workspace reader is allowed to view a semantic model but must not alter its definition. Second: A confidential data pipeline needs item endorsements and sensitivity labels, but the team assumes either setting is equivalent to an audit trail. Which two-part implementation satisfies them together?
Step 1 resolves requirement A: Item-specific usage rights can be narrower than contributor permissions to change Fabric artifacts. Step 2 resolves requirement B: Classification, trust signaling and audit history solve distinct governance requirements. Both acceptance tests are required: the user performs the allowed read/query action but cannot edit model definition or deploy changes; and the item displays its metadata and an activity query identifies who changed it.
Item-specific usage rights can be narrower than contributor permissions to change Fabric artifacts. The other proposed action (use the applicable Microsoft Fabric/Microsoft Purview audit log search with principal, time and operation filters) addresses a different operation. Classification, trust signaling and audit history solve distinct governance requirements.
Classification, trust signaling and audit history solve distinct governance requirements. The other proposed action (Correlate audit events with pipeline run identifiers and supported lineage records) does not implement the first control. Item-specific usage rights can be narrower than contributor permissions to change Fabric artifacts.
Item-specific usage rights can be narrower than contributor permissions to change Fabric artifacts. Classification, trust signaling and audit history solve distinct governance requirements. The proposed steps (Correlate audit events with pipeline run identifiers and supported lineage records; use the applicable Microsoft Fabric/Microsoft Purview audit log search with principal, time and operation filters) address other capabilities instead of this required pair.
A shared Fabric backlog includes two mandatory controls. First: A nightly ingest needs to copy source files to a Lakehouse, then run a notebook and notify an operations group on failure. Second: Engineers need complex PySpark transformations and Delta MERGE logic on a large Lakehouse table. Which two-part implementation satisfies them together?
Step 1 resolves requirement A: Pipelines orchestrate multi-step activities with dependency conditions, unlike a single query or notebook. Step 2 resolves requirement B: Spark code supports programmable distributed transforms and Delta upsert patterns. Both acceptance tests are required: a test run copies files, transforms them and triggers the failure route when the notebook fails; and a parameterized run updates the expected Delta table without full replacement.
Pipelines orchestrate multi-step activities with dependency conditions, unlike a single query or notebook. Spark code supports programmable distributed transforms and Delta upsert patterns. The proposed steps (Use a Dataflow Gen2 with Power Query transformations and a configured data destination; enable required staging and configure the supported Warehouse data destination) address other capabilities instead of this required pair.
Spark code supports programmable distributed transforms and Delta upsert patterns. The other proposed action (Use a Dataflow Gen2 with Power Query transformations and a configured data destination) does not implement the first control. Pipelines orchestrate multi-step activities with dependency conditions, unlike a single query or notebook.
Pipelines orchestrate multi-step activities with dependency conditions, unlike a single query or notebook. The other proposed action (enable required staging and configure the supported Warehouse data destination) addresses a different operation. Spark code supports programmable distributed transforms and Delta upsert patterns.
Please check your mailbox for a message from support@examlabs.com and follow the directions.