DP-700 Practice Test 2 — 10 Questions

Question 1

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 2

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 3

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 4

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 5

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 6

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 7

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 8

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 9

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 10

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.