Microsoft Fabric Data Engineer Associate DP-700 Questions 151–160 | Page 3/3

151

MCQmedium

Your organization uses Power BI in Fabric. Users report that reports are slow to load. You want to identify which specific visuals are causing the performance bottleneck. Which tool should you use?

A.SQL Server Profiler

B.Power BI Performance Analyzer

C.Fabric Monitoring Hub

D.Power BI Service Audit Logs

AnswerB

Performance Analyzer allows developers to record and view performance information for report elements. It logs the exact time taken for query execution, visual display, and other operations, making it the definitive tool for pinpointing which visuals contribute to report load time latency.

Why this answer

Performance Analyzer is the built-in tool in Power BI Desktop designed to capture the execution duration of every visual on a report page. It provides a breakdown of time spent on DAX queries, visual rendering, and other processes. This allows developers to isolate slow-performing visuals, optimize the underlying DAX expressions, or simplify the report page layout to enhance the end-user experience.

Exam trap

Candidates often suggest using the Power BI Service 'Usage Metrics' report. While useful for views, it lacks the visual-level granularity required to diagnose specific DAX or rendering bottlenecks.

Full explanation →

152

Multi-Selecthard

You are configuring a medallion architecture in Microsoft Fabric using Lakehouse Delta tables. You need to implement an incremental data load pattern from a bronze table to a silver table using a PySpark notebook. Which TWO actions must you perform to ensure idempotency and high performance? Choose exactly two.

Select 2 answers

A.Use the Delta Lake merge operation based on a unique business surrogate key to handle both inserts and updates idempotently.

B.Overwrite the entire silver table partition dynamically on every execution without checking for existing record identifiers.

C.Read only the newly arrived files or records using streaming queries or explicit watermarking filters based on ingestion timestamps.

D.Disable Delta Lake transaction logs during the write phase to accelerate the throughput of incremental insert operations.

E.Cache the entire bronze table into the Spark driver memory before executing the join and transformation logic.

AnswersA, C

The Delta Lake merge command allows conditional matching based on primary or business keys, enabling seamless upserts. This ensures that rerun pipelines do not duplicate records, maintaining strict idempotency across incremental processing cycles in the silver layer.

Why this answer

Implementing merge operations with watermarking and schema evolution enables incremental updates while maintaining table consistency. Idempotency guarantees that running the pipeline multiple times for the same time window yields identical results without data duplication, which is critical for robust enterprise data engineering pipelines in Microsoft Fabric.

Exam trap

Candidates often select 'full overwrite' as an option, which destroys idempotency, or forget to mention the business surrogate key, which is essential for correctly merging data updates.

Full explanation →

153

Multi-Selecthard

You are developing a Notebook in Microsoft Fabric to process high-volume sensor data. You need to optimize performance using Delta Lake features. Which TWO actions should you perform? (Choose two)

Select 2 answers

A.Enable Z-Ordering on frequently filtered columns

B.Execute the OPTIMIZE command on the target table

C.Manually delete old Parquet files from the file system

D.Convert the table to CSV format

E.Increase the number of partitions to equal total file count

AnswersA, B

Z-Ordering is a technique to map multidimensional data to one dimension while preserving locality. By co-locating data in the same set of files, Spark can skip entire files during query execution, which dramatically reduces the amount of data read for range-based or point-lookup queries in large datasets.

Why this answer

Optimizing Delta Lake tables involves managing file sizes and data distribution. Z-Ordering optimizes multi-column queries by co-locating related data, significantly reducing read amplification. Compaction (using OPTIMIZE) merges small files into larger, more efficient files, which directly improves scan performance.

Implementing these features is essential for maintaining query speed as data grows in the Lakehouse, ensuring that the Spark engine spends less time scanning unnecessary file blocks during execution.

Exam trap

Candidates often choose only one of the two options (Optimize or Z-Ordering), failing to realize that both are required to address small file issues and data skipping simultaneously.

Full explanation →

154

MCQmedium

Refer to the exhibit. You are reviewing the monitoring logs for your Fabric capacity. What is the most likely cause of the error shown in the exhibit?

