Courseiva

DP-600 · domain

Maintain a Data Analytics Solution

This domain covers maintaining a Fabric analytics solution: monitoring and tuning pipelines, Lakehouses, and SQL endpoints; managing workspace security and lifecycle; and using Git integration for version control. Questions present operational scenarios—capacity errors, small-file performance, accidental commits—and ask you to select the correct remediation or maintenance practice.

76 questions13 easy40 medium23 hard

Focused practice

Practice Maintain a Data Analytics Solution questions

Scored sessions drawing only from this domain — pick a length below.

Start 20-question practice test →

What this domain covers

What to know about Maintain a Data Analytics Solution

You must be able to monitor and remediate Fabric pipeline capacity issues, compact small Parquet files for SQL endpoint performance, and revert workspace changes using Git integration. The single most important thing: always diagnose the root cause—capacity, file layout, or version control—before applying a fix.

Diagnosing Fabric pipeline failures caused by capacity limits and applying throttling or capacity scaling.

Optimizing Lakehouse SQL endpoint performance by compacting small Parquet files with OPTIMIZE or VACUUM.

Reverting workspace changes via Git integration with Azure DevOps, including branch and commit rollback.

Implementing workspace security and lifecycle practices: role assignments, access reviews, and workspace retention.

Watch out for

Common Maintain a Data Analytics Solution exam traps

  • ▸Assuming capacity errors require code changes instead of checking Fabric capacity metrics and throttling settings.
  • ▸Ignoring small-file accumulation and expecting SQL endpoint tuning without running OPTIMIZE or VACUUM on Delta tables.
  • ▸Reverting a bad semantic model by editing it directly instead of using Git history to restore the prior commit.

Question index

All Maintain a Data Analytics Solution questions (76)

Click any question to see the full explanation, or start a practice session above.

1

You are maintaining a Microsoft Fabric workspace that contains a semantic model. The model is used by several reports. You need to ensure that when a new measure is added to the model, it is automatically available in all reports without manual updates. What should you do?

Easy
2

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)

Hard
3

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?

Medium
4

You are maintaining a Microsoft Fabric capacity that hosts multiple workspaces. Users report intermittent slow performance and occasional query failures during peak hours. You suspect that a specific workspace is consuming excessive capacity. You need to identify which items are consuming the most capacity units and when. What should you do?

Hard
5

You are maintaining a Microsoft Fabric workspace that uses deployment pipelines to promote items from Development to Test to Production. You need to ensure that the deployment process does not overwrite certain item properties that must differ per stage, such as data source connections and parameters. Which two actions should you take? (Choose two.)

Medium
6

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?

Hard
7

You are responsible for maintaining a Microsoft Fabric deployment pipeline that promotes items from Development to Test to Production. You need to ensure that the deployment process does not overwrite certain configurations in the target stages. Which two actions should you perform? (Choose two.)

Medium
8

You are a Fabric analytics engineer. Your team uses a deployment pipeline to promote content from a development workspace to a test workspace. After a recent deployment, users in the test workspace report that they cannot see the latest changes to a report. You need to troubleshoot the deployment pipeline. Which action should you take first?

Medium
9

You maintain a Microsoft Fabric workspace that contains a Dataflow Gen2 named SalesDF. The dataflow refreshes daily from an on-premises SQL Server via a VNet data gateway. External users report that the dataflow has been failing for the past three days with an authentication error. You need to ensure the dataflow refreshes successfully without embedding credentials in the dataflow. What should you do?

Medium
10

You manage a Microsoft Fabric workspace that contains a Lakehouse and a semantic model. The semantic model is refreshed daily from the Lakehouse. A user reports that the semantic model refresh failed last night with an error indicating that a column was not found. You need to resolve the refresh failure with minimal disruption. What should you do first?

Easy
11

You are managing a Microsoft Fabric workspace that uses Git integration with Azure DevOps. You need to ensure that developers can collaborate on a Lakehouse and a semantic model without overwriting each other's changes. You must also ensure that changes can be reviewed before being merged into the main branch. Which two actions should you perform? (Choose two.)

Medium
12

You are a Fabric analytics engineer managing a workspace that contains a Lakehouse and a warehouse. A new compliance policy requires that users cannot query data from the warehouse using T-SQL if they are not members of a specific Microsoft Entra ID security group. You need to enforce this restriction without affecting access to the Lakehouse. What should you do?

Medium
13

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?

Medium
14

