DP-700 Implement and Manage an Analytics Solution — Timed 30 Questions

Question 1

You are managing a Microsoft Fabric Lakehouse. You need to ensure that data ingested into the Bronze layer is automatically converted into Delta format for optimized query performance. Which configuration should you prioritize?

30 minute time limit — choose an answer to begin.

Accepted Answer

Write data using the Spark saveAsTable method in Delta format.. Microsoft Fabric Lakehouses automatically convert ingested data into Delta format when using the 'Load to Tables' feature or standard Spark write operations. Option C is correct, but the explanation should clarify that Fabric handles this natively via the Lakehouse engine, rather than implying the user must manually specify Delta format in every Spark write to achieve the 'automatic' requirement mentioned in the stem.

Answer

Enable the 'Always Use CSV' setting in the Lakehouse properties.

Answer

Use the V-Order optimization feature.

Answer

Configure a manual Partitioning policy on the storage account.

Question 2

You are configuring a Power BI DirectLake connection to a Fabric Lakehouse. Which THREE conditions must be met to ensure DirectLake mode functions as intended?

Accepted Answer

The data must be stored in Delta Lake format.. Direct Lake mode functions by loading Delta Lake (Parquet) files directly from OneLake into the Power BI engine memory without a traditional refresh. For this to work: 1) The data must be in Delta Lake format (including the Delta log), 2) The workspace must be assigned to a Fabric capacity (F-SKU) or a Power BI Premium capacity (P-SKU), and 3) The semantic model must reside in the same workspace as the Lakehouse or Warehouse source. While cross-workspace support has been introduced in some specific scenarios, the standard architectural requirement for Direct Lake (and the default semantic model) remains the same workspace.

Answer

The connection must be configured to use the Gateway.

Answer

The data must be cached in the Power BI Service using Import mode.

Question 3

You are developing a Fabric notebook and need to read data from a Lakehouse table. Which code pattern is the most efficient and recommended for performance?

Answer

df = spark.read.csv('files/my_table')

Answer

df = spark.sql('SELECT * FROM LakehouseName.TableName')

Answer

df = spark.read.json('tables/my_table')

Answer

df = spark.read.parquet('files/delta_table')

Question 4

Which Fabric feature allows you to enforce data quality rules and ensure data integrity within the Lakehouse?

Accepted Answer

Delta Lake Constraints. Microsoft Fabric Lakehouses utilize Delta Lake as their storage format, which supports schema enforcement and constraints. Delta Lake Constraints (such as NOT NULL and CHECK constraints) allow data engineers to enforce data quality rules directly at the table level. This ensures that any transaction that violates these rules will fail, maintaining the integrity of the data within the Lakehouse.

Answer

Power BI Dataflows

Answer

Fabric Pipeline Activity Logs

Answer

Workspace Sensitivity Labels

Question 5

You need to automate the deployment of Fabric artifacts across development, test, and production environments. Which THREE components are essential to achieve this?

Accepted Answer

Git integration. While Service Principals are used for authentication in automated scenarios, the core Fabric components for artifact deployment are Git integration, Deployment Pipelines, and the use of Fabric Workspaces. Service Principals are an authentication method, not a deployment component in the same architectural category as the others.

Answer

Manual workspace folder copying

Answer

Power BI Desktop local export

Question 6

Your team is using Microsoft Fabric to process sensitive financial data. You need to implement 'Managed Private Endpoints' to secure the communication between Fabric and an Azure SQL Database. Which TWO statements accurately describe the requirements or behavior of this setup? (Choose TWO)

Accepted Answer

Approval of the endpoint is required in the target Azure resource's 'Private link center'.. Managed Private Endpoints are configured at the workspace level under Workspace settings > Networking. They are not created or managed within a 'Fabric Environment' item, which is a separate compute configuration object.

Answer

Managed Private Endpoints are created and managed within a Fabric Environment item.

Answer

The target Azure resource must have its public network access completely disabled.

Answer

A workspace administrator must approve the endpoint in the Azure Portal.

Answer

Managed Private Endpoints can only be used by Power BI semantic models.

Question 7

You are optimizing a Direct Lake semantic model in Power BI that connects to a Fabric Lakehouse. You notice that some queries are falling back to 'DirectQuery' mode instead of staying in 'Direct Lake' mode. What is the most likely cause for this fallback?

Accepted Answer

The semantic model contains a calculated column defined using DAX.. Calculated columns are supported in Direct Lake mode. The fallback to DirectQuery occurs when a model uses features that cannot be evaluated by the Direct Lake engine, such as calculated tables, certain DAX functions that require the VertiPaq engine (like those involving complex relationships or specific time intelligence), or when the model exceeds the memory limit for the Direct Lake cache. Calculated columns themselves do not force a fallback to DirectQuery.

Answer

The Lakehouse has too many OneLake shortcuts to external Azure regions.

Answer

The capacity has 'Bursting' enabled, which interferes with memory caching.

Answer

The user viewing the report has only 'Viewer' permissions on the workspace.

Question 8

A data engineer is configuring a Microsoft Fabric environment for a team of data scientists. They need to ensure that the environment is consistent and that all notebooks use a specific Spark version and default Lakehouse. Which TWO settings should be configured within the Fabric Environment item? (Choose TWO)

Accepted Answer

The Spark runtime version (e.g., Spark 3.4).. The stem asks for two settings to ensure environment consistency, specifically mentioning Spark version and default Lakehouse. Option C (Public Libraries) is a valid setting within a Fabric Environment, but it does not address the 'default Lakehouse' requirement mentioned in the stem. The explanation fails to address the discrepancy between the stem's requirements and the provided options.

Answer

The Power BI tenant-level 'Publish to Web' settings.

Answer

