DP-600 Maintain a Data Analytics Solution Practice Test 2 — 15 Questions

Question 1

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 2

Your organization uses a Fabric workspace for sensitive financial reporting. You need to implement Row-Level Security (RLS) to ensure that regional managers only see data from their own regions. Where should you define this security logic?

Accepted Answer

Define the RLS in the Power BI semantic model.. Defining RLS within the semantic model is the industry standard for ensuring consistency across all reports that connect to that model. By centralizing security logic, you ensure that no matter which report or dashboard a user accesses, the data filtering is applied uniformly. This provides a robust security layer that is easy to audit and manage, preventing accidental exposure of sensitive financial information.

Answer

Define the RLS in each individual Power BI report.

Answer

Define the RLS in the workspace security settings.

Answer

Define the RLS at the SQL endpoint of the Lakehouse.

Question 3

You are managing a Fabric solution and need to move a workspace between capacities to optimize costs. What is the impact of this operation on your existing DirectLake reports?

Accepted Answer

The reports may experience performance degradation if the new capacity is smaller.. When a workspace is moved between Fabric capacities, DirectLake reports remain in DirectLake mode. However, if the new capacity is smaller or has different SKU-based limits (such as memory or compute units), the report performance may be impacted due to resource contention or throttling. The reports do not switch to Import mode, nor are they deleted.

Answer

The reports will automatically switch to Import mode.

Answer

The operation is seamless and has no impact on report performance.

Answer

The reports will be deleted and must be recreated.

Question 4

You are managing a Fabric solution and need to identify if a specific notebook is consuming excessive memory. Which Fabric tool should you use?

Accepted Answer

The Fabric Capacity Metrics app.. Monitoring tools like the Fabric capacity metrics app are essential for identifying which items are consuming excessive resources. By tracking the memory and CPU usage of notebooks, you can proactively address bottlenecks. This is crucial for maintaining the performance of the entire workspace, as resource-heavy notebooks can interfere with the performance of other concurrent processes and reports within the same capacity.

Answer

The Power BI 'Performance Analyzer'.

Answer

The Azure Monitor Log Analytics.

Answer

The 'Manage Gateways' interface.

Question 5

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 6

You need to update a column data type in a Fabric Lakehouse table without losing existing data. What is the most reliable way to achieve this?

Accepted Answer

Drop the table and re-create it with the new schema.. Delta Lake does not support changing the data type of an existing column via ALTER TABLE. The standard, reliable way to change a data type in a Delta table is to read the data into a DataFrame, cast the column to the desired type, and overwrite the table using 'overwrite' mode.

Answer

Use Spark SQL 'ALTER TABLE' to change the data type.

Answer

Rename the column via the workspace UI.

Answer

Overwrite the table using a standard CSV file.

Question 7

A data engineer is working in a Microsoft Fabric workspace integrated with an Azure DevOps Git repository. After making several changes to a semantic model, the engineer attempts to commit the changes, but a conflict is detected because another team member modified the same model. What is the recommended workflow to resolve this conflict and maintain the integrity of the workspace?

Accepted Answer

Resolve the conflict in the Azure DevOps repository by performing a merge or rebase, then update the Fabric workspace.. Git integration in Microsoft Fabric allows multiple developers to work on the same workspace items concurrently. When conflicts occur because two developers modified the same report metadata, the Fabric service requires manual intervention via the Git provider. This ensures version control integrity and prevents accidental overwrites of complex JSON definitions, which is critical for maintaining a stable production environment in collaborative engineering teams.

Answer

Delete the local workspace item and pull the latest version from the Git repository to overwrite your local changes.

Answer

Select the 'Auto-Merge' button in the Fabric Source Control pane to allow the service to reconcile the JSON differences.

Answer

Create a new workspace, connect it to the same branch, and manually copy the changes from the old workspace to the new one.

Question 8

Your organization uses Microsoft Fabric deployment pipelines to move content from Development to Production. The Development Lakehouse connects to a test SQL Server, but the Production Lakehouse must connect to a production SQL Server. How should you ensure the connection string updates automatically during deployment?

Accepted Answer

Configure a deployment rule for the data source in the pipeline settings for the Production stage.. In Microsoft Fabric, deployment rules are primarily supported for Power BI datasets (parameters and data sources). Lakehouses and their underlying SQL endpoints do not support deployment rules for connection strings. The correct approach for managing environment-specific data sources in Fabric is typically through the use of environment-specific shortcuts or by using Fabric parameters/environment variables if applicable, but deployment rules as defined in the pipeline UI do not apply to Lakehouse connection strings.

Answer

Manually edit the Lakehouse connection settings in the Production workspace after every deployment from the pipeline.

Answer

Use a Git branch for Production that contains a different version of the Lakehouse metadata with the correct connection string.

Answer

Create a Power Automate flow that triggers on deployment to update the Lakehouse settings via the Fabric REST API.

Question 9

A Microsoft Fabric administrator is using the Microsoft Fabric Capacity Metrics app to investigate performance issues. Which TWO metrics should they prioritize to identify if the capacity is currently experiencing throttling or rejection of requests? (Select TWO)

Accepted Answer

Background Rejection. Capacity metrics are vital for monitoring the health of a Fabric environment and ensuring that workloads do not exceed provisioned limits. Monitoring 'Background Rejection' and 'Interactive Rejection' events helps identify when the capacity is over-utilized. Understanding these metrics allows engineers to scale resources appropriately or optimize inefficient queries to maintain a high level of service for all users.

Answer

Total Workspace Count

Answer

Average User Tenure

Answer

Sensitivity Label Count

Question 10

An Analytics Engineer notices that a Spark notebook in a Fabric Lakehouse is running significantly slower than usual. After reviewing the Spark UI, the engineer sees that one executor is processing 90% of the data while others are idle. What is the most likely cause of this performance issue?

Accepted Answer

The input data has a significant skew in the join or partition key, leading to unbalanced partitions.. In distributed computing environments like Spark within Fabric, performance is often dictated by how evenly data is distributed across the cluster. When one executor handles the vast majority of the work, it is known as data skew. Identifying and resolving data skew is a critical maintenance task for data engineers to ensure cost-effective and timely data processing within the Lakehouse.

Answer

The Spark notebook is using a 'Small' pool instead of a 'Large' pool for the executor nodes.

Answer

The 'V-order' optimization has not been applied to the underlying Parquet files in the Lakehouse.

Answer

The engineer is using a 'Collect' statement which pulls all data to the driver node instead of the executors.

Question 11

A data engineer wants to optimize the storage and read performance of Delta tables in a Microsoft Fabric Lakehouse. Which built-in Fabric feature should be enabled to ensure that Parquet files are written using a proprietary sorting and compression algorithm for faster Power BI engine access?

Accepted Answer

V-order. Microsoft Fabric introduces V-order as a write-time optimization for Parquet files. This is specifically designed to maximize the performance of the Power BI engine when accessing data via Direct Lake mode or the SQL endpoint. Maintaining optimized storage is a key responsibility for an analytics engineer to ensure that the solution remains performant as data volumes grow.

Answer

Z-Order

Answer

Auto-Optimize

Answer

Gzip Compression

Question 12

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 13

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 14

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 15

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.