You manage a Microsoft Fabric workspace that contains a Dataflow Gen2 which ingests data from an on-premises SQL Server using a data gateway. The dataflow has been running successfully for months, but after a network change, it now fails with a gateway connectivity error. You need to resolve the issue with minimal administrative effort. What should you do first?

Medium
15

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?

Hard
16

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?

Medium
17

You are a Fabric administrator for a workspace that contains a Lakehouse and a Warehouse. You need to grant a new team member the ability to read data from all items in the workspace but prevent them from modifying any data or workspace settings. What should you do?

Easy
18

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?

Medium
19

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?

Medium
20

You are maintaining a Microsoft Fabric workspace that contains a Lakehouse and a semantic model. You need to ensure that when new data is added to the Lakehouse, the semantic model automatically reflects the changes without manual intervention. What should you configure?

Easy
21

You are a Fabric administrator for a workspace that contains a semantic model used by many reports. You need to ensure that when a user opens a report, they only see data they are authorized to view, based on their department. The semantic model already has a role named 'Department' with a DAX filter on the Department column. What should you do next?

Easy
22

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?

Medium
23

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?

Easy
24

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

Medium
25

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?

Medium
26

You are managing a Microsoft Fabric workspace that contains a Lakehouse with sensitive data. Your organization requires that data access be audited and that users can only see data relevant to their region. You have implemented row-level security (RLS) in a semantic model. However, you discover that users can still access the underlying Lakehouse tables directly via the OneLake explorer. What should you do to enforce data security at the storage level?

Hard
27

You are maintaining a Microsoft Fabric workspace that contains a Data Warehouse. You need to ensure that users can only see data relevant to their region, based on their Azure Active Directory group membership. The Data Warehouse contains a table named Sales with a column Region. You want to implement row-level security (RLS) at the Data Warehouse level. What should you do?

Easy
28

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?

Hard
29

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'?

Hard
30

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?

Hard
31

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?

Medium
32

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?

Medium
33

You are a Fabric analytics engineer at a retail company. A data pipeline in your Fabric workspace loads sales data daily into a Lakehouse. Recently, the pipeline started failing intermittently with a 'Capacity limit exceeded' error. You need to ensure the pipeline runs reliably without manual intervention. What should you do first?

Medium
34

You are monitoring a Microsoft Fabric capacity and notice that certain operations are being throttled during peak hours. You need to identify which workloads are consuming the most capacity units (CUs) to optimize their usage. What should you use?

Easy
35

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?

Medium
36

You are a Fabric administrator for a workspace that uses a deployment pipeline to promote content from Development to Test to Production. You need to ensure that the deployment process follows best practices for data and security. Which two actions should you perform? (Choose two.)

Hard
37

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?

Medium
38

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?

Medium
39

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?

Hard
40

You are a Fabric administrator for a workspace that contains a Lakehouse, a Warehouse, and several semantic models. A developer reports that a scheduled refresh of a semantic model failed with a 'credentials expired' error. You need to resolve this issue with the least administrative effort. What should you do?

Medium
41

You are optimizing a Fabric Lakehouse that contains a large Delta table named FactSales, which is partitioned by Year and Month. Users frequently run queries that filter on Year and Month, but also on a column named Region. You notice that queries filtering on Region alone perform poorly because they scan all partitions. You need to improve performance for Region-based queries without duplicating data. What should you do?

Hard
42

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?

Medium
43

You are managing a Microsoft Fabric capacity that hosts multiple workspaces. A critical Power BI report in one workspace is experiencing performance degradation during peak hours. You suspect that another workspace's Spark job is consuming excessive capacity resources. You need to identify which item is causing the high resource usage and when it occurs. What should you use?

Hard
44

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?

Medium
45

You are the administrator of a Microsoft Fabric workspace that contains a Lakehouse, a Warehouse, and several semantic models. A new data engineer joins the team and needs to be able to create and modify items in the workspace but must not be able to grant permissions to other users or delete the workspace. Which workspace role should you assign?

Medium
46

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?

Hard
47

You are maintaining a Microsoft Fabric workspace that contains a Lakehouse with many Delta tables. You need to optimize the storage and query performance of these tables. You notice that many small files are being created due to frequent incremental loads. Which action should you take to improve performance?

Medium
48

You maintain a Fabric capacity that hosts a real-time streaming workload and several Power BI semantic models. Users report intermittent report timeouts during peak hours, while the streaming workload continues without errors. You need to identify whether the semantic models are being throttled due to capacity limits. Which tool should you use?