The frequency of OneLake data compression cycles.

Answer

The sensitivity label of the tenant's primary domain.

Question 9

Your organization is implementing a CI/CD strategy for Microsoft Fabric. You are configuring Deployment Pipelines to move content from a Development workspace to a Test workspace. Which TWO of the following items are currently supported for deployment through Fabric Deployment Pipelines?

Accepted Answer

Lakehouse. As of the current Microsoft Fabric documentation, Lakehouses, Data Pipelines, and KQL Querysets are all supported items for Deployment Pipelines. The original question implies only two are supported, but three of the provided options are valid.

Answer

Eventstream

Answer

Reflex (Data Activator)

Question 10

Refer to the exhibit. A Data Engineer is configuring a Fabric Environment for a workspace that handles large-scale data processing. Based on the JSON configuration provided, what is a direct consequence of the 'spark.dynamicAllocation.enabled' setting being set to 'false'?

Accepted Answer

The Spark session will reserve exactly 4 executors for the entire duration of the session, regardless of actual usage.. Configuration of Spark environments in Fabric allows for fine-tuning performance and costs. Disabling dynamic allocation (spark.dynamicAllocation.enabled = false) forces Spark to use static allocation. In this case, it will reserve the number of executors specified in 'spark.executor.instances' (4) for the duration of the session, which can lead to underutilization if the workload is small or block other jobs if capacity is limited.

Answer

The Spark session will automatically scale the number of executors based on the number of tasks in the queue.

Answer

The Spark session will fail to start if the workspace capacity does not have a warm pool available.

Answer

The memory settings for the driver and executor will be ignored and the default workspace settings will be used.

Question 11

You are using Deployment Pipelines to move a Lakehouse and a Notebook from Development to Test. In the Test workspace, the Lakehouse has a different name and ID than in Development. How should you ensure the Notebook in the Test workspace points to the Test Lakehouse after deployment?

Accepted Answer

Manually edit the Notebook code in the Test workspace after every deployment.. Deployment Rules in Microsoft Fabric currently support parameters for data sources (like SQL connection strings) and parameters for semantic models, but they do not support rebinding Lakehouse references within a Notebook. Notebooks in Fabric use the 'Lakehouse' pane or 'mssparkutils' to reference Lakehouses, and these references are typically maintained via the item's metadata or require manual updates if the Lakehouse ID changes, as Deployment Pipelines do not perform automated code-level rebinding for Lakehouse connections.

Answer

Use 'Deployment Rules' to rebind the Notebook to the correct Lakehouse in the target stage.

Answer

Ensure that the Lakehouses in both workspaces have the exact same name and GUID.

Answer

The pipeline will automatically detect the Lakehouse by its name and update the Notebook.

Question 12

Your team needs to monitor the performance of Spark jobs across multiple workspaces in a single Fabric capacity. Which tool provides the most detailed information about executor allocation, memory usage, and job duration for all Spark activities within that capacity?

Accepted Answer

The 'Monitoring hub' in the Fabric sidebar.. The Microsoft Fabric Capacity Metrics app is designed for monitoring capacity consumption (CU) and throttling, not for granular Spark job performance metrics like executor allocation or memory usage. The Spark UI (accessed via the Monitoring hub or individual notebooks) is the only tool that provides the requested detailed executor-level metrics. The question stem asks for 'detailed information about executor allocation, memory usage, and job duration', which are specific Spark UI metrics, not capacity metrics.

Answer

The Microsoft Fabric Capacity Metrics app.

Answer

The Spark UI within an individual Notebook.

Answer

Azure Monitor logs via a Log Analytics workspace.

Question 13

You are configuring a Fabric Pipeline to move data from an on-premises SQL Server to a Lakehouse. Which TWO actions must you perform to ensure secure, high-throughput data transfer? (Choose TWO)

Accepted Answer

Install and register a self-hosted integration runtime on a machine within the on-premises network.. Microsoft Fabric uses the 'On-premises data gateway' to connect to on-premises data sources. While the underlying technology is similar to Azure Data Factory's SHIR, the correct terminology in the Fabric portal and documentation is 'Data Gateway'.

Answer

Open inbound ports 1433 and 443 on the corporate firewall to allow the Fabric service to poll the SQL Server.

Answer

Configure the pipeline to use Managed Virtual Network (VNet) for all on-premises data source connectivity.

Answer

Use the Azure Data Factory public endpoint to allow direct internet access to the SQL Server database.

Question 14

Refer to the exhibit. You are implementing a custom security policy for a Fabric workspace. Based on the provided JSON policy, what is the impact on Guest users?

Accepted Answer

Guest users can read but not write to any Lakehouse items in the workspace.. The exam code DP-700 is not a valid Microsoft certification exam. Microsoft Fabric data engineering is covered under DP-600.

Answer

Guest users are completely restricted from accessing the workspace.

Answer

Guest users can write to Lakehouses but are denied access to SQL endpoints.

Answer

The policy is invalid and will result in a syntax error during deployment.

Question 15

Which Fabric feature should you use to monitor the long-running execution of a Notebook to identify performance bottlenecks?

Accepted Answer

Fabric Capacity Metrics App. The correct feature in Microsoft Fabric for monitoring notebook execution and identifying bottlenecks is the 'Notebook monitoring' view or the 'Spark UI' (accessed via the notebook's monitoring tab). 'Notebook Job Run Details' is not a formal feature name. Furthermore, the Fabric Capacity Metrics App is actually the primary tool for identifying performance bottlenecks related to capacity consumption and throttling, which are common causes of long-running notebooks.

Answer

Notebook Job Run Details

Answer

OneLake Data Access Logs

Answer

Azure Monitor Log Analytics

Question 16

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 17

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 18

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 19

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 20

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.