DP-600 Hard Questions — 25 Difficult Questions

Question 1

A Lakehouse in your Fabric environment has grown significantly over time, and you notice that query performance on the Delta tables is decreasing. You also want to minimize storage costs by removing older versions of data files that are no longer needed for 'Time Travel'. Which maintenance strategy should you implement?

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

Accepted Answer

Schedule a notebook to run 'OPTIMIZE' followed by 'VACUUM' on the tables.. Regular maintenance of Delta tables is essential for both performance and cost management in Microsoft Fabric. The OPTIMIZE command improves data layout for faster reads, while the VACUUM command removes obsolete files. Together, these operations keep the Lakehouse efficient by ensuring that only necessary, well-structured data is retained and processed during queries, preventing 'file sprawl' in the underlying storage.

Answer

Run a Spark notebook that executes the 'REORG' command on all tables.

Answer

Enable the 'Auto-shrink' property in the Lakehouse settings to manage storage.

Answer

Delete the Lakehouse and recreate it from the original data sources weekly.

Question 2

A Microsoft Fabric capacity is frequently experiencing 'Interactive Delay' during peak hours. You need to implement maintenance strategies to mitigate this without increasing the SKU size. Which TWO strategies should you prioritize?

Accepted Answer

Schedule large Warehouse and Lakehouse refreshes during off-peak hours.. Managing capacity performance is essential for maintaining a responsive analytics environment. Interactive delays occur when the capacity is over-utilized, and the system throttles new requests. By optimizing the distribution of background tasks and improving query efficiency, engineers can maximize the utility of their current SKU and ensure that high-priority interactive reports remain performant.

Answer

Enable 'DirectQuery' for all semantic models to reduce memory load.

Answer

Increase the 'Refresh Frequency' of all reports to ensure data freshness.

Answer

Disable the 'Smoothing' feature in the Fabric Admin portal.

Question 3

Refer to the exhibit. You receive this JSON response when checking the Git status of a Fabric workspace. What is the most appropriate next step to maintain the integrity of the Semantic Model named 'SalesModel'?

Accepted Answer

Perform a manual merge in the Git provider to consolidate the branch history.. The exhibit indicates a Git synchronization conflict where changes exist in both the workspace and the remote repository. Maintenance of a production-grade solution requires resolving these discrepancies in a controlled environment. Understanding the status codes helps engineers diagnose synchronization failures and apply the correct remediation steps to ensure that the production environment remains stable and version-aligned.

Answer

Commit the local changes using the 'Override Remote' flag in the Fabric API.

Answer

Disconnect the workspace from Git and reconnect it to a fresh repository.

Answer

Restart the Microsoft Fabric capacity to clear the synchronization lock.

Question 4

You are troubleshooting a failure in a Microsoft Fabric Data Factory pipeline. The error log indicates a 'Timeout' occurred during a 'Copy Data' activity from an on-premises SQL Server. Which maintenance action is most likely to resolve the issue?

Accepted Answer

Check the On-premises Data Gateway logs for 'System Load' or 'Concurrency' issues.. Maintaining hybrid data solutions involves managing the connection between cloud and on-premises environments. Timeouts during data movement often point to issues with the On-premises Data Gateway or the network path. Effective troubleshooting requires checking the health of the gateway and the resources of the source system to ensure they can handle the requested load.

Answer

Increase the 'Max Parallelism' setting in the Fabric workspace properties.

Answer

Convert the SQL Server table to a Delta table before the copy activity.

Answer

Switch the authentication method from 'Basic' to 'OAuth2'.

Question 5

A large semantic model using Direct Lake mode is experiencing slow query performance. You want to optimize the model's maintenance and performance. Which THREE actions should you take?

Accepted Answer

Run the OPTIMIZE command on the underlying Delta tables in the Lakehouse.. Optimizing Direct Lake models requires a combination of data engineering and model configuration. Direct Lake relies on the ability to load Parquet files directly into memory, so the physical layout of the files and the complexity of the DAX measures are critical factors. Maintaining these aspects ensures that the model can stay in 'Direct Lake' mode without falling back to 'DirectQuery'.

Answer

Convert all calculated columns in the semantic model to Power Query M columns.

Answer

Increase the 'Max Intermediate Rows' setting in the Power BI capacity settings.

Question 6

You are using the Tabular Model Definition Language (TMDL) to maintain a complex semantic model in Microsoft Fabric. You need to make a bulk change to the descriptions of 50 different measures. What is the most efficient way to perform this maintenance task?

Accepted Answer

Edit the individual .tmdl files in a code editor and sync the changes via Git.. TMDL is a human-readable format for defining semantic models, making it ideal for bulk maintenance and version control. By editing TMDL files in a text editor or using scripts, engineers can apply changes much faster than using a GUI. This approach is highly recommended for large-scale models where manual updates are time-consuming and prone to inconsistencies across different measures.

Answer

Manually update each description in the Power BI Desktop 'Model View' properties pane.

Answer

Use a Power Automate flow to iterate through the measures and update them via the UI.

Answer

Delete the measures and recreate them using a SQL script in the Lakehouse endpoint.

