DP-600 Maintain a Data Analytics Solution — Timed 20 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?

20 minute time limit — choose an answer to begin.

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

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.. Without the exhibit showing the specific DMV (e.g., DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS), it is impossible to verify if the query targets compression ratios or another metric. Assuming the query is indeed related to column segments, the explanation is correct, but the question cannot be validated without the visual reference.

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.

Question 10

You are using the Microsoft Fabric REST API to automate the deployment of a workspace. You need to ensure that the deployment process waits for a long-running operation, such as a large model deployment, to complete before starting the next step. What is the standard way to handle this in the API?

Accepted Answer

Implement a loop that polls the status URL provided in the response headers.. Microsoft Fabric REST APIs for long-running operations return a 202 Accepted status code along with an 'Operation-Location' header. The client must poll this specific URL to retrieve the status of the operation until it reaches a terminal state (Succeeded, Failed, or Canceled).

Answer

Set the 'Sync-Mode' parameter to 'True' in the initial POST request body.

Answer

Increase the timeout value of the HTTP client to 3600 seconds.

Answer

Use a 'Wait' command with a fixed duration of 10 minutes between API calls.

Question 11

You are configuring Git integration for a Microsoft Fabric workspace. Which TWO item types are currently supported for synchronization between the workspace and the Git repository?

Accepted Answer

Semantic models (excluding Live Connect). In Microsoft Fabric, Git integration supports core items including Lakehouses, Warehouses, Notebooks, Dataflows Gen2, Data Pipelines, and Semantic models (excluding Live Connect). Power BI reports are typically bundled or handled differently, making Data Pipelines a correct supported item type rather than Power BI Reports.

Answer

Power BI Reports

Answer

Reflex (Data Activator) items

Answer

Storage Accounts (External)

Question 12

A user reports that a Power BI report in a production workspace is showing stale data, even though the scheduled refresh for the underlying Semantic Model was successful. You discover the model uses a Lakehouse as a source via a SQL Endpoint. What is the most likely cause?

Accepted Answer

The Semantic Model is configured for 'Live Connect' instead of 'Import' mode.. In Microsoft Fabric, the SQL Endpoint is a read-only view of the Lakehouse data. It does not require a separate 'metadata synchronization' process for the data to be visible to a Semantic Model; the SQL Endpoint is always in sync with the underlying Delta tables. The most likely cause for stale data in this scenario is that the Semantic Model is using 'DirectQuery' mode (or a hybrid approach) and the user is experiencing caching behavior, or the underlying data in the Lakehouse was updated but the Semantic Model refresh did not trigger a cache invalidation for the specific query.

Answer

The SQL Endpoint metadata has not finished synchronizing with the OneLake Delta tables.

Answer

The user does not have the 'Viewer' role on the production workspace.

Answer

The capacity is currently throttled due to high background activity.

Question 13

You are troubleshooting a failure in a Microsoft Fabric Data Factory pipeline. The error log indicates a 'Timeout' occurred during a 'Copy Data' activity from an on-premises SQL Server. Which maintenance action is most likely to resolve the issue?

Accepted Answer

Check the On-premises Data Gateway logs for 'System Load' or 'Concurrency' issues.. Maintaining hybrid data solutions involves managing the connection between cloud and on-premises environments. Timeouts during data movement often point to issues with the On-premises Data Gateway or the network path. Effective troubleshooting requires checking the health of the gateway and the resources of the source system to ensure they can handle the requested load.

Answer

Increase the 'Max Parallelism' setting in the Fabric workspace properties.

Answer

Convert the SQL Server table to a Delta table before the copy activity.

Answer

Switch the authentication method from 'Basic' to 'OAuth2'.

Question 14

You are managing a Microsoft Fabric workspace. You notice that a specific Power BI report is failing to refresh due to a performance bottleneck in the underlying DirectLake semantic model. Which action should you take to optimize the query execution without changing the data source?

Accepted Answer

Remove unused columns from the semantic model schema.. DirectLake mode does not 'refresh' data in the traditional sense; it reads data directly from OneLake Parquet files. The performance bottleneck in DirectLake is typically related to memory pressure or inefficient DAX queries scanning too many columns. Removing unused columns reduces the memory footprint and improves scan performance, which is the correct optimization strategy for DirectLake.

Answer

Switch the storage mode to Import for all tables.

Answer

Enable Query Caching in the semantic model settings.

Answer

Increase the workspace capacity SKU level.

Question 15

You are troubleshooting a scheduled refresh failure for a Dataflow Gen2 in Microsoft Fabric. The error log indicates that the destination lakehouse is inaccessible. What is the most likely cause?

Accepted Answer

The dataflow identity lacks the necessary permissions to write to the Lakehouse.. Dataflow Gen2 in Microsoft Fabric uses the workspace identity or the user's credentials to write to a destination Lakehouse. If the destination is inaccessible, the most common cause is that the Dataflow's identity (or the service principal/user configured for the connection) lacks the 'Contributor' or 'Member' role on the workspace containing the Lakehouse, or specific write permissions on the Lakehouse item itself.

Answer

The dataflow is missing the required compute capacity.

Answer

The gateway connection string is incorrectly formatted.

Answer

The source data is too large for the dataflow to process.

Question 16

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 17

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 18

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 19

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 20

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.