A.The underlying data source is offline.

B.The Fabric capacity is experiencing throttling.

C.The user does not have read permissions.

D.The query contains a syntax error.

AnswerB

A 429 status code explicitly signals that the capacity is being throttled due to excessive usage or concurrency limitations. When the aggregate demand of all operations exceeds the burstable or sustained limits of the purchased capacity, Fabric pauses requests to maintain stability for all users.

Why this answer

The '429 Too Many Requests' error indicates that the Fabric capacity has reached its limits for concurrent requests or resource consumption. This occurs when the workload exceeds the allocated capacity units (CU) or the throughput limits set for that specific capacity type. To resolve this, you must analyze if the workload needs more resources, requires optimization, or needs to be distributed across different capacities.

Exam trap

Candidates often mistake a 429 status code for a missing permission or invalid connection string, ignoring the capacity unit and request rate limits inherent to Fabric workloads.

Full explanation →

155

Multi-Selectmedium

You are designing a governance strategy for Microsoft Fabric. You want to ensure that certain sensitive data remains within specific geographic boundaries. Which TWO Fabric features or settings can help you implement and enforce this requirement?

Select 2 answers

A.Multi-geo capacities

B.Workspace-level region settings

C.Tenant setting: 'Users can create and use shortcuts'

D.OneLake data residency tenant settings

E.Sensitivity labels with mandatory labeling

AnswersA, D

Multi-geo capacities allow an organization to create Fabric capacities in different Azure regions. By assigning specific workspaces to a capacity located in a particular region, you ensure that the data stored in the Lakehouses and the compute used for processing remain within that specific geographic boundary.

Why this answer

Data residency is a critical part of governance. Fabric allows for multi-geo capabilities where capacities can be created in different regions. Additionally, tenant settings can restrict where data is stored or processed.

Combining these features ensures that sensitive data adheres to legal and regulatory requirements regarding geographic boundaries and data sovereignty.

Exam trap

Candidates often confuse data residency with data protection or encryption, incorrectly selecting features like 'Sensitivity Labels' which govern data classification rather than the physical geographic location of the data.

Full explanation →

156

Multi-Selectmedium

You are managing a Microsoft Fabric environment and need to implement 'Endorsement' for several high-quality datasets to help users find reliable data. Which TWO levels of endorsement can you apply to Fabric items?

Select 2 answers

A.Promoted

B.Certified

C.Verified

D.Approved

E.Validated

AnswersA, B

The 'Promoted' level is used to highlight items that are considered valuable and ready for use by others. It is a way for item owners to signal that the content is reliable, although it does not require the same formal review process as the 'Certified' level.

Why this answer

Endorsement helps users identify trustworthy and high-quality items in Fabric. It is a key part of data governance. There are two specific levels of endorsement that signify different degrees of validation, helping to distinguish between casual development items and certified, authoritative business assets used for critical reporting.

Exam trap

Candidates often confuse endorsement levels with workspace roles or permissions like Admin and Member, assuming 'Verified' or 'Official' are valid endorsement types instead of the correct 'Promoted' and 'Certified' levels.

Full explanation →

157

MCQmedium

You are auditing a Fabric workspace to ensure optimal performance. You want to see the execution history and duration of all Spark notebooks run within the last 30 days. Where should you look?

A.The Fabric Capacity Metrics App

B.The Workspace Monitor Hub

C.Microsoft Purview Compliance Portal

D.The OneLake File Explorer

AnswerB

The Monitor Hub in the Fabric workspace allows users to view the status, duration, and execution history of various items, including Spark notebooks. It is the primary interface for auditing recent job runs and verifying that data engineering processes are finishing within the expected timeframe.

Why this answer

The Workspace Monitoring hub provides a centralized interface for viewing the activity of Spark-based items. By accessing the monitor tab, you can view job status, start times, and durations. This is vital for identifying long-running jobs that may be causing bottlenecks and for ensuring that automated pipeline runs are adhering to the expected time-to-completion service level agreements.

Exam trap

Candidates frequently look in the 'Manage Gateway' or 'Workspace Settings' tabs. They miss the 'Monitoring hub' because they assume execution history is tied to individual notebook settings rather than a centralized location.

