DP-700 Practice Test 12 — 15 Questions

Question 1

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?

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

Accepted Answer

Multi-geo capacities. 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.

Answer

Workspace-level region settings

Answer

Tenant setting: 'Users can create and use shortcuts'

Answer

Sensitivity labels with mandatory labeling

Question 2

You are configuring Git integration for a Microsoft Fabric workspace to enable source control for your team. Which TWO requirements must be met before you can successfully connect the workspace to an Azure DevOps repository?

Accepted Answer

The Fabric tenant setting 'Users can export items' must be enabled.. Successful Git integration in Microsoft Fabric requires both organizational-level permissions and specific repository configurations. Ensuring these prerequisites are met allows for seamless synchronization of workspace items. Without the correct tenant settings or repository access, users will encounter errors when attempting to commit changes or sync the workspace with the remote branch.

Answer

The workspace must be assigned to a Trial capacity.

Answer

The repository must be hosted in GitHub Enterprise.

Answer

The user must have the 'Viewer' role in the Fabric workspace.

Question 3

A Data Engineer needs to share a specific folder within a Lakehouse with a different team. The team should only be able to read the files in that specific folder and should not have access to any other data in the Lakehouse or the ability to run Spark notebooks. What is the most secure method to implement this?

Accepted Answer

Create a OneLake data access role for the specific folder.. OneLake data access roles (preview) provide the granular security necessary to restrict access at the folder level within a Lakehouse. This bypasses the 'all-or-nothing' approach of workspace roles, allowing for fine-grained control. By using these roles, you can adhere to the principle of least privilege, ensuring users only see what they need.

Answer

Assign the team the 'Viewer' role in the workspace.

Answer

Share the Lakehouse and grant 'Read all OneLake data'.

Answer

Use a SQL Analytics Endpoint to grant SELECT on a view.

Question 4

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?

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 5

You are planning to use OneLake shortcuts to access data stored in an Azure Data Lake Storage (ADLS) Gen2 account. Which TWO authentication methods are supported by Microsoft Fabric for establishing this connection?

Accepted Answer

Organizational account (OAuth 2.0). Establishing secure connections to external data sources is a fundamental task in Fabric. OneLake shortcuts support several authentication mechanisms to accommodate different security architectures. Choosing the right method ensures that data access is both secure and performant while adhering to organizational security policies and identity management standards.

Answer

Anonymous access

Answer

Shared Access Signature (SAS) token at the container level

Answer

SSH Public Key

Question 6

You are the Fabric Administrator for a large enterprise. You need to organize workspaces by business department (e.g., Finance, Marketing, Sales) to allow department heads to manage their own settings and users while still maintaining centralized billing. What is the most efficient way to achieve this grouping and delegated management?

Accepted Answer

Implement Domains and assign workspaces to them.. Domains in Microsoft Fabric allow administrators to group workspaces into logical containers based on business needs. This enables the delegation of domain-specific settings and administration to department leads (Domain Owners). It allows for a decentralized management model while keeping all resources under a single tenant and capacity for billing and governance purposes.

Answer

Create separate Azure tenants for each department.

Answer

Assign each department to a different Capacity.

Answer

Use Workspace Folders to organize items.

Question 7

Refer to the exhibit. Your Fabric capacity is showing a status of 'Throttled' for background operations. Based on the JSON snippet from the capacity monitoring logs, what is the most likely consequence for a new Spark Notebook scheduled to run immediately?

Accepted Answer

The notebook will be rejected and fail to start.. Fabric uses a smoothing mechanism for capacity utilization. When background operations exceed the capacity (utilization > 1.0), the overage is spread over 24 hours. If the overage becomes too large, the capacity enters a throttled state where new background requests are rejected until the utilization drops below the threshold, ensuring stability.

Answer

The notebook will run but at a reduced speed.

Answer

The notebook will be automatically upgraded to an interactive task.

Answer

The notebook will be moved to a different capacity automatically.

Question 8

Refer to the exhibit. An engineer receives this error when attempting to trigger a Fabric pipeline. What is the most likely cause?