Question 7

You are updating a semantic model in Fabric. You need to ensure that the model supports incremental refresh without duplicating data. What is the most effective approach to configure this?

Accepted Answer

Create RangeStart and RangeEnd parameters with Date/Time types.. While RangeStart and RangeEnd parameters are necessary, they are not sufficient on their own to prevent data duplication. The model must also be configured with a specific 'Incremental refresh' policy in the Power BI service/Fabric that defines the storage partition ranges and the 'Detect data changes' column (if applicable) to ensure existing data is updated rather than appended.

Answer

Use an M-query to filter data by the current date.

Answer

Set the refresh policy to 'Full' every time.

Answer

Use a custom SQL query in the Power Query editor.

Question 8

You are auditing a Fabric solution and find that users can download raw data from a report even though the semantic model has RLS enabled. What is the most likely cause?

Accepted Answer

Users have been granted 'Build' permission on the semantic model.. RLS is enforced by the semantic model, but if users have 'Build' or 'Contributor' permissions on the semantic model or workspace, they may still have access to the underlying data. Understanding the intersection of security layers is vital. You must ensure that users have only the minimum necessary permissions—View, not Build—to prevent unauthorized extraction of raw data from the model's source.

Answer

RLS only works for users in the Guest role.

Answer

The data is cached in the browser.

Answer

The Lakehouse has public access enabled.

Question 9

Refer to the exhibit. You are reviewing the M-code for a Dataflow Gen2. To ensure that the 'FilteredRows' step is executed on the source SQL Server rather than in the Fabric Mashup engine, what concept must be maintained?

Accepted Answer

Query Folding. Query folding is the ability of Power Query to translate M-code into the native language of the source system, such as T-SQL. When folding occurs, the source system handles the filtering and column selection, which is much more efficient than transferring all data to Fabric for processing. Maintaining folding is critical for performance.

Answer

Data Source Privacy Levels

Answer

Schema Drift

Answer

Fast Copy

Question 10

You are setting up a deployment pipeline for a workspace that contains sensitive financial data. Which TWO of the following permissions or conditions are required for a user to deploy content from the Test stage to the Production stage? (Select TWO)

Accepted Answer

The user must be an Admin or Member of both the Test and Production workspaces.. Security and permissions management is a cornerstone of maintaining a secure Fabric environment. Deployment pipelines require a combination of pipeline-level permissions and workspace-level access. Understanding these requirements ensures that the principle of least privilege is maintained while still allowing the engineering team to move code through the lifecycle stages without unnecessary friction.

Answer

The user must have a Power BI Free license and be a guest user in the tenant.

Answer

The Production workspace must be unassigned from the capacity before the deployment begins.

Answer

The user must have 'Viewer' access to the Production workspace and 'Admin' access to the Test workspace.

Question 11

Refer to the exhibit. You are reviewing a configuration for a maintenance task on a Delta table within a Microsoft Fabric Lakehouse. What is the primary benefit of ensuring the 'v_order' property is set to true during this operation?

Accepted Answer

It optimizes Parquet files for faster read performance by Fabric engines.. V-Order is a Microsoft-proprietary write-time optimization for the Parquet file format used in Fabric. By enabling V-Order, the data is sorted and compressed in a way that allows Fabric engines, such as the SQL analytics endpoint and Power BI, to perform exceptionally fast reads. This optimization is crucial for high-performance reporting and large-scale data scans.

Answer

It enables ACID transactions for concurrent users.

Answer

It implements Liquid Clustering for dynamic data layout.

Answer

It automatically evolves the schema when new columns are detected.

Question 12

You have a dataset with a highly skewed distribution in a join key. When performing a join in a Spark notebook, you observe performance degradation. Which technique should you use to handle this skew?

Accepted Answer

Salting. Data skew occurs when one key is over-represented, causing a single executor to handle significantly more work than others, leading to bottlenecks. To resolve this, you should perform 'salting'. By appending a random integer to the skewed key in both datasets before joining, you distribute the data more evenly across the cluster partitions. After the join, you remove the salted integer to restore the original key values and complete the operation.

Answer

Broadcast join

Answer

Increasing the number of executor cores

Answer

Reducing the number of partitions

Question 13

You are optimizing a Lakehouse for high-concurrency read operations from Power BI. You want to ensure that the Delta tables are in the best possible state for Direct Lake mode. Which THREE actions should you take during the 'Prepare Data' phase? (Select THREE)

Accepted Answer

Enable V-Order on all Delta tables during the write process.. Direct Lake mode in Power BI performs best when data is stored in the Delta Parquet format with optimizations that favor fast scanning. This includes ensuring V-Order is applied, compacting small files to reduce I/O overhead, and maintaining up-to-date statistics so the query optimizer can generate efficient execution plans for the reports.

Answer

Convert all Delta tables into the CSV format for better compatibility.

Answer

Ensure that the tables are partitioned on high-cardinality columns.

Question 14

You are optimizing a large Delta table in a Microsoft Fabric Lakehouse. Users report slow query performance due to a high volume of small files and unsorted data across frequently filtered columns. Which TWO actions should you perform? Each correct answer presents part of the solution.

