DP-700 Practice Exam 4 — 20 Questions

Question 1

Refer to the exhibit. The query is performing a full table scan on a 1TB table. What is the most effective way to optimize this query?

Accepted Answer

Replace 'SELECT *' with specific column names.. Selecting only the necessary columns (column projection) is a fundamental best practice in analytical query optimization. By avoiding 'SELECT *', you reduce the amount of data read from storage and transferred over the network. In column-oriented stores like those in Fabric, this allows the engine to only read the relevant columns, drastically reducing I/O and latency for queries on large datasets.

Answer

Increase the cluster memory size.

Answer

Add a clustered index to all columns.

Answer

Enable query parallelism.

Question 2

You are analyzing a performance bottleneck using the 'Timepoint Detail' page in the Fabric Capacity Metrics app. Which THREE pieces of information can you find here to help identify the specific cause of a capacity overage? (Select THREE)

Accepted Answer

The name of the operation and the item that triggered it.. The Timepoint Detail page is the most granular view in the Capacity Metrics app. It allows you to see exactly what was happening during a specific 30-second window when the capacity was under load. This detail is essential for identifying 'noisy neighbors' or specific jobs that are consuming more than their fair share of resources.

Answer

The physical IP address of the Spark executor nodes.

Answer

The SQL execution plan for every query in the timepoint.

Question 3

You are optimizing a Data Warehouse in Microsoft Fabric. Which TWO strategies will effectively improve the performance of read-heavy workloads?

Accepted Answer

Implement Clustered Columnstore Indexes.. For read-heavy workloads in a data warehouse, indexing and proper table design are critical. Clustered Columnstore Indexes provide massive data compression and are optimized for analytical queries that scan large volumes of data. Additionally, implementing partitions allows the engine to prune data at the storage level, ensuring that only relevant partitions are scanned, thus reducing the total I/O and accelerating query execution.

Answer

Increase the number of rows per transaction.

Answer

Use row-based storage exclusively.

Answer

Disable data compression.

Question 4

Which feature in Microsoft Fabric allows you to track the movement and transformation of data from source to destination?

Accepted Answer

Data Lineage. Data lineage provides a visual representation of the path data takes across a system. In Fabric, this is critical for debugging failures and understanding dependencies. By tracking lineage, you can quickly determine how a change in an upstream data source impacts downstream reports, facilitating better impact analysis and ensuring data quality across the entire analytical ecosystem.

Answer

Data Pipeline

Answer

OneLake

Answer

Notebook

Question 5

You are troubleshooting a slow-running SQL query in a Fabric Data Warehouse. The query plan shows a high cost associated with a 'Broadcast Nested Loop Join'. What should you do to optimize this?

Accepted Answer

Update the table statistics.. A Nested Loop Join is often inefficient for large datasets because it iterates through the outer table for every row in the inner table. If the optimizer chose a broadcast join on a large table, it might be due to outdated statistics. Updating statistics allows the query optimizer to make better decisions about join types, likely switching to a more efficient hash join that is better suited for large-scale data processing.

Answer

Increase the number of compute nodes.

Answer

Disable the query optimizer.

Answer

Rewrite the query using a cursor.

Question 6

You are using the Microsoft Fabric Capacity Metrics app and notice that your capacity is frequently hitting the limit for 'Interactive' operations. What should you do first?

Accepted Answer

Use the metrics app to identify top-consuming items.. Before scaling up the capacity, you must identify the source of the high utilization. The Capacity Metrics app allows you to drill down into the operations that are consuming the most resources. By identifying the specific semantic models, reports, or users that are driving the high consumption of interactive operations, you can optimize those specific items, which may prevent the need for expensive upgrades to the capacity SKU.

Answer

Immediately scale up the capacity SKU.

Answer

Clear the browser cache for all users.

Answer

Delete all unused reports in the workspace.

Question 7

You are auditing a Fabric workspace to ensure optimal performance. You want to see the execution history and duration of all Spark notebooks run within the last 30 days. Where should you look?

Accepted Answer

The Workspace Monitor Hub. The Workspace Monitoring hub provides a centralized interface for viewing the activity of Spark-based items. By accessing the monitor tab, you can view job status, start times, and durations. This is vital for identifying long-running jobs that may be causing bottlenecks and for ensuring that automated pipeline runs are adhering to the expected time-to-completion service level agreements.

Answer

The Fabric Capacity Metrics App

Answer

Microsoft Purview Compliance Portal

Answer

The OneLake File Explorer

Question 8

Which tool in Fabric provides the most detailed view of the billable capacity usage for your tenant?

