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.
Start practicing
Maintain a Data Analytics Solution — choose a session length
Free · No account required
Domain overview
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.
Exam objectives
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.
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.
Click any question to see the full explanation and answer options, or start a focused practice session above.
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?
2You 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?
3You 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?
4Refer 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?
5You 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?
6A 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?
7Your 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?
8Refer 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?
9You 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?
10You 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?
11A 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?
12You 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?
13Refer 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'?
14You 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?
15You 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?
16A 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?
17You 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?
18You 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?
19You 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?
20You 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?
21You 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?
22You 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?
23Refer 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?
24You 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?
25You 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?
26You 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?
27Your 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?
28You 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?
29You need to automate the deployment of Fabric items across Development, Test, and Production environments. Which tool is the standard for managing these lifecycle stages?
30Refer to the exhibit. A notebook in your Fabric workspace is failing with the provided error. What is the most likely cause?
31You are optimizing a Lakehouse for performance. Which three actions help improve the query performance for users accessing the SQL endpoint?
32You 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?
33You are managing a Fabric solution and need to identify if a specific notebook is consuming excessive memory. Which Fabric tool should you use?
34A 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?
35A 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)
36Refer 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?
37An 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?
38You 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)
39A 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?
40You 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)
41You 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?
42You 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?
43You 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?
44You 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?
45You 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?
46You 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?
47You 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?
48You 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.)
49You 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?
50You 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?
51You 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?
52You 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?
53You 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?
54You 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?
55You 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?
56You 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?
57You 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?
58You 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.)
59You 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?
60You 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?
61You 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?
62You 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?
63You 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.)
64You 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?
65You 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?
66You 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.)
67You 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?
68You 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?
69You 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?
70You 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?
71You 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?
72You 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?
73You 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.)
74You 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?
75You 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?
76You 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?
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.
The Courseiva DP-600 question bank contains 76 questions in the Maintain a Data Analytics Solution domain. Click any question to see the full explanation and answer breakdown.
Start with a 10-question focused session to identify your baseline accuracy in this domain. Read every explanation — even for questions you answer correctly — to understand the reasoning. Once you score consistently above 80%, move to a 20–30 question session to confirm depth before moving to the next domain.
Yes — the session launcher on this page draws questions exclusively from the Maintain a Data Analytics Solution domain. Choose 10, 20, 30, or 50 questions for a focused session, or click individual questions to review them one by one.
Save your results, see per-domain analytics, and get readiness scores — free, for every certification.
Sign Up FreeFree forever · Every certification included