Accepted Answer

Execute the OPTIMIZE table_name ZORDER BY (column_name) command in a Spark notebook.. Optimizing Delta tables involves compacting small files into larger optimal sizes using the OPTIMIZE command and physically clustering data on frequently filtered columns using Z-ORDER BY. Together, these commands drastically reduce file scanning overhead and improve query execution performance across analytical workloads.

Answer

Run the VACUUM table_name RETAIN 0 HOURS command to instantly purge all historical file versions.

Answer

Configure partitioning on every column that has high cardinality to maximize pruning efficiency.

Answer

Alter the table properties to increase the default checkpoint interval to every 500 commits.

Question 15

You are optimizing a Spark job in Fabric that processes large Parquet files. You notice high memory consumption and frequent spills to disk. Which TWO actions should you take to improve performance?

Accepted Answer

Increase the number of Spark partitions. Optimizing memory usage involves managing how data is partitioned and read. Increasing the number of partitions allows for better parallel processing, preventing individual executors from overloading. Additionally, choosing appropriate file formats or using predicate pushdown ensures that only necessary data is loaded into memory. These steps minimize memory pressure, reduce disk spilling, and significantly decrease total execution time for large-scale data transformation workflows in Spark.

Answer

Decrease the number of Spark partitions

Answer

Increase the executor memory size

Answer

Use the default Spark configuration without changes

Question 16

You are using Dataflow Gen2 to transform data. You have a requirement to perform a 'fuzzy merge' to join two tables with slightly inconsistent naming. Which transformation step should you apply?

Accepted Answer

A fuzzy merge transformation. Fuzzy merge is a powerful feature in Dataflow Gen2 that uses approximate matching algorithms to join datasets where keys are not exact matches, such as 'Microsoft' vs 'MSFT'. This is essential for cleansing dirty data from disparate sources. By applying this in the Dataflow, you automate the resolution of naming inconsistencies, ensuring high-quality master data without the need for manual, error-prone data entry or hardcoded mapping tables.

Answer

A standard inner join

Answer

A conditional column

Answer

A transpose transformation

Question 17

Refer to the exhibit. You are setting up a notebook in Fabric to ingest data. The source is provided in the exhibit. Which command should you use to load this data efficiently?

Accepted Answer

df = spark.read.option('header', 'true').csv('s3://raw-data'). The exhibit specifies a CSV source with GZIP compression. In Spark, the standard method for loading CSV files with specific parameters is using the 'spark.read.csv' function. Specifying options like 'header=True' and identifying the compression codec is vital for the spark engine to correctly decompress and parse the rows. Since the data is GZIP compressed, Spark automatically handles it, provided the format and options are correctly defined in the notebook session.

Answer

df = spark.read.json('s3://raw-data')

Answer

df = spark.read.parquet('s3://raw-data')

Answer

df = spark.read.text('s3://raw-data')

Question 18

You are monitoring a pipeline execution in Fabric. You notice that the 'Copy' activity is taking longer than expected. Which metric should you investigate to identify if the bottleneck is related to data movement throughput?

Accepted Answer

Data read and Data written metrics.. Investigating throughput metrics is crucial for identifying bottlenecks in data movement. The 'Data written' and 'Data read' metrics, combined with the duration, allow you to calculate the effective throughput. If the throughput is significantly lower than the network capacity or storage capability, it suggests issues like slow source response, network congestion, or excessive serialization/deserialization overhead during the copy process. Monitoring these allows you to tune parallelism settings to optimize the transfer performance.

Answer

CPU utilization on the driver node.

Answer

Memory usage of the Lakehouse.

Answer

Number of active users in the workspace.

Question 19

You are cleaning data using a Dataflow Gen2 in Microsoft Fabric. You need to optimize the performance of the transformation process. Which TWO actions should you perform? Each correct answer represents a complete solution.

Accepted Answer

Enable staging on intermediate queries. Optimizing Dataflow Gen2 performance involves minimizing the amount of data moved and shifting computation to the source or the engine level. By enabling query folding, the engine pushes transformations back to the source system, reducing memory usage in Fabric. Additionally, staging reduces the number of times data is read, allowing the engine to cache intermediate results efficiently for subsequent transformations, which significantly improves throughput during large-scale data cleansing operations.

Answer

Disable query folding for all steps

Answer

Increase the timeout settings for the data source

Answer

Convert all data types to Text before processing

Question 20

Refer to the exhibit. You are preparing a dataset in a Spark notebook. The operation fails with the provided error. What is the most likely cause?

Accepted Answer

The column name is misspelled or does not match the schema. The error indicates a column naming mismatch. The code references 'cust_id', but the actual schema contains 'customer_id' or 'cust_no'. In Spark, column names are case-sensitive or exact-match based on the schema defined in the Delta table. This is a common issue during data preparation when integrating data from disparate source systems that use non-standardized naming conventions, requiring a rename operation before proceeding.

Answer

The Delta table is missing

Answer

The Spark session has timed out

Answer

The data volume exceeds the cluster limit