DP-700 Practice Questions

Question 1

You are using Dataflow Gen2 to ingest data from multiple sources. You need to perform a complex transformation that involves merging data from a SQL database and a flat file based on a common key. Which step should you take to achieve this efficiently?

Accepted Answer

Use the Merge transformation. In Dataflow Gen2, the 'Merge' transformation allows users to join tables from different sources within the Power Query interface. By selecting the common key, you can combine datasets into a single model for downstream processing. This approach is highly efficient as it leverages the underlying mashup engine to perform the heavy lifting, ensuring the transformation is processed in a unified, maintainable data pipeline.

Answer

Write a custom Python script

Answer

Create a temporary SQL view

Answer

Export both to CSV first

Question 2

You are auditing data access in a Microsoft Fabric workspace and notice unexpected 'Access Denied' errors in the OneLake logs for a service principal that should have read-only access. The service principal has the 'Viewer' role in the workspace. What is the most likely cause?

Accepted Answer

OneLake data access control (preview) is restricting specific folders.. OneLake security is governed by both workspace roles and item-level permissions. If 'OneLake data access control' is enabled for a Lakehouse, the 'Viewer' role alone may not be sufficient if specific folder-level permissions have not been granted. Understanding the intersection of these security layers is critical for troubleshooting access issues in complex environments.

Answer

The service principal needs the 'Contributor' role to read data.

Answer

The service principal has exceeded its OneLake throughput quota.

Answer

OneLake does not support service principal authentication.

Question 3

You are managing a Microsoft Fabric capacity. You need to identify which users are consuming the most compute resources and determine if any throttled requests are occurring. Which TWO tools should you use?

Accepted Answer

Fabric Capacity Metrics app. Monitoring capacity health requires a combination of real-time metrics and long-term diagnostic logs. The Fabric Capacity Metrics app provides granular visual insights into capacity utilization and throttling, while the Log Analytics workspace offers detailed diagnostic logs for query-level analysis. Using both tools allows engineers to correlate high-level capacity health with specific user-driven workloads that may trigger system-wide throttling or degradation.

Answer

Microsoft Purview

Answer

Service Health Dashboard

Answer

Power BI Desktop Performance Analyzer

Question 4

You need to quickly identify all failed Data Factory pipeline runs and Spark jobs across multiple workspaces in your Microsoft Fabric environment. Which TWO actions should you perform in the Fabric Monitoring Hub?

Accepted Answer

Apply a filter for the 'Failed' status.. The Fabric Monitoring Hub acts as a centralized dashboard for tracking the health of all activities. It allows users to filter by status and item type across the entire environment. This centralized view is essential for data engineers who need to manage multiple pipelines and notebooks without navigating to each individual workspace to check logs.

Answer

Export the logs to an Azure Log Analytics workspace.

Answer

Schedule a daily refresh for the Monitoring Hub dashboard.

Answer

Configure an alert in the Capacity Metrics app.

Question 5

You are troubleshooting a slow-running Power BI report connected to a Fabric Semantic Model. What is the most effective way to identify the bottleneck?

Accepted Answer

Use the Power BI Performance Analyzer. Performance analysis in Power BI involves tracking how long each visual, DAX query, and storage engine operation takes. By using the Performance Analyzer, you can pinpoint exactly which visual or measure is causing the delay. This allows you to focus on optimizing specific DAX measures or data model relationships rather than guessing, which is vital for maintaining responsive reports in production environments.

Answer

View the workspace storage metrics

Answer

Check the Fabric capacity SKU settings

Answer

Rebuild the semantic model from scratch

Question 6

Refer to the exhibit. You are reviewing the configuration for a Fabric Spark Environment. A job is failing with an 'OutOfMemoryError' during a large shuffle operation. Based on the configuration, which change would most likely resolve the issue?

Accepted Answer

Increase 'spark.executor.memory' to 8g or higher.. OutOfMemoryErrors during shuffle operations often indicate that the executor memory is insufficient for the volume of data being processed per task. While dynamic allocation helps with the number of executors, it does not increase the memory available to each individual executor. Increasing 'spark.executor.memory' provides the necessary headroom for complex joins and aggregations.

Answer

Increase 'spark.dynamicAllocation.maxExecutors' to 20.

Answer

Decrease 'spark.executor.cores' to 1.

Answer

Set 'spark.dynamicAllocation.enabled' to 'false'.

Question 7

Refer to the exhibit. You are reviewing pipeline logs and notice the 429 error. What is the most appropriate long-term action to prevent this?

Accepted Answer

Analyze query patterns and optimize resource-heavy jobs. A 429 error indicates that the request was throttled because the capacity reached its compute limit. While immediate scaling might fix the current issue, long-term stability requires identifying the root cause of the spike in resource usage. Optimizing the code, adjusting concurrency, or smoothing out scheduled job times ensures the capacity operates within its allocated limits without requiring constant upgrades.

Answer

Increase the Fabric capacity SKU immediately

Answer

Configure retry policies with exponential backoff

Answer

Disable monitoring to reduce overhead

Question 8

You manage a Microsoft Fabric workspace containing a critical lakehouse and multiple downstream semantic models. You need to configure item-level permissions to ensure that specific business analysts can refresh the semantic models without being able to view or query the underlying tables in the lakehouse storage. Which permission level should you assign directly to the analysts on the semantic model?

Accepted Answer

