DP-600 Practice Questions

Question 1

You need to perform a 'Lineage View' audit in Microsoft Fabric. Which TWO types of information are specifically provided by the Lineage View to help you maintain the solution?

Accepted Answer

The source-to-destination path of data across different workspaces.. Lineage View is an essential maintenance tool for understanding the complexity and health of a data solution. It provides a map of how data flows through the system, which is vital for troubleshooting and change management. By visualizing these paths, engineers can identify bottlenecks, redundant processes, and the potential impact of modifications to upstream sources.

Answer

The DAX query plan for the most expensive visuals in a report.

Answer

A list of individual users who have viewed a specific report in the last 30 days.

Answer

The physical storage location of the Delta files in OneLake.

Question 2

You are using the Microsoft Fabric deployment pipeline. You have successfully deployed a semantic model from Development to Test. You now realize that you need to change the 'Data Source' rule for the Test stage. What will happen to the existing items in the Test stage if you update the rule?

Accepted Answer

The new rule will only apply the next time you deploy from Development to Test.. Understanding how deployment rules behave is critical for maintaining consistent environments. Rules are applied during the deployment process, not retroactively. Knowing when and how rules take effect helps engineers avoid situations where the environment is in an inconsistent state or where manual intervention is required to fix a botched deployment.

Answer

The items in the Test stage will be updated immediately to reflect the new rule.

Answer

The deployment will fail because rules cannot be changed once an item is deployed.

Answer

The rule change will automatically trigger a refresh of the Semantic Model in Test.

Question 3

You are configuring a deployment pipeline in Microsoft Fabric to manage the lifecycle of a Lakehouse and several related reports. Which TWO actions can you perform using deployment pipelines to ensure consistency across environments?

Accepted Answer

Apply deployment rules to change the data source connection of a semantic model.. Deployment pipelines in Microsoft Fabric are designed to automate the movement of items between development, test, and production stages. They ensure that configurations are applied consistently and reduce the risk of manual errors. This automation is a cornerstone of maintaining a reliable data analytics solution, allowing for rapid iteration while preserving the stability of the production environment.

Answer

Automatically convert a Power BI report into a Paginated report during the deployment.

Answer

Restore a deleted workspace by reverting to a previous pipeline deployment stage.

Answer

Encrypt individual columns in a Lakehouse table using a custom key during the sync.

Question 4

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?

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 5

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 6

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 7

Refer to the exhibit. You are reviewing the Git configuration for a Microsoft Fabric workspace. A developer reports that they cannot see their latest changes in the 'dev' branch within the workspace. Based on the exhibit, what is the most likely cause of this issue?

Accepted Answer

The developer has committed changes to the repository but the workspace has not been updated.. When a workspace is synced with Git, the 'syncStatus' indicates the connection health, but the workspace must still be manually updated or 'pulled' to reflect changes made in the remote repository. Maintenance of a synced environment requires understanding that the 'Synced' status confirms the link is active, but individual items must be updated to match the branch's latest commit.

Answer

The workspace is connected to a repository that does not exist in the ContosoCorp organization.

Answer

The 'directoryName' in the JSON configuration is incorrect and should be the root directory.

Answer

The workspace is currently in a 'Read-only' state because it is connected to a Git branch.

Question 8

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 9

You have a Fabric workspace with multiple reports. You need to ensure that the dataset is shared across reports without creating multiple copies. What is the correct approach?

Accepted Answer

Connect new reports to the existing published semantic model.. Using a 'Thin Report' architecture is the best practice for maintaining a single version of the truth. By publishing a single semantic model and connecting multiple reports to it, you simplify maintenance and improve performance. This prevents data duplication and ensures that all users are consuming consistent, synchronized metrics, which is crucial for organizational trust in the analytical solution.

Answer

Copy the PBIX file and publish it multiple times.

Answer

Use the 'Import' mode for every report created.

Answer