Full explanation →

158

MCQhard

Refer to the exhibit. You are using Structured Streaming to ingest data into a Delta table. Why is the checkpoint path required?

A.It is used to store the schema definition.

B.It stores the offset and state information for fault tolerance.

C.It increases the throughput of the write operation.

D.It is required for overwriting existing tables.

AnswerB

The checkpoint path tracks exactly which data has been processed by the streaming job. This allows Spark to recover from failures by re-reading only the missed data, ensuring exactly-once processing semantics which are critical for data consistency in real-time or near-real-time ingestion scenarios.

Why this answer

Checkpointing is essential in Structured Streaming for fault tolerance and exactly-once processing guarantees. It stores the state of the stream, including the offsets of the data processed so far. If a job fails, the checkpoint allows the stream to resume exactly where it left off, preventing data loss or duplication.

This is a mandatory component for building reliable streaming pipelines in a production Fabric Lakehouse environment.

Exam trap

Candidates often think the checkpoint path is for temporary file storage or performance logging, failing to realize it is the fundamental mechanism for maintaining state and offsets for exactly-once processing.

Full explanation →

159

MCQmedium

You are managing a Microsoft Fabric Lakehouse. You need to ensure that data in the Bronze layer is accessible to the Silver layer while enforcing strict row-level security for downstream users. What is the most efficient way to implement this architecture while maintaining performance?

A.Export Bronze data to a separate Azure SQL database to apply row-level security via T-SQL stored procedures.

B.Use Microsoft Purview to enforce row-level security directly on the Parquet files stored in OneLake.

C.Create a Fabric semantic model over the Silver layer and implement row-level security within the model settings.

D.Create separate physical copies of the Silver layer tables for every user group requiring restricted access.

AnswerC

Fabric semantic models allow you to define granular security roles that filter data dynamically for users. This is the standard, high-performance method for controlling access in Fabric, ensuring that the lakehouse remains the single source of truth while providing secure, compliant access for Power BI reporting and analysis.

Why this answer

Implementing Medallion architecture using shortcuts and Fabric security roles provides a decoupled, performant approach. By utilizing OneLake shortcuts, you avoid unnecessary data movement between layers, reducing latency. Applying row-level security through Fabric's semantic model permissions ensures that end-users only access data relevant to their authorization level without requiring redundant copies of the underlying Parquet files, thus optimizing compute and storage utilization across the analytics lifecycle.

Exam trap

Candidates often suggest creating physical copies of data for different security roles. This ignores the efficiency of Fabric semantic models, which apply security logic without duplicating the underlying storage.

Full explanation →

160

Multi-Selectmedium

You are designing a data orchestration strategy using Microsoft Fabric Data Factory. You need to ensure that your pipeline can handle intermittent source system failures and provide notifications upon success or failure. Which THREE pipeline activities or features should you use? (Choose THREE)

Select 3 answers

A.Retry policy settings on the Copy activity.

B.The Office 365 Outlook activity.

C.The 'Wait' activity for fixed delays.

D.Success and Failure constraints (On Success / On Failure).

E.The 'Stored Procedure' activity to update OneLake metadata.

AnswersA, B, D

Retry policies allow a pipeline to automatically attempt an activity again if it fails due to transient issues, such as network timeouts. By configuring the number of retries and the interval between them, engineers can build more resilient workflows that don't require manual intervention for minor glitches. This is a standard best practice for managing unreliable source systems in cloud environments.

Why this answer

Data Factory pipelines in Fabric offer several control flow and notification activities to build resilient data movements. Using Retry policies helps handle transient errors, while 'Until' or 'If Condition' activities manage logic, and Office 365 Outlook activities facilitate communication. These features are vital for creating production-ready pipelines that can recover from errors and keep stakeholders informed of the processing status.

Exam trap

Candidates often confuse the 'Until' activity with 'Retry' policy settings, or incorrectly assume that custom notification activities are built-in features rather than needing an external Outlook or Teams connector.

Full explanation →

Microsoft Fabric Data Engineer Associate (DP-700) — Questions 151–160