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.
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.
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?
Easy2You 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)
Hard3An 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?
Medium4You 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?
Hard5You 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.)
Medium6You 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?
Hard7You 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.)
Medium8You 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?
Medium9You 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?
Medium10You 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?
Easy11You 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.)
Medium12You 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?
Medium13You 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?
Medium14You 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?
Medium15You 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?
Hard16You 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?
Medium17You 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?
Easy18Refer 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?
Medium19You 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?
Medium20You 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?
Easy21You 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?
Easy22You 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?
Medium23You 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?
Easy24You are managing a Fabric solution and need to identify if a specific notebook is consuming excessive memory. Which Fabric tool should you use?
Medium25You 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?
Medium26You 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?
Hard27You 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?
Easy28Refer 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?
Hard29Refer 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'?
Hard30A 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?
Hard31Your 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?
Medium32You 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?
Medium33You 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?
Medium34You 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?
Easy35Your 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?
Medium36You 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.)
Hard37Refer 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?
Medium38Your 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?
Medium39Refer 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?
Hard40You 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?
Medium41You 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?
Hard42You 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?
Medium43You 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?
Hard44You need to automate the deployment of Fabric items across Development, Test, and Production environments. Which tool is the standard for managing these lifecycle stages?
Medium45You 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?
Medium46You 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?
Hard47You 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?
Medium48You 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?
Hard49You 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?
Easy50You are optimizing a Lakehouse for performance. Which three actions help improve the query performance for users accessing the SQL endpoint?
Hard51A 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?
Medium52You 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?
Hard53You 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?
Medium54You 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?
Medium55A 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?
Hard56You 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?
Medium57You 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?
Hard58You 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?
Medium59You 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?
Medium60You 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?
Easy61You 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?
Hard62You 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?
Hard63Refer to the exhibit. A notebook in your Fabric workspace is failing with the provided error. What is the most likely cause?
Medium64You 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?
Medium65A 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?
Easy66A 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?
Hard67You 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?
Medium68You 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.)
Hard69You 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?
Hard70A 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)
Easy71You 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?
Medium72You 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?
Medium73You 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)
Medium74You 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?
Medium75You 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?
Medium76You 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?
EasyOther domains
All DP-600 exam domains
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.