Embed each report in a separate workspace.

Question 10

Your organization is scaling its Microsoft Fabric implementation. You need to establish a maintenance plan for workspace administration. Which TWO practices should you implement to manage workspace security and lifecycle effectively?

Accepted Answer

Use Microsoft Entra ID (formerly Azure AD) groups for workspace role assignments.. Effective workspace maintenance involves balancing developer productivity with security and governance. Using security groups rather than individual users simplifies access management and reduces the risk of orphaned permissions. Implementing a clear workspace naming and ownership policy ensures that the environment remains organized and that responsibility for each asset is clearly defined as the organization grows.

Answer

Assign individual user permissions to each item within the workspace for granular control.

Answer

Create a separate capacity for every workspace to isolate resource consumption.

Answer

Disable the 'Tenant settings' for all users except for one global administrator.

Question 11

You are maintaining a data analytics solution that requires Row-Level Security (RLS) on a semantic model. You need to ensure that the RLS rules continue to function correctly even when the model is switched to Direct Lake mode. What is a key requirement for maintaining RLS in this scenario?

Accepted Answer

The RLS roles must be defined in the semantic model using DAX filter expressions.. Maintaining security in Direct Lake mode requires careful consideration of how RLS is applied. Because Direct Lake bypasses the SQL endpoint and reads Parquet files directly, RLS must be defined within the semantic model itself. Understanding these requirements ensures that sensitive data remains protected regardless of the storage mode or the performance optimizations being applied to the data solution.

Answer

RLS must be configured at the Lakehouse level using SQL Views instead of in the model.

Answer

Single Sign-On (SSO) must be disabled for the Lakehouse connection to support RLS.

Answer

The semantic model must be moved to a Pro capacity to support Direct Lake RLS.

Question 12

You are monitoring a semantic model in Microsoft Fabric that is experiencing performance degradation. You suspect that the storage engine is struggling with high-cardinality columns during Direct Lake queries. Which Dynamic Management View (DMV) should you query to identify the memory usage of specific columns in the model?

Accepted Answer

SELECT * FROM $System.DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS. Dynamic Management Views are critical tools for maintaining and optimizing semantic models in Microsoft Fabric. By querying the DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS DMV, an engineer can pinpoint exactly which columns are consuming the most memory and identifying candidates for optimization. This level of granular monitoring is vital for maintaining the performance of Direct Lake models as data volumes grow.

Answer

SELECT * FROM $System.DISCOVER_SESSION_STATISTICS

Answer

SELECT * FROM $System.MDSCHEMA_MEASURES

Answer

SELECT * FROM $System.DISCOVER_CALC_DEPENDENCY

Question 13

You need to perform maintenance on a shared Lakehouse in Microsoft Fabric. Before making schema changes, you want to identify which downstream reports and semantic models will be affected. Which tool should you use?

Accepted Answer

The Lineage view in the workspace to perform an impact analysis on the Lakehouse.. Lineage view and impact analysis are essential for maintaining data integrity in a complex Fabric ecosystem. They provide a visual map of dependencies, allowing engineers to understand the consequences of their changes. This proactive approach prevents breaking downstream assets and helps in communicating maintenance windows to the appropriate stakeholders who rely on the affected data.

Answer

The Capacity Metrics app to check for active user sessions on the Lakehouse.

Answer

The SQL analytics endpoint to query the system metadata tables for dependencies.

Answer

The 'Monitor' hub to view the history of data refresh operations for all items.

Microsoft Fabric Analytics Engineer Associate DP-600 practice test

Three ways to study

Study DP-600 by domain

Study DP-600 by topic

Maintain a Data Analytics Solution practice questions

Prepare Data practice questions

Implement and Manage Semantic Models practice questions

DP-600 fundamentals practice questions

DP-600 scenario practice questions

DP-600 troubleshooting practice questions

Microsoft Fabric Analytics Engineer Associate practice questions