DP-600 Exam Simulation — 100 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 managing a Microsoft Fabric workspace integrated with Azure DevOps. You have several developers working on the same Lakehouse and Semantic Model. Which TWO actions are required to successfully resolve a merge conflict when synchronizing changes from the remote repository to the workspace?

Accepted Answer

Resolve the conflict in the Azure DevOps repository or a local Git client.. Git integration in Microsoft Fabric necessitates a clear strategy for handling conflicts that arise when multiple developers modify the same items. When the workspace and the remote branch diverge, the system cannot automatically reconcile the differences. Engineers must use external tools and specific Fabric sync commands to ensure the workspace reflects the desired state without losing critical work.

Answer

Delete the conflicting items from the workspace and re-import them.

Answer

Use the 'Undo changes' command in the Source Control side pane.

Answer

Change the workspace connection to a new empty branch.

Question 13

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 14

You plan to change the data type of a column in a gold-layer Lakehouse table. You need to use the 'Impact Analysis' feature to identify the potential consequences. Which THREE types of downstream items will be identified by this feature?

Accepted Answer

Semantic models. Impact Analysis is a critical governance tool for maintaining data integrity across a Fabric tenant. It allows engineers to see how changes to a data source propagate through the environment. By identifying affected items before making changes, you can proactively notify stakeholders and update dependent logic, preventing broken reports and ensuring a reliable user experience.

Answer

Data Pipelines

Answer

Gateway connections

Question 15

You plan to rename a column in a gold-layer table within a Fabric Lakehouse. Which THREE actions should you perform to assess and mitigate the impact on the existing analytics solution? (Select THREE)

Accepted Answer

Open the Lineage view to identify downstream semantic models and reports that use the table.. Impact analysis and lineage views are critical for maintaining data integrity when underlying schemas change. Before modifying a column name in a Lakehouse table, an engineer should use these tools to identify downstream dependencies. This proactive approach prevents broken reports, failed data pipelines, and ensures that all stakeholders are notified of upcoming breaking changes in the data architecture.

Answer

Delete the Lakehouse and recreate it with the new schema to ensure all metadata is refreshed.

Answer

Change the workspace name to include 'DEPRECATED' until the column rename is completed.

Question 16

You are maintaining a Fabric workspace and need to grant a colleague the ability to commit changes to the Git repository but prevent them from deleting the workspace itself. Which workspace role should you assign?

Accepted Answer

Contributor. Role-based access control (RBAC) is fundamental to maintaining a secure and functional Fabric environment. Each role provides a different level of authority. For developers who need to interact with Git integration, the role must allow for item modification and synchronization while adhering to the principle of least privilege to protect the workspace infrastructure.

Answer

Viewer

Answer

Admin

Answer

Member

Question 17

Refer to the exhibit. You are reviewing an organization's Fabric security policy. Based on the provided JSON snippet, what is the impact of this policy on your data analytics solution?

Accepted Answer

The policy prevents users from exporting data from all reports within the workspace.. This policy implements a governance guardrail that prevents users from exporting data out of the Fabric workspace. In an enterprise environment, this is crucial for maintaining compliance and preventing data exfiltration. By controlling the export action at the workspace level, you ensure that sensitive insights remain contained within the secure Microsoft Fabric boundary, regardless of user permissions.

Answer

Users can export data from individual reports if they have Owner permissions.

Answer

The policy allows exporting if the data is anonymized.

Answer

The policy only affects users with the Guest role.

Question 18

Refer to the exhibit. A notebook in your Fabric workspace is failing with the provided error. What is the most likely cause?

Accepted Answer

The notebook identity lacks read access to the OneLake item.. The '403 Forbidden' error indicates that the service principal or user identity running the notebook does not have authorization to perform read operations on the specific OneLake path. This is a common permission management issue in Fabric. Ensuring the correct identity has the 'Reader' or higher role on the workspace/item is vital for successful data integration and processing tasks within your notebooks.

Answer

The file does not exist in the specified path.

Answer

The capacity SKU is out of memory.

Answer

The notebook syntax is incorrect.

Question 19

You manage a Microsoft Fabric workspace containing a Lakehouse and several semantic models. You need to implement a data lineage solution that traces data transformations from the original source files ingested into the OneLake landing zone down to the Power BI reports consumed by business users. Which Fabric feature should you use to achieve this requirement natively?

Accepted Answer

Open the workspace lineage view to inspect visual relationships and downstream dependencies across all connected items automatically.. Microsoft Fabric provides built-in lineage views that automatically trace dependencies and relationships between data sources, OneLake artifacts, notebooks, and Power BI semantic models. This native integration eliminates the need for external tools and ensures governance and impact analysis can be performed seamlessly across the entire analytical lifecycle, which is vital when debugging broken pipelines or planning structural workspace modifications.

Answer

Configure Azure Monitor workbook alerts to capture and map incoming data streaming events from OneLake to downstream reports.

Answer

Deploy custom Python scripts inside a Fabric notebook to extract workspace metadata using REST APIs and store relationships in an external SQL database.

Answer

Export Power BI Desktop template files (.pbit) and analyze the data source connection strings using XMLA endpoints.

Question 20

You need to monitor the performance of your Fabric SQL endpoint. Which two metrics should you track to ensure long-running queries are identified and optimized?

Accepted Answer

Total query execution time.. Monitoring query duration and resource consumption is essential for maintaining a healthy Fabric environment. By identifying long-running queries, you can pinpoint inefficient T-SQL code or missing indexes. Tracking these metrics enables proactive performance tuning, ensuring that the SQL endpoint remains responsive to users while keeping resource consumption within the allocated capacity limits for the workspace.

Answer

The number of users logged into the workspace.

Answer

The number of files in the OneLake delta table.

Answer

The number of dashboards generated.