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

Question 1

You need to automate the deployment of Fabric items across environments. Which THREE components are essential for a robust CI/CD pipeline in Microsoft Fabric? (Choose THREE)

Accepted Answer

Git integration for source control versioning.. A robust CI/CD pipeline in Microsoft Fabric relies on Git integration for versioning, Deployment Pipelines for promoting content between environments, and Service Principals to facilitate automated, non-interactive authentication for API-driven deployment tasks. Git integration ensures code is versioned in a repository, while Deployment Pipelines provide a managed way to move items through Dev/Test/Prod stages. Service Principals are the standard for securing automated workflows in enterprise environments.

Answer

Manual file copying using the OneLake file system explorer.

Answer

Hardcoded connection strings in Notebook code.

Question 2

Your organization uses Microsoft Fabric with three distinct workspaces for Development, Test, and Production. You need to automate the movement of a Lakehouse and its associated semantic model through these environments while ensuring that the Production environment uses a different data source connection string than the Development environment. Which feature should you implement?

Accepted Answer

Deployment Pipelines with Deployment Rules. Deployment pipelines in Microsoft Fabric provide a structured workflow for promoting content across environments. By using deployment rules, you can automatically update parameters such as connection strings or data source paths during the promotion process. This ensures that the Production environment remains isolated and points to the correct enterprise-grade data sources without requiring manual intervention or code changes.

Answer

Workspace Git Integration

Answer

OneLake Data Access Roles

Answer

Fabric REST API with Power BI Cmdlets

Question 3

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 4

Refer to the exhibit. You are reviewing the JSON definition for a Spark Job Definition in Microsoft Fabric. The job is failing after exhausting all retries during periods of high capacity utilization. To ensure the job has a better chance of succeeding without increasing the maxRetryCount, which change should you implement in the job configuration?

Accepted Answer

Add a 'retryIntervalInSeconds' property to the retryPolicy.. When a Spark job fails due to capacity constraints or resource contention, the failure often happens quickly. By adjusting the retry policy to include an interval or delay, the job can wait for transient capacity spikes to subside before attempting the next run. This increases the likelihood of success in a busy Fabric environment where resources are shared.

Answer

Increase the 'numExecutors' value to 10.

Answer

Change the 'runtimeVersion' to 1.3.

Answer

Change the 'driverSize' to 'Large'.

Question 5

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 6

You are configuring a deployment pipeline to move a Lakehouse from a Test workspace to a Production workspace. Which THREE types of deployment rules can you apply to ensure the Lakehouse functions correctly in the Production environment?

Accepted Answer

Data source rules. Deployment rules are essential for tailoring Fabric items to their destination environment. For Lakehouses and semantic models, you can define rules that change the underlying data sources or parameters. This prevents the Production environment from accidentally referencing Test data and allows for a seamless transition that maintains data integrity and security across the lifecycle stages.

Answer

Lakehouse name rules

Answer

User permission rules

Question 7

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 8

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 9

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?

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 10

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 11

You are setting up a Microsoft Fabric environment for a development team. You want to use Git integration to allow developers to work in their own branches. Which THREE Fabric items are currently supported for Git integration?

Accepted Answer

Lakehouse. Not all Fabric items are currently supported by Git integration. Knowing which items can be synchronized is vital for planning your development lifecycle and source control strategy. As Fabric evolves, more items are added, but the core items like Lakehouses, Notebooks, and Semantic Models form the basis of most synchronization workflows.

Answer

Data Pipeline

Answer

KQL Queryset

Question 12

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 13

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 14

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 15

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