DP-700 Exam Simulation — 100 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?

Choose an answer to begin — your selection is scored in the full session.

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

Question 16

Your organization wants to automate the deployment of Fabric items using a CI/CD pipeline in Azure DevOps. You need to programmatically trigger the deployment of a Fabric workspace from the 'Development' stage to the 'Test' stage in a deployment pipeline. Which approach should you use?

Accepted Answer

Use the Fabric REST API 'Deploy' endpoint for pipelines.. Microsoft Fabric provides a REST API that allows for the programmatic management of deployment pipelines. This enables integration with external CI/CD tools like Azure Pipelines or GitHub Actions. By using the 'Deploy' API endpoint, organizations can automate their release process, ensuring that changes are moved through the lifecycle stages based on successful tests or approvals in their DevOps tooling.

Answer

Write a Spark notebook that uses 'mssparkutils' to move items.

Answer

Manually click the 'Deploy' button in the Fabric portal for every release.

Answer

Configure a 'Data Factory' pipeline with a 'Copy' activity to move metadata.

Question 17

A data engineering team is setting up Git integration for a Microsoft Fabric workspace. They need to ensure that the synchronization process is robust and follows best practices for collaborative development. Which TWO actions should the team perform to successfully manage version control for Fabric items? (Choose TWO)

Accepted Answer

Connect the workspace to an Azure DevOps Git repository and branch.. Git integration in Fabric requires both a connection to a supported remote repository and an understanding of how workspace items are serialized into metadata. Proper synchronization involves committing local workspace changes to the remote branch and managing conflicts through standard Git workflows. This process bridges the gap between low-code workspace editing and professional software development practices for data teams.

Answer

Manually export item .bim files and upload them to a GitHub repository.

Answer

Assign the Workspace Admin role to the Service Principal used for Git.

Answer

Convert all Lakehouses to Warehouses to enable Git compatibility.

Question 18

A large enterprise wants to implement a 'Hub and Spoke' data architecture in Microsoft Fabric. They need to share a validated 'Gold' Lakehouse from a central workspace with multiple departmental workspaces without duplicating the underlying storage in OneLake. What is the most effective method to achieve this?

Accepted Answer

Use OneLake shortcuts in departmental Lakehouses.. OneLake shortcuts allow for the virtualization of data across different workspaces and items without moving or copying the data. This supports a 'single source of truth' architecture where data is managed centrally but consumed locally. Using shortcuts minimizes storage costs, reduces data latency, and simplifies the management of data lineage across the entire Fabric tenant.

Answer

Create a Data Pipeline to copy Delta tables daily.

Answer

Export the central Lakehouse as a template and re-import it.

Answer

Configure cross-workspace Power BI DirectQuery models.

Question 19

An organization wants to use Sensitivity Labels from Microsoft Purview to protect data in Microsoft Fabric. When a sensitivity label is applied to a Power BI report in a Fabric workspace, what is the default behavior regarding the protection of data exported from that report to an Excel file?

Accepted Answer

The Excel file will inherit the sensitivity label and any associated encryption settings of the report.. Fabric integrates with Microsoft Purview Information Protection (MIP). This integration ensures that security travels with the data. Understanding how sensitivity labels persist across different formats and tools is vital for maintaining data security and compliance when data leaves the managed Fabric environment into local files.

Answer

The Excel file will have no label, as labels only apply to items within the Fabric service.

Answer

The export will fail unless the user manually selects a label for the Excel file during the download.

Answer

The label will be applied to the Excel file, but any encryption settings will be stripped for compatibility.

Question 20

Refer to the exhibit. Given the retry policy configuration, what happens if the source SQL database is temporarily unavailable during the first attempt?

Accepted Answer

The pipeline retries 3 times with 60-second intervals.. The retry policy defined in the activity configuration instructs the Fabric pipeline to automatically attempt the copy operation again after the specified interval. This is a critical feature for building resilient pipelines that can gracefully handle transient network errors or brief service outages without failing the entire job. It ensures higher pipeline success rates and reduces the need for manual monitoring and intervention in complex, real-world cloud environments.

Answer

The pipeline fails immediately.

Answer

The pipeline retries indefinitely.

Answer

The pipeline executes the next activity immediately.