DP-600 Maintain a Data Analytics Solution — 10 Questions

Question 1

Your team is adopting a Git-based workflow in Microsoft Fabric. You need to ensure that local changes made by developers in their individual workspaces do not overwrite the work of others when syncing to the shared Azure DevOps repository. Which strategy should you implement to maintain version control integrity?

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

Accepted Answer

Assign each developer a separate workspace connected to their own feature branch in Git.. In Microsoft Fabric, Git integration is workspace-bound. To prevent developers from overwriting each other's work, each developer should be assigned their own dedicated workspace connected to their specific feature branch in the shared Azure DevOps repository. This allows for isolated development and testing before merging changes into the main branch via pull requests.

Answer

Enable the 'Auto-commit' feature in the Fabric workspace settings for the main branch.

Answer

Grant all developers 'Admin' permissions on the production workspace to resolve sync conflicts.

Answer

Use a single shared workspace for all developers and perform manual exports of .pbip files.

Question 2

You need to automate the refresh of a Fabric semantic model using a logic app. You want to ensure the refresh only triggers after a specific Spark job in your Lakehouse completes successfully. Which Fabric REST API endpoint should you use to initiate the refresh?

Accepted Answer

POST https://api.fabric.microsoft.com/v1/workspaces/{id}/semanticModels/{id}/refreshes. The correct REST API endpoint for triggering a refresh on a Fabric semantic model is 'POST https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/semanticModels/{semanticModelId}/refreshes'. The provided option A is missing the specific path structure required by the Fabric REST API documentation, which uses 'items' or specific semantic model paths. Furthermore, the documentation specifies the endpoint as 'POST https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items/{itemId}/refreshes' or via the semantic model specific path.

Answer

GET https://api.fabric.microsoft.com/v1/workspaces/{id}/items/{id}/status

Answer

POST https://api.fabric.microsoft.com/v1/workspaces/{id}/lakehouses/{id}/tables/refresh

Answer

PATCH https://api.fabric.microsoft.com/v1/workspaces/{id}/semanticModels/{id}

Question 3

You have a semantic model with incremental refresh enabled. During a routine maintenance check, you notice that the data for the last three years is being reloaded every night, even though only the current month's data has changed. Which setting should you adjust to fix this?

Accepted Answer

Increase the 'Refresh period' to cover only the last 30 days of data.. In Power BI/Fabric, the settings are 'Archive data starting' (Store rows) and 'Refresh data starting' (Refresh rows). Option A refers to 'Refresh period', which is not the correct setting name. Furthermore, the explanation discusses 'Store rows' and 'Refresh rows' but the options use different terminology, creating a mismatch.

Answer

Decrease the 'Archive period' to cover only the last 30 days of data.

Answer

Enable the 'Only refresh complete days' toggle in the incremental refresh policy.

Answer

Change the 'Polling query' to return the maximum ID instead of a date timestamp.

Question 4

Refer to the exhibit. You are troubleshooting a failed automated deployment in a Microsoft Fabric environment. The deployment pipeline is triggered by a Service Principal via the REST API. Based on the error log, which maintenance action is required to resolve this issue?

Accepted Answer

Add the Service Principal to the target workspace with the 'Admin' or 'Member' role.. The explanation should explicitly state that Service Principals require workspace-level permissions (Admin or Member) to perform deployment operations via the Fabric REST API, as they do not inherit permissions from the tenant level.

Answer

Enable the 'Allow service principals to use Power BI APIs' setting in the tenant admin portal.

Answer

Generate a new client secret for the Service Principal as the current one has expired.

Answer

Assign the Service Principal the 'Contributor' role in the Azure subscription.

Question 5

You are the administrator of a Microsoft Fabric tenant. You want to simplify the maintenance of workspace settings by ensuring that all new workspaces automatically have a specific set of default configurations. What should you use?

Accepted Answer

Configure 'Tenant settings' in the Fabric Admin portal to apply global defaults.. Microsoft Fabric 'Tenant settings' in the Admin portal control governance, security, and feature availability (e.g., who can create workspaces, which regions are allowed), but they do not provide a mechanism to set 'default configurations' (such as specific workspace-level settings like default storage, specific workspace roles, or workspace-specific configurations) for new workspaces. There is currently no native 'workspace template' feature in Fabric to enforce default workspace-level settings upon creation.

Answer

Create a manual checklist for all users to follow when creating a new workspace.

Answer

Use the 'Workspace settings' menu in each individual workspace after creation.

Answer

Develop a custom Power App that replaces the standard Fabric workspace creation UI.

Question 6

You are responsible for maintaining the performance of a Microsoft Fabric capacity. You need to identify which items are causing 'Throttling' and 'Rejection' of queries. Which THREE metrics should you prioritize in the Microsoft Fabric Capacity Metrics app?

Accepted Answer

CU (Capacity Unit) consumption by item and operation type.. To identify throttling and rejection, you must monitor the 'Throttling' and 'Rejection' charts specifically provided in the Fabric Capacity Metrics app. Option A helps identify the source item, Option C explains why the capacity is in a state where it might throttle (overages/smoothing), and Option D directly addresses the rejection events. The explanation should explicitly mention these specific charts/metrics.

Answer

The total number of guest users invited to the Fabric tenant.

Answer

The storage size of all Delta tables across all Lakehouses in the capacity.

Question 7

Your organization uses Microsoft Fabric deployment pipelines to manage a semantic model across Development, Test, and Production workspaces. You need to ensure that the Production workspace uses a specific high-performance SQL connection string that differs from the Development environment. Which feature should you configure within the pipeline?

Accepted Answer

Deployment rules. Deployment rules in Microsoft Fabric deployment pipelines are limited to updating data source parameters and parameters defined in the semantic model (Power BI datasets). They cannot modify the underlying SQL connection string of a data source directly if it is not parameterized. The correct approach for environment-specific connection strings is to use Power BI parameters within the semantic model and then map those parameters using deployment rules.

Answer

Workspace permissions

Answer

Git integration settings

Answer

Sensitivity labels

Question 8

You are reviewing the Microsoft Fabric Capacity Metrics app and notice that several background operations are being delayed. You need to identify which specific items are consuming the most 'Base Capacity' to optimize the solution. Which view or tab in the app provides this specific breakdown?

Accepted Answer

The 'Compute' tab with the 'Items' table filtered by 'Total CU'.. In the Microsoft Fabric Capacity Metrics app, the 'Compute' tab displays a time-series chart of capacity usage. The breakdown of items consuming capacity is found in the 'Item' tab (or 'Items' view), which lists specific Fabric items and their respective CU (Capacity Unit) consumption metrics.

Answer

The 'Storage' tab sorted by 'Workspace Name'.

Answer

The 'Throttling' tab showing the 'Rejection' graph.

Answer

The 'Users' tab filtered by 'Active Sessions'.

Question 9

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 10

Refer to the exhibit. An analytics engineer runs this Dynamic Management View (DMV) query against a semantic model using the XMLA endpoint. For which maintenance task is this query most useful?

Accepted Answer

Identifying columns with low compression ratios to optimize memory usage.. Advanced maintenance of semantic models often requires looking into the internal storage engine (VertiPaq) to identify performance bottlenecks. DMVs provide deep insights into how data is compressed and stored in memory. By analyzing column chunks, engineers can identify which columns are consuming the most memory and require optimization through better data typing or reduced cardinality.

Answer

Verifying the last refresh time for individual tables in the model.

Answer

Monitoring active user sessions and their current DAX queries.

Answer

Checking for broken relationships between fact and dimension tables.