DP-700 Implement and Manage an Analytics Solution Practice Test 4 — 15 Questions

Question 1

A data engineer needs to share a workspace with a colleague who must be able to create, edit, and delete items like Lakehouses and Notebooks, but should not be allowed to modify workspace permissions or add new members. Which workspace role should be assigned?

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

Accepted Answer

Contributor. The Contributor role in Microsoft Fabric is designed for developers who need to manage the lifecycle of workspace items without having administrative control over the workspace itself. This role balances the need for productivity with the principle of least privilege. Understanding these roles is essential for maintaining secure and organized collaborative environments in a Fabric tenant.

Answer

Admin

Answer

Member

Answer

Viewer

Question 2

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)

Accepted Answer

Retry policy settings on the Copy activity.. 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.

Answer

The 'Wait' activity for fixed delays.

Answer

The 'Stored Procedure' activity to update OneLake metadata.

Question 3

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 4

Refer to the exhibit. A data engineer applies this configuration to a Microsoft Fabric notebook session. Which statement best describes the impact of this configuration on the analytics solution?

Accepted Answer

It optimizes Delta tables for faster reading, specifically benefiting Direct Lake mode.. V-Order and Optimize Write are Fabric-specific enhancements for Spark that significantly improve read and write performance for Delta tables. V-Order applies a specialized sorting and compression algorithm to Parquet files, making them optimized for the 'Direct Lake' mode in Power BI. Understanding these configurations is vital for building high-performance data lakes that integrate seamlessly with reporting layers.

Answer

It enables encryption at rest for all Parquet files generated in the session.

Answer

It forces the notebook to use a high-concurrency Spark pool for all users.

Answer

It disables the creation of transaction logs to save storage space in OneLake.

Question 5

An organization must comply with strict data residency requirements. They have a Microsoft Fabric tenant in the 'East US' region but need to create a workspace where data is stored and processed in 'North Europe'. How can the administrator achieve this?

Accepted Answer

Create a capacity in North Europe and assign the workspace to it.. Fabric allows for 'Multi-Geo' capabilities where specific capacities can be created in regions different from the home region of the tenant. By assigning a workspace to a capacity located in 'North Europe,' the data for that workspace will reside in that specific geographic location. This is a critical feature for global organizations needing to satisfy regional data sovereignty laws.

Answer

Change the tenant's primary region in the Admin portal settings.

Answer

Use a OneLake shortcut to move the data to North Europe.

Answer

Enable the 'Global Data Sync' feature in the workspace settings.

Question 6

You are managing a Microsoft Fabric workspace and notice that several notebooks are failing because they cannot find specific Python libraries. You want to ensure that every notebook in the workspace has access to the same version of these libraries without manual installation in each notebook. What should you do?

Accepted Answer

Create a Fabric Environment, upload the libraries, and set it as the workspace default.. Fabric Environments allow for the definition of a common set of libraries (Python, R, etc.) and Spark configurations that can be applied workspace-wide or to specific notebooks. By managing libraries at the environment level, you ensure consistency, reduce code duplication, and simplify the maintenance of dependencies across your entire analytics solution. This is a core management task for data engineers.

Answer

Add a '!pip install' command to the first cell of every notebook.

Answer

Upload the library .whl files directly into the 'Files' section of the Lakehouse.

Answer

Email the developers and ask them to update their personal Spark settings.

Question 7

An organization is using the 'Fabric Capacity Metrics' app to monitor their F64 capacity. They see a high 'Background rejection' rate. What does this indicator typically mean for the analytics solution?

Accepted Answer

Scheduled jobs and refreshes are being throttled due to capacity exhaustion.. Background rejection occurs when the capacity has exhausted its available units and the 'smoothing' window for background tasks (like scheduled refreshes or notebook jobs) is full. Unlike interactive tasks, which may experience latency, background tasks are rejected if they cannot be accommodated within the capacity's future limits. Monitoring this metric is vital for right-sizing the capacity for automated workloads.

Answer

The firewall is blocking requests from unauthorized IP addresses.

Answer

The OneLake storage limit has been exceeded for the tenant.

Answer

User login attempts to the Fabric portal are failing.

Question 8

You are implementing a security strategy for Microsoft Fabric. You need to ensure that data access is restricted based on sensitivity labels and that these labels persist when data is exported to Excel. Which TWO statements describe the behavior of sensitivity labels in Fabric? (Choose TWO)

Accepted Answer

Labels applied to a semantic model can be automatically inherited by downstream reports.. Sensitivity labels from Microsoft Purview Information Protection are integrated into Fabric to provide end-to-end data governance. These labels help classify data and can apply encryption or watermarks that follow the data even after it leaves the service. Understanding how these labels propagate and protect data is essential for maintaining compliance in a modern analytics solution.