Assign Build permission specifically on the semantic model to enable reporting and refresh capabilities.. Assigning the Build permission directly to the semantic model grants users the ability to create new reports based on the model and refresh it if configured, without granting access to the underlying lakehouse tables or workspace artifacts. This principle of least privilege ensures analysts can execute operational refreshes without exposing raw data layers.

Answer

Assign Admin permission on the semantic model to grant full control over the artifact settings and refresh history.

Answer

Assign Contributor permission on the workspace containing the semantic model and the lakehouse storage.

Answer

Assign Write permission on the semantic model to allow data modifications and structural definition updates.

Question 9

Refer to the exhibit. An administrator is reviewing the properties of a Lakehouse via the Fabric REST API. The property 'hasManagedPrivateEndpoint' is set to true. What does this indicate about the security configuration for this specific item?

Accepted Answer

The Lakehouse uses a private link to connect to its underlying data source.. Managed Private Endpoints in Fabric allow for secure communication between Fabric and other Azure services without exposing data to the public internet. This is a key feature for high-security environments. When this property is true, it signifies that the Lakehouse is configured to use a private connection to its data source, enhancing the overall security posture.

Answer

The Lakehouse is only accessible from within a specific Azure VNET.

Answer

The Lakehouse has been shared with an external guest user.

Answer

OneLake shortcuts are disabled for this specific Lakehouse.

Question 10

Refer to the exhibit. Which command would be most effective for improving query performance on this table if you frequently filter by TransDate?

Accepted Answer

OPTIMIZE SalesData ZORDER BY (TransDate). Partitioning or Z-Ordering by a date column is highly effective when queries frequently filter on that specific column. By organizing the data based on the transaction date, the Delta engine can skip large chunks of irrelevant files, significantly reducing the I/O required for queries. This is a critical performance tuning technique in Fabric for handling time-series data efficiently at scale.

Answer

ALTER TABLE SalesData ADD COLUMN Location String

Answer

DROP TABLE SalesData; CREATE TABLE SalesData ... CLUSTER BY (ID)

Answer

VACUUM SalesData

Question 11

You need to monitor the performance of your Fabric SQL Warehouse. Which tool or feature should you use to identify long-running queries?

Accepted Answer

Fabric Query Insights. Monitoring performance is essential for optimizing query execution and managing resources effectively. In Fabric, the 'Query Insights' feature provides detailed telemetry on query duration, user activity, and resource usage. By identifying long-running queries, data engineers can pinpoint inefficient SQL code or missing indexes, which is vital for maintaining the overall stability and responsiveness of the analytical platform for end-users.

Answer

Azure Monitor Metrics

Answer

Data Factory Pipeline Monitor

Answer

Power BI Performance Analyzer

Question 12

You are configuring a new Microsoft Fabric tenant. You want to ensure that users can only create Fabric items if they are assigned to a specific security group. Where should you configure this restriction?

Accepted Answer

Fabric Admin Portal - Tenant Settings. Tenant-level control is managed through the Fabric Admin Portal. Administrators can enable or disable specific features for the entire organization or limit them to specific security groups. This ensures that resource creation is governed and limited to authorized personnel, preventing uncontrolled sprawl and managing capacity costs effectively.

Answer

Microsoft Entra ID (Azure AD) Conditional Access

Answer

Workspace Settings - General

Answer

Azure Subscription - Role Based Access Control (RBAC)

Question 13

You are implementing a security model where users should only see rows matching their assigned department. Which Fabric feature enables this?

Accepted Answer

Row-Level Security (RLS). Row-Level Security (RLS) is essential for ensuring data compliance, especially when sharing reports across different organizational departments. By defining security predicates, data engineers can control access at the record level. This ensures that sensitive data is only accessible to authorized users, which is a fundamental requirement for secure data sharing and analytics governance in Microsoft Fabric.

Answer

Object-Level Security (OLS)

Answer

Workspace Permissions

Answer

Data Masking

Question 14

Your Fabric capacity is consistently reaching 100% utilization during the morning hours, causing background jobs to be delayed. You want to identify which specific items (e.g., specific Notebooks or Warehouses) are consuming the most Capacity Units (CUs). Which tool should you use?

Accepted Answer

Microsoft Fabric Capacity Metrics app. The Microsoft Fabric Capacity Metrics app is the primary tool for monitoring capacity health. It provides detailed insights into CU consumption at the item level, allowing administrators to see exactly which operations are driving costs and performance issues. This visibility is essential for optimizing workloads and making informed decisions about scaling or refactoring.

Answer

Azure Monitor with Log Analytics

Answer

OneLake Explorer

Answer

Fabric Admin Portal - Usage Metrics

Question 15

A company needs to implement a solution where data engineers can create and manage Lakehouses, but they should not be able to delete the workspace itself or modify the capacity settings. Which workspace role should be assigned to these engineers?

Accepted Answer

Contributor. In Microsoft Fabric, the Contributor role allows users to create, edit, and delete workspace items (such as Lakehouses), but they cannot delete the workspace itself, manage capacity settings, or assign roles to other users. The Member and Admin roles both have permissions that allow workspace deletion.

Answer

Admin

Answer

Member

Answer

Viewer

Microsoft Fabric Data Engineer Associate DP-700 practice test

Three ways to study

Study DP-700 by domain

Study DP-700 by topic

Implement and Manage an Analytics Solution practice questions

Ingest and Transform Data practice questions

Monitor and Optimize an Analytics Solution practice questions

DP-700 fundamentals practice questions

DP-700 scenario practice questions

DP-700 troubleshooting practice questions

Microsoft Fabric Data Engineer Associate practice questions