Accepted Answer

The user lacks the appropriate workspace role.. This error indicates a workspace-level permission issue. In Microsoft Fabric, access is controlled via workspace roles, not just individual item permissions. If the service principal or user lacks the 'Member' or 'Admin' role, they cannot trigger pipelines or manage artifacts within that specific workspace. Understanding role-based access control is vital for securing data pipelines and ensuring that automated processes have the necessary authorization to execute successfully without unauthorized access.

Answer

The pipeline is missing a required input parameter.

Answer

The pipeline capacity is currently paused.

Answer

The pipeline is currently being updated by another user.

Question 9

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.

Question 10

Your enterprise requires strict compliance tracking for all data pipeline executions inside a Microsoft Fabric workspace. You need to implement a monitoring solution that captures detailed activity logs, pipeline run statuses, and capacity consumption metrics over a 180-day retention period for auditing purposes. What is the most effective native mechanism to achieve this?

Accepted Answer

Configure a diagnostic setting in Azure to stream Fabric workspace logs and capacity metrics to a Log Analytics workspace.. Configuring a diagnostic setting in the Azure portal routes Fabric workspace logs and capacity metrics to an Azure Log Analytics workspace or Azure Storage account. This native integration enables long-term retention beyond the default Fabric limits and provides advanced querying capabilities via Kusto Query Language for rigorous compliance auditing.

Answer

Export the run history manually from the Fabric monitoring hub every thirty days into a shared SharePoint folder.

Answer

Rely solely on the default Fabric monitoring hub retention period to store pipeline execution telemetry.

Answer

Write custom Spark notebooks in a lakehouse to query the internal workspace metadata APIs and append logs to Delta tables daily.

Question 11

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 12

A company is implementing a Data Mesh architecture using Microsoft Fabric. They want to delegate the management of the 'Finance' domain to a specific group of users. What is the minimum administrative requirement to allow these users to manage domain settings and assign workspaces without making them Fabric Administrators?

Accepted Answer

Assign the users to the 'Domain Owner' role for the Finance domain.. Data Mesh decentralizes data ownership. In Fabric, this is achieved through Domains. Delegating domain management allows business units to take control of their own data governance. Understanding the 'Domain Owner' role and its permissions is key to scaling Fabric across a large organization with diverse needs.

Answer

Assign the users the 'Capacity Admin' role for the capacity hosting the Finance workspaces.

Answer

Make the users 'Admins' of every workspace that belongs to the Finance department.

Answer

Grant the users 'Contributor' access to the Fabric Admin portal.

Question 13

You are using a Copy Activity in Microsoft Fabric Data Factory. You need to ensure that the data is encrypted both in transit and at rest. Which setting should you verify?

Accepted Answer

Check the 'Use Encrypted Connection' property in the Linked Service. Microsoft Fabric automatically handles encryption at rest for all data stored in OneLake. For data in transit, you must ensure that your connections use encrypted protocols like HTTPS or TLS. By default, Fabric connectors are configured to use secure channels, but verifying these settings ensures compliance with corporate security mandates regarding data in transit protection during ingestion from external sources into your Fabric environment.

Answer

Enable 'Force TLS 1.2' on the source server

Answer

Manually encrypt the files using a PGP key

Answer

Configure an Azure Key Vault secret for the data

Question 14

Refer to the exhibit. The Spark job completed but took 45 minutes for a 100 million row dataset. The shuffle write size is significantly high. What should you investigate to improve performance?

Accepted Answer

Investigate join strategies and broadcast settings.. A high shuffle write size relative to the input dataset suggests that the job is performing excessive data movement across the cluster. This is typically caused by inefficient joins, such as sort-merge joins where broadcast joins would have been more efficient. Investigating the join strategy and partition counts helps identify why so much data is being shuffled, which is the primary cause of latency in large-scale Spark jobs that process significant volumes of data.

Answer

Reduce the number of partitions.

Answer

Enable auto-vacuuming on the table.

Answer

Increase the disk capacity of the Lakehouse.

Question 15

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.