Answer

Sensitivity labels in Fabric only affect the UI color and do not provide protection.

Answer

Labels are only available for Power BI items and cannot be applied to Lakehouses.

Answer

Sensitivity labels automatically delete any data that is older than three years.

Question 9

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 10

A large enterprise is organizing its Microsoft Fabric environment. They need to allow a team of developers to create and modify Lakehouses, Warehouses, and Notebooks within a specific workspace. However, the organization's security policy dictates that these developers must not be able to share items or modify the workspace's membership. Which workspace role should you assign to these developers?

Accepted Answer

Contributor. This scenario focuses on the administrative overhead and security implications of workspace management. Assigning the correct role ensures that developers have enough permission to perform their primary duties, such as creating Spark notebooks and Data Pipelines, without granting excessive rights that could lead to unauthorized data sharing or workspace configuration changes that affect the entire project team.

Answer

Admin

Answer

Member

Answer

Viewer

Question 11

A company is using Git integration in Microsoft Fabric to manage their Lakehouse and Report items. They notice that after a developer committed changes to a branch and synced them to the workspace, certain sensitive metadata files are being tracked in the repository. Which file should be modified in the local Git repository to prevent specific Fabric item metadata from being tracked in the future?

Accepted Answer

.gitignore. Git integration in Fabric synchronizes item definitions between the workspace and a Git provider. To manage which files are ignored or tracked, standard Git practices apply. This is essential for preventing the leakage of sensitive internal metadata or temporary files that should not be part of the version control history of the analytics project.

Answer

fabric.config

Answer

.fabricignore

Answer

item.config.json

Question 12

An administrator needs to organize Fabric items using Domains. They want to ensure that items are automatically assigned to the 'Sales' domain based on their location. Which THREE of the following steps are required to implement and verify this domain-based organization?

Accepted Answer

Create the 'Sales' domain in the Fabric Admin portal.. Domains in Fabric provide a way to group workspaces and items by business units. Automating this process reduces manual effort and ensures consistent governance. Understanding the workflow from creation to assignment and verification is key for administrators managing large-scale Fabric environments with multiple business departments and varying data ownership.

Answer

Define a workspace name-based rule for automatic assignment.

Answer

Enable the 'Contributors can update domain' setting.

Question 13

A company is using a Fabric F64 capacity. During a period of low activity, the administrator wants to reduce costs. What is the most direct way to stop incurring charges for the Fabric compute resources without deleting the capacity?

Accepted Answer

Pause the capacity in the Azure portal.. Managing Fabric capacity costs is a critical task for administrators. F-SKU capacities offer flexibility that P-SKUs do not, specifically the ability to pause and resume. This allows organizations to align their spending with actual usage patterns, such as shutting down resources during weekends or non-business hours.

Answer

Delete all workspaces associated with the capacity.

Answer

Switch the capacity to a 'Trial' license.

Answer

Remove all users from the Fabric Admin role.

Question 14

You have a Lakehouse in a workspace and want to allow a specific user to query the data using the SQL analytics endpoint, but you do not want them to be able to modify the Lakehouse schema or delete files. Which action should you take?

Accepted Answer

Share the Lakehouse with the user and grant 'Read' and 'ReadData' permissions.. This question explores the granularity of permissions in Microsoft Fabric. Providing access to the SQL analytics endpoint requires specific permissions that differ from the full 'Contributor' access. Understanding how to share items with 'Read' and 'ReadData' permissions is essential for implementing a least-privilege security model.

Answer

Assign the user to the Contributor role in the workspace.

Answer

Grant the user 'Execute' permissions on the workspace capacity.

Answer

Add the user to the 'Member' role and disable 'Share' permissions.

Question 15

Refer to the exhibit. An administrator is reviewing the capacity metrics for a Fabric F64 capacity. The logs indicate that the 'percentUtilization' has exceeded 100% and the 'throttlingStatus' is 'Throttled'. What is the most likely cause for this behavior in a Fabric environment?

Accepted Answer

The cumulative 'debt' from previous burstable operations has exceeded the allowable limits.. Fabric uses a smoothing mechanism to handle bursts in activity. When utilization exceeds 100% of the purchased capacity, the system allows the burst but tracks the debt. If the debt becomes too large over a 24-hour period (for background tasks) or a shorter window (for interactive tasks), throttling occurs.

Answer

The capacity has been paused by an automated script.

Answer

A user has manually capped the utilization at 100% in the Admin portal.

Answer

The OneLake storage limit has been reached, causing compute operations to fail.