DP-600 Practice Test 3 — 10 Questions

Question 1

You need to automate the deployment of Fabric items across Development, Test, and Production environments. Which tool is the standard for managing these lifecycle stages?

Accepted Answer

Fabric Deployment Pipelines.. Deployment pipelines are the integrated tool within Fabric for managing the lifecycle of your analytics solution. By automating the promotion of content across different stages, you reduce manual errors and ensure that your production environment remains stable and consistent. This is a fundamental practice in professional data engineering, ensuring that updates are tested thoroughly before they affect the end users in the production environment.

Answer

Power BI Desktop export files.

Answer

Manual copy-paste of items in the workspace.

Answer

Azure Data Factory pipelines.

Question 2

You are designing a data ingestion strategy from an on-premises SQL Server to a Microsoft Fabric Lakehouse. You want to utilize the 'Fast Copy' feature in Dataflows Gen2 to maximize throughput. Which TWO conditions must be met to enable this capability? (Select TWO)

Accepted Answer

The 'Enable staging' option must be selected for the dataflow.. Fast Copy in Dataflows Gen2 allows for high-performance data movement by bypassing the standard Power Query engine for the actual data transfer. To trigger this, the data must not have complex transformations that require the Power Query engine, and staging must be enabled so the Data Factory orchestration engine can handle the movement efficiently.

Answer

The dataflow must use a Fabric Notebook as a destination.

Answer

A Premium Capacity (P1 or higher) must be assigned to the workspace.

Answer

The source SQL Server must have the 'V-Order' property enabled.

Question 3

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 4

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.

Question 5

You need to update a sensitivity label for a high-priority dataset in a Microsoft Fabric workspace. You want the new label to automatically apply to all reports and dashboards that use this dataset. Which feature should you ensure is enabled?

Accepted Answer

Lineage-based inheritance. Maintaining security at scale in Microsoft Fabric requires automated tools to ensure data protection policies are consistent. Downstream inheritance for sensitivity labels significantly reduces the administrative burden and the risk of human error. This feature ensures that if a dataset is classified as 'Highly Confidential', all derivative works inherit that same level of protection automatically.

Answer

Mandatory labeling policy

Answer

Workspace default labeling

Answer

Service Principal authentication

Question 6

You are auditing security in a Fabric workspace. You need to identify which two actions are required to ensure that a user can view a report without having access to the underlying Lakehouse files. Which two actions should you perform?

Accepted Answer

Assign the user the Viewer role in the workspace.. Restricting access requires a separation of concerns between the reporting layer and the data storage layer. By leveraging workspace roles and specific semantic model permissions, you enforce the principle of least privilege. This ensures that business users can consume data through Power BI visuals while the sensitive raw data files in OneLake remain protected from direct file-level access.

Answer

Grant the user the Contributor role in the workspace.

Answer

Grant the user access to the Lakehouse folder via OneLake.

Answer

Add the user to the workspace Admin role.

Question 7

Refer to the exhibit. An engineer receives this JSON response when checking the status of a Fabric workspace. What is the most appropriate next step to resolve the 'SyncingError' while ensuring that the workspace and the remote repository are aligned?

Accepted Answer

Use the Azure DevOps UI to create a Pull Request that merges the conflicting changes into the main branch.. This exhibit shows a common synchronization error where the Fabric workspace and the Git repository have diverged. To maintain a healthy analytics solution, the engineer must reconcile these differences. In this scenario, the 'SyncingError' indicates that the Fabric UI cannot resolve the path automatically. The engineer needs to use the Git provider's tools to perform a manual merge of the metadata files.

Answer

Disconnect the workspace from Git and then immediately reconnect it to force a hard reset of the metadata.

Answer

Increase the Fabric Capacity size to allow for more concurrent synchronization threads to handle the conflict.

Answer

Change the 'branch' value in the Git configuration to a new empty branch and then sync the workspace.

Question 8

You are optimizing a Lakehouse for performance. Which three actions help improve the query performance for users accessing the SQL endpoint?

Accepted Answer

Enable V-Order on the Delta tables.. Optimizing the SQL endpoint performance involves physical data design choices. By utilizing efficient file formats, partition strategies, and optimization tools, you reduce the workload on the query engine. These steps are crucial for ensuring that the SQL endpoint can handle high-concurrency analytical workloads, providing users with fast data access and a responsive reporting experience in the Fabric ecosystem.

Answer

Increase the number of small files in the table.

Answer

Convert all tables to CSV format.