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
The operations team has applied: Make foreachBatch writes idempotent using stable event keys, batch IDs or transactional merging. Its purpose was: A foreachBatch streaming sink replays a microbatch after interruption and double-charges business events. Which of the following provides the strongest direct evidence of success?
Custom microbatch side effects can rerun; checkpoint alone does not make arbitrary writes exactly once.
Stream transformations can filter or project event fields before ingestion. It does not show that a replay of the same batch ID does not duplicate target business records.
KQL binning groups events into fixed time buckets. It does not show that a replay of the same batch ID does not duplicate target business records.
The stream must have an active compatible destination for events to be materialized there. It does not show that a replay of the same batch ID does not duplicate target business records.
A Fabric data engineer receives a change request: A Fabric workspace needs to be classified under the Finance data domain for centralized discovery and ownership. Which action best produces this measurable result: the Finance domain lists the workspace in its governed inventory?
Domains group analytics content by business ownership rather than granting fine-grained data permissions. Verify that the Finance domain lists the workspace in its governed inventory.
Autoscale adjusts cluster nodes and dynamic allocation adjusts executor resources based on workload demand. However, this alone does not show that the Finance domain lists the workspace in its governed inventory.
Environment-backed workspace defaults provide reusable Spark runtime and library configuration. However, this alone does not show that the Finance domain lists the workspace in its governed inventory.
Environment selection can isolate runtime dependencies by workspace or workload. However, this alone does not show that the Finance domain lists the workspace in its governed inventory.
The Fabric engineering team must address this requirement: A Dataflow Gen2 refresh fails with a data destination validation error after a source column was renamed. Which implementation meets the requirement and provides this acceptance evidence: the refresh succeeds and fields land in the correct typed columns?
Dataflow source/query schema and destination mapping must agree. Verify that the refresh succeeds and fields land in the correct typed columns.
A missing or renamed column breaks Spark analysis before valid execution. However, this alone does not show that the refresh succeeds and fields land in the correct typed columns.
KQL ingestion requires compatible column types and valid mapping expressions. However, this alone does not show that the refresh succeeds and fields land in the correct typed columns.
Shortcut path references are not automatically rewritten when source folders are relocated. However, this alone does not show that the refresh succeeds and fields land in the correct typed columns.
The project has two blockers. Blocker A: A Power BI semantic model shows stale metrics after data ingestion succeeded. Blocker B: Daily notebook outputs should generate an alert when row counts drop outside an accepted band. What pair of actions resolves both blockers?
Step 1 resolves requirement A: Upstream data arrival is separate from semantic model refresh completion. Step 2 resolves requirement B: Data quality anomalies may not appear as compute failures unless explicitly measured. Both acceptance tests are required: a successful model refresh timestamp follows the completed ingest and report values update; and a deliberately truncated batch triggers an anomaly alert while the prior good batch does not.
Upstream data arrival is separate from semantic model refresh completion. Data quality anomalies may not appear as compute failures unless explicitly measured. The proposed steps (Open the Dataflow Gen2 refresh history and examine query/destination errors and row activity; inspect Spark job monitoring and the current concurrency/queue state) address other capabilities instead of this required pair.
Upstream data arrival is separate from semantic model refresh completion. The other proposed action (inspect Spark job monitoring and the current concurrency/queue state) addresses a different operation. Data quality anomalies may not appear as compute failures unless explicitly measured.
Data quality anomalies may not appear as compute failures unless explicitly measured. The other proposed action (Open the Dataflow Gen2 refresh history and examine query/destination errors and row activity) does not implement the first control. Upstream data arrival is separate from semantic model refresh completion.
The project has two blockers. Blocker A: An internal shortcut works for workspace admins but not for a new Viewer. Blocker B: A Spark notebook fails with an executor OOM after a skewed join on a hot customer ID. What pair of actions resolves both blockers?
Step 1 resolves requirement A: Admins can inherit broader data access than a Viewer; shortcut visibility is not universal authorization. Step 2 resolves requirement B: Unbalanced shuffle partitions can exhaust one executor while others remain underutilized. Both acceptance tests are required: the Viewer reads only intended shortcut data after scoped access is granted; and the hot-key test completes without executor OOM and preserves join results.
Unbalanced shuffle partitions can exhaust one executor while others remain underutilized. The other proposed action (Repair destination column mapping and data types, publish and rerun the dataflow) does not implement the first control. Admins can inherit broader data access than a Viewer; shortcut visibility is not universal authorization.
Admins can inherit broader data access than a Viewer; shortcut visibility is not universal authorization. Unbalanced shuffle partitions can exhaust one executor while others remain underutilized. The proposed steps (Repair destination column mapping and data types, publish and rerun the dataflow; inspect the transformation/filter conditions and compare source and derived-stream event counters) address other capabilities instead of this required pair.
Admins can inherit broader data access than a Viewer; shortcut visibility is not universal authorization. The other proposed action (inspect the transformation/filter conditions and compare source and derived-stream event counters) addresses a different operation. Unbalanced shuffle partitions can exhaust one executor while others remain underutilized.
An enterprise Fabric solution must resolve this issue: A confidential data pipeline needs item endorsements and sensitivity labels, but the team assumes either setting is equivalent to an audit trail. The acceptance criterion is: the item displays its metadata and an activity query identifies who changed it. Which implementation should be selected?
Classification, trust signaling and audit history solve distinct governance requirements. Verify that the item displays its metadata and an activity query identifies who changed it.
Multiple OneLake grant roles combine granted access; a restrictive grant does not revoke access granted elsewhere. However, this alone does not show that the item displays its metadata and an activity query identifies who changed it.
Item audit events do not alone identify each source row or transformation step. However, this alone does not show that the item displays its metadata and an activity query identifies who changed it.
Item visibility and data-plane read rights can be independently evaluated. However, this alone does not show that the item displays its metadata and an activity query identifies who changed it.
A Fabric engineer has implemented the following change: Evaluate the supported starter pool for low-latency sessions while preserving a separate batch capacity strategy. The original requirement was: A team's short interactive Spark notebooks take too long to start because they use a custom pool designed for long batch jobs. Which observation best validates that the change works?
Starter pools can reduce Spark session startup cost compared with capacity-level custom pools.
Airflow tasks rely on configured connections and runtime settings independent of a Fabric pipeline definition. It does not show that a small interactive notebook starts within the agreed latency threshold.
Workspace-level configuration governs data access and connectivity across multiple items. It does not show that a small interactive notebook starts within the agreed latency threshold.
Domain assignment supports discoverability and governance but is not the row or item authorization boundary. It does not show that a small interactive notebook starts within the agreed latency threshold.
An enterprise Fabric solution must resolve this issue: A Spark job fails when a Python library is installed interactively but absent in the scheduled environment. The acceptance criterion is: the next scheduled run imports the dependency successfully. Which implementation should be selected?
Scheduled Spark jobs use their declared environment rather than an old notebook session's temporary libraries. Verify that the next scheduled run imports the dependency successfully.
System-created staging permissions can be tied to an original owner and may outlive a user's access. However, this alone does not show that the next scheduled run imports the dependency successfully.
Dataflow source/query schema and destination mapping must agree. However, this alone does not show that the next scheduled run imports the dependency successfully.
KQL table name resolution and authorization depend on the selected database context. However, this alone does not show that the next scheduled run imports the dependency successfully.
A production analytics workflow has this requirement: A data team needs to distinguish source transaction time from ingestion processing time for late records. What is the most appropriate change if success must be shown by this test: a deliberately late event retains its original business timestamp and late arrival metadata?
Event time supports domain analysis and processing time supports operational freshness diagnosis. Verify that a deliberately late event retains its original business timestamp and late arrival metadata.
Type 2 slowly changing dimensions preserve prior attribute versions rather than overwriting history. However, this alone does not show that a deliberately late event retains its original business timestamp and late arrival metadata.
Dimensional modeling separates measurable events from descriptive attributes at a declared grain. However, this alone does not show that a deliberately late event retains its original business timestamp and late arrival metadata.
Type 1 updates replace the current attribute without retaining prior versions. However, this alone does not show that a deliberately late event retains its original business timestamp and late arrival metadata.
An auditor reviews the applied Fabric control: Inspect Query Insights and execution history for the warehouse or SQL endpoint. It was selected to address: A warehouse dashboard refreshes slowly and users blame source ingestion without checking actual SQL workload. Which evidence demonstrates the intended result?
Query history exposes SQL execution trends distinct from copy/load duration.
Source activity does not prove a downstream destination is consuming messages. It does not show that the slow query shape and its historical duration are identified.
Freshness degradation can occur before a hard ingestion failure. It does not show that the slow query shape and its historical duration are identified.
A healthy final status does not rule out performance regression. It does not show that the slow query shape and its historical duration are identified.
A shared Fabric backlog includes two mandatory controls. First: A dataflow refresh returns no new rows, and an engineer assumes success because the workspace item exists. Second: An Eventstream's Eventhouse sink stops receiving data although the source connector still appears healthy. Which two-part implementation satisfies them together?
Step 1 resolves requirement A: Item existence and saved query definition do not prove that the latest refresh succeeded. Step 2 resolves requirement B: Source activity does not prove a downstream destination is consuming messages. Both acceptance tests are required: the refresh record identifies its failure or confirms the correct destination row count; and monitoring identifies the stalled destination and the last accepted event.
Source activity does not prove a downstream destination is consuming messages. The other proposed action (Inspect Spark job monitoring and the current concurrency/queue state) does not implement the first control. Item existence and saved query definition do not prove that the latest refresh succeeded.
Item existence and saved query definition do not prove that the latest refresh succeeded. The other proposed action (inspect the pipeline run and its activity-level details in the supported Monitoring hub) addresses a different operation. Source activity does not prove a downstream destination is consuming messages.
Item existence and saved query definition do not prove that the latest refresh succeeded. Source activity does not prove a downstream destination is consuming messages. The proposed steps (Inspect Spark job monitoring and the current concurrency/queue state; inspect the pipeline run and its activity-level details in the supported Monitoring hub) address other capabilities instead of this required pair.
Please check your mailbox for a message from support@examlabs.com and follow the directions.