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 data platform team needs a narrowly scoped fix: Two Fabric Lakehouses in different workspaces must share a stable read-only data path without copying tables. Which approach satisfies the documented test that the target reads the source updates and storage is not redundantly ingested?
Internal shortcuts avoid redundant copies and simplify data sharing. Verify that the target reads the source updates and storage is not redundantly ingested.
Mirroring is a replication pattern, not a general bidirectional transaction editor. However, this alone does not show that the target reads the source updates and storage is not redundantly ingested.
Spark aggregation executes across partitions instead of a single local Python loop. However, this alone does not show that the target reads the source updates and storage is not redundantly ingested.
Denormalization trades duplication for simpler downstream analytic reads. However, this alone does not show that the target reads the source updates and storage is not redundantly ingested.
A team is working on two related Fabric work items. Work item A: Engineers need complex PySpark transformations and Delta MERGE logic on a large Lakehouse table. Work item B: A pipeline replays an interrupted load and creates duplicate records because each retry blindly appends all rows. Select TWO specific implementation steps.
Spark code supports programmable distributed transforms and Delta upsert patterns. Confirm that a parameterized run updates the expected Delta table without full replacement.
Orchestration retries are at-least-once attempts unless destination writes are explicitly idempotent. Confirm that a deliberately replayed run leaves one logical row per source event.
Dataflow Gen2 provides visual ingestion/transformation, reducing the need for custom Spark code.
Query transformations and data destination settings are separate deployment concerns.
An enterprise Fabric solution must resolve this issue: A streaming source emits JSON with an optional temperature field and parsing failures terminate the job. The acceptance criterion is: a malformed test record is quarantined while valid events remain queryable. Which implementation should be selected?
Separating invalid records from typed valid rows allows streaming jobs to continue safely. Verify that a malformed test record is quarantined while valid events remain queryable.
Arg_max selects the row with the greatest time value in each group. However, this alone does not show that a malformed test record is quarantined while valid events remain queryable.
Native tables store ingested data inside the KQL database for efficient query patterns. However, this alone does not show that a malformed test record is quarantined while valid events remain queryable.
Event-time aggregation distinguishes when a fact occurred from when it was processed. However, this alone does not show that a malformed test record is quarantined while valid events remain queryable.
A Fabric data engineering release must address both of these independent requirements: (1) An Apache Airflow DAG fails because its runtime connection reference was changed without updating the managed job configuration. (2) Teams want separate ownership of marketing and finance data while using the same Fabric tenant. Which combined plan meets both without substituting an unrelated change?
Step 1 resolves requirement A: Airflow tasks rely on configured connections and runtime settings independent of a Fabric pipeline definition. Step 2 resolves requirement B: Business domains organize content, while workspaces and OneLake roles govern operational access. Both acceptance tests are required: the failed task connects using the approved reference after the change; and each domain inventory shows its own workspaces and access tests respect role boundaries.
Business domains organize content, while workspaces and OneLake roles govern operational access. The other proposed action (Create a Fabric Environment with the approved runtime and packages and set it as the workspace default) does not implement the first control. Airflow tasks rely on configured connections and runtime settings independent of a Fabric pipeline definition.
Airflow tasks rely on configured connections and runtime settings independent of a Fabric pipeline definition. Business domains organize content, while workspaces and OneLake roles govern operational access. The proposed steps (Create a Fabric Environment with the approved runtime and packages and set it as the workspace default; pin an approved environment/runtime configuration and validate a representative notebook before publishing the upgrade) address other capabilities instead of this required pair.
Airflow tasks rely on configured connections and runtime settings independent of a Fabric pipeline definition. The other proposed action (pin an approved environment/runtime configuration and validate a representative notebook before publishing the upgrade) addresses a different operation. Business domains organize content, while workspaces and OneLake roles govern operational access.
A Fabric engineer has implemented the following change: Project only needed columns and apply selective predicates early. The original requirement was: A warehouse T-SQL query selects all columns from a wide fact table though reporting uses only three numeric measures. Which observation best validates that the change works?
Column pruning and selective filters reduce unnecessary data scan and transfer.
Materialized views maintain precomputed summaries to accelerate repeated analytic queries. It does not show that the revised query returns identical measures with lower bytes processed.
Data layout optimization can improve file pruning for selective queries. It does not show that the revised query returns identical measures with lower bytes processed.
Optimized staged-to-Lakehouse copy can avoid extra serialization and transfer overhead. It does not show that the revised query returns identical measures with lower bytes processed.
A Fabric release must resolve two independent technical requirements. Requirement A: A Spark Structured Streaming job restarts and duplicates a previously committed batch. Requirement B: An Eventhouse suddenly contains no new records because its ingestion source connection expired. Select TWO actions that directly satisfy both requirements.
Expired source access interrupts ingestion even if the KQL query syntax is valid. Confirm that a new source event appears after the connection is restored.
Checkpoint recovery and exactly-once behavior depend on sink capabilities and stable query state. Confirm that a replay test produces no duplicate business events.
Invalid source text causes a deterministic type-conversion failure that extra retries or staging changes cannot repair.
Type overflow creates a deterministic mapping failure, not a transient network fault.
After a production change, the runbook records: Check the semantic model refresh history and dependencies after the upstream load. The previous problem was: A Power BI semantic model shows stale metrics after data ingestion succeeded. What test result confirms effective remediation?
Upstream data arrival is separate from semantic model refresh completion.
Operational alerting turns run failures into actionable notifications rather than manual polling. It does not show that a successful model refresh timestamp follows the completed ingest and report values update.
Intermediate failed attempts can be recovered by bounded retries. It does not show that a successful model refresh timestamp follows the completed ingest and report values update.
Data quality anomalies may not appear as compute failures unless explicitly measured. It does not show that a successful model refresh timestamp follows the completed ingest and report values update.
A team is working on two related Fabric work items. Work item A: Analysts in the same workspace should access one dataset but not another unrelated sensitive dataset. Work item B: A team needs classification metadata for sensitive Fabric warehouse and Lakehouse artifacts visible to governance tools. Select TWO specific implementation steps.
Item permissions target a specific Fabric object while workspace roles cover more workspace resources. Confirm that an analyst opens the assigned item and receives a denial for the unrelated artifact.
Sensitivity labels mark data classification and inform downstream governance; they do not automatically grant read access. Confirm that the labels appear on the intended items while existing access permissions remain intact.
Item audit events do not alone identify each source row or transformation step.
Supported Fabric audit events expose administrative or item activities without being the same as pipeline data logs.
A Fabric data engineer receives a change request: An Eventstream destination table rejects events after a new field type was introduced in source JSON. Which action best produces this measurable result: both old and new valid event shapes map correctly or are quarantined by policy?
Schema drift can break a streaming destination even when the source remains connected. Verify that both old and new valid event shapes map correctly or are quarantined by policy.
KQL ingestion requires compatible column types and valid mapping expressions. However, this alone does not show that both old and new valid event shapes map correctly or are quarantined by policy.
Dataflow source/query schema and destination mapping must agree. However, this alone does not show that both old and new valid event shapes map correctly or are quarantined by policy.
Shortcut path references are not automatically rewritten when source folders are relocated. However, this alone does not show that both old and new valid event shapes map correctly or are quarantined by policy.
A Fabric engineer has implemented the following change: Choose an event-time watermark delay based on measured lateness and the business tolerance. The original requirement was: A windowed Spark stream discards valid events delayed by 12 minutes because the watermark is set to only two minutes. Which observation best validates that the change works?
A too-short watermark can exclude valid late events; a longer delay retains more state.
Materialized aggregations can precompute repeated summaries to reduce query cost. It does not show that representative twelve-minute-late events are included under the approved configuration.
Overlapping hopping windows recompute aggregates over sliding intervals. It does not show that representative twelve-minute-late events are included under the approved configuration.
Stream transformations can filter or project event fields before ingestion. It does not show that representative twelve-minute-late events are included under the approved configuration.
An enterprise Fabric solution must resolve this issue: Operations needs ten-minute averages recalculated every two minutes over a live signal. The acceptance criterion is: a source event participates in the correct overlapping windows. Which implementation should be selected?
Overlapping hopping windows recompute aggregates over sliding intervals. Verify that a source event participates in the correct overlapping windows.
Make-series generates regular time bins, including configured defaults for empty periods. However, this alone does not show that a source event participates in the correct overlapping windows.
Query acceleration caches relevant shortcut data for faster queries while retaining source storage. However, this alone does not show that a source event participates in the correct overlapping windows.
A stream can distribute selected events to more than one supported consumer. However, this alone does not show that a source event participates in the correct overlapping windows.
Please check your mailbox for a message from support@examlabs.com and follow the directions.