Accepted Answer

The Fabric Capacity Metrics app. The Fabric Capacity Metrics app is the authoritative source for understanding how your consumption maps to billing. It translates technical usage metrics into visual reports that show how much compute you are using relative to your purchased SKU. This is critical for budget management and for identifying which departments or workspaces are the primary drivers of your organization's cloud expenditure.

Answer

The Microsoft Cost Management portal

Answer

Azure Advisor

Answer

The Fabric Admin Portal

Question 9

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 10

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 11

Which component in Microsoft Fabric is primarily designed for data integration and orchestration of complex workflows?

Accepted Answer

Data Factory. Data Factory in Microsoft Fabric serves as the primary orchestration engine. It enables users to build pipelines that move data, transform it using data flows, and coordinate activities across different storage locations. Understanding the role of Data Factory is foundational for implementing automated data movement, which is a core requirement for building and maintaining robust analytics solutions within the Fabric ecosystem.

Answer

Power BI

Answer

KQL Database

Answer

Notebooks

Question 12

You have a Power BI report connected to a Fabric Lakehouse using DirectLake mode. Users report that the data in the report is not reflecting the latest changes made to the Delta tables in the Lakehouse. What should you check first to resolve this?

Accepted Answer

The 'Keep your Direct Lake data up to date' setting.. DirectLake mode relies on the semantic model being able to read Delta files directly from OneLake. However, for the model to see updates, it must be synchronized with the latest metadata of the Lakehouse. If 'Keep your Direct Lake data up to date' is disabled, the model will not automatically reflect changes until a refresh is triggered.

Answer

The SQL Analytics Endpoint connection string.

Answer

The Spark cluster's auto-termination settings.

Answer

The V-Order optimization status of the Delta tables.

Question 13

When designing an analytics solution, what is the primary purpose of the 'Gold' layer in a Medallion architecture?

Accepted Answer

Providing curated, business-ready data for analytics.. The Medallion architecture is a standard design pattern for data lakes. The Gold layer contains refined, business-level data that is ready for consumption by reports and dashboards. Understanding the stages of the Medallion architecture is essential for data engineers to maintain logical separation between raw ingested data, cleaned data, and final curated datasets, ensuring that analytics solutions remain clean, performant, and reliable for end users.

Answer

Storing raw, unvalidated data from source systems.

Answer

Storing cleaned and deduplicated data for internal engineering use.

Answer

Acting as a temporary sandbox for data exploration.

Question 14

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 15

Your organization requires that all data stored in the Fabric Lakehouse must be encrypted at rest using a customer-managed key (CMK). What is the mandatory step to achieve this?

Accepted Answer

Configure the Fabric capacity to use an Azure Key Vault.. Implementing CMK in Fabric involves integrating with Azure Key Vault to manage the encryption keys. This provides organizations with full control over their data security posture, meeting strict compliance requirements. Understanding the configuration process for CMK is vital for data engineers responsible for enterprise-grade security and governance, as it impacts how the underlying storage and compute layers access protected data assets within the Fabric workspace.

Answer

Enable encryption in the Lakehouse property settings.

Answer

Rotate the encryption keys in the Power BI Admin portal.

Answer

Apply a Data Policy tag to the Lakehouse artifact.

Question 16

You need to perform a complex transformation that involves multiple joins across tables of varying sizes in Fabric. Which tool provides the best balance between performance and ease of use?

Accepted Answer

Fabric Dataflow Gen2.. Dataflows Gen2 are specifically designed for low-code ETL, providing a visual interface that translates into efficient Spark jobs. They handle complex joins and transformations natively, making them ideal for standard data engineering tasks. They abstract the complexity of Spark configuration while providing enough power to manage large-scale data manipulation, making them the superior choice for most transformation scenarios compared to manual coding.

Answer

Microsoft Purview Data Catalog.

Answer

A SQL stored procedure on an on-premises server.

Answer

Azure Data Factory pipeline parameters only.

Question 17

Which action must be taken to enable 'Time Travel' functionality on a Delta Lake table in Fabric?

Accepted Answer

Ensure data is stored in Delta format.. Time Travel in Delta Lake is a powerful feature that allows users to query past states of data for auditing or error recovery. It works by retaining history in the transaction log. Understanding how to manage this feature is vital for data engineers who need to ensure data resilience and recover from accidental deletions or corruption events within the production analytics pipeline.

Answer

Configure the 'Retention Period' in the workspace settings.

Answer

Enable the 'Time Travel' flag on the Lakehouse.

Answer

Create a secondary copy of the table manually.

Question 18

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 19

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 20

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.