Hard
49

You are setting up a new Fabric workspace that will contain sensitive financial data. You need to ensure that only specific users can view the data in reports, and that row-level security (RLS) is enforced for all consumers. What should you configure?

Easy
50

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

Hard
51

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?

Medium
52

You are maintaining a Microsoft Fabric capacity that hosts several semantic models with Direct Lake mode. Users report intermittent query failures and slow performance during peak hours. You observe that the capacity is frequently throttled. You need to identify the cause and implement a solution that minimizes impact on critical reports. What should you do?

Hard
53

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?

Medium
54

You manage a Fabric workspace with a lakehouse that stores Delta tables. A data engineer accidentally deletes a folder containing several Parquet files from the lakehouse. You need to recover the deleted files as quickly as possible. What should you do?

Medium
55

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?

Hard
56

You have a Microsoft Fabric workspace with a Lakehouse that contains a Delta table. You need to ensure that when new data is appended, the table's metadata is automatically updated and the changes are immediately visible to queries without manual intervention. What should you do?

Medium
57

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?

Hard
58

You are monitoring a Microsoft Fabric capacity. You notice that during peak hours, the capacity is frequently throttled, causing delays in report rendering and data refreshes. You need to identify which workloads are consuming the most capacity units (CUs) and optimize them. Which tool should you use?

Medium
59

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?

Medium
60

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?

Easy
61

You are managing a Microsoft Fabric capacity that hosts multiple workspaces. Users report intermittent slow performance in Power BI reports. You need to identify which workload is consuming the most capacity resources during peak hours. What should you use?

Hard
62

You are troubleshooting a Microsoft Fabric Lakehouse that is experiencing slow query performance when using SQL endpoints. You notice that many small Parquet files are being generated by frequent data ingestion jobs. What should you do to improve query performance?

Hard
63

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

Medium
64

You are maintaining a Microsoft Fabric workspace that uses Git integration with Azure DevOps. A developer accidentally commits a change to a semantic model that breaks downstream reports. You need to revert the workspace to the previous working version of the semantic model. What should you do?

Medium
65

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?

Easy
66

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?

Hard
67

You are maintaining a Microsoft Fabric workspace that uses a deployment pipeline to promote content from development to test to production. A developer accidentally deleted a semantic model in the development stage. You need to restore the semantic model to the development stage without affecting the test or production stages. What should you do?

Medium
68

You are a Fabric analytics engineer responsible for maintaining a Microsoft Fabric workspace. You need to ensure that the workspace is compliant with your organization's data governance policies. The policies require that you can identify the lineage of data from source to report and that you can classify sensitive data automatically. Which two actions should you perform? (Choose two.)

Hard
69

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?

Hard
70

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)

Easy
71

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?

Medium
72

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?

Medium
73

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)

Medium
74

You are maintaining a Microsoft Fabric workspace that contains a Lakehouse, a Data Warehouse, and several semantic models. The capacity administrator reports that interactive queries from Power BI reports sometimes fail with 'Capacity exceeded' errors during peak hours, even though the capacity has sufficient compute. You suspect that background operations are consuming resources. Which action should you take to identify the top resource-consuming items?

Medium
75

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?

Medium
76

You manage a Microsoft Fabric workspace that contains a semantic model used by a Power BI report. The report's scheduled refresh is failing because the data source credentials have expired. You need to update the credentials so that the refresh can succeed. What should you do?

Easy

Frequently asked questions

What does the Maintain a Data Analytics Solution domain cover on the DP-600 exam?
You must be able to monitor and remediate Fabric pipeline capacity issues, compact small Parquet files for SQL endpoint performance, and revert workspace changes using Git integration. The single most important thing: always diagnose the root cause—capacity, file layout, or version control—before applying a fix.
How many questions are in this domain?
This page lists all 76 Maintain a Data Analytics Solution questions in the DP-600 question bank. The actual exam draws from this domain proportionally to its weighting in the official exam blueprint.
What is the best way to practise this domain?
Start with a short focused session (10 questions) to identify gaps, then work through explanations. Repeat with a longer session once the weak areas feel solid.
Can I practise only Maintain a Data Analytics Solution questions?
Yes — the session launcher on this page filters questions to this domain only. Choose any session length for inline explanations and scoring.
Microsoft Fabric Analytics Engineer Associate DP-600 Maintain a Data Analytics Solution Practice Questions