Be able to deploy and monitor a Fabric analytics solution end to end: configure Git integration, read Capacity Metrics indicators, maintain Delta tables including partitioned updates, and pick the right item (Warehouse, Lakehouse, Eventhouse) for T-SQL and transactional needs.
Start practicing
Implement and Manage an Analytics Solution — choose a session length
Free · No account required
Domain overview
This domain covers deploying, securing, monitoring, and governing Microsoft Fabric analytics solutions. Expect questions on Git integration and workspace sync behavior, Fabric Capacity Metrics app interpretation, Lakehouse Delta table maintenance including partitioned updates, and choosing between Warehouse, Lakehouse, and Eventhouse for T-SQL and transactional workloads.
Exam objectives
Git integration sync between branches and Fabric workspaces, including sensitivity label and metadata behavior
Fabric Capacity Metrics app indicators such as background rejection, throttling, and capacity utilization
Delta Lake table row-level updates and partitioning strategies in a Fabric Lakehouse
Selecting Warehouse versus Lakehouse for T-SQL querying and multi-table transaction support
Assuming Git sync carries over all item metadata and sensitivity labels; workspace-level settings and permissions are not versioned with the item.
Confusing background rejection with foreground throttling in Capacity Metrics; background rejection relates to deferred or rejected background operations, not interactive query failures.
Choosing a Lakehouse when the requirement explicitly needs multi-table transactions or full T-SQL DML, which points to a Fabric Warehouse.
Click any question to see the full explanation and answer options, or start a focused practice session above.
Your organization uses Microsoft Fabric with three distinct workspaces for Development, Test, and Production. You need to automate the movement of a Lakehouse and its associated semantic model through these environments while ensuring that the Production environment uses a different data source connection string than the Development environment. Which feature should you implement?
2Refer to the exhibit. You are reviewing the JSON definition for a Spark Job Definition in Microsoft Fabric. The job is failing after exhausting all retries during periods of high capacity utilization. To ensure the job has a better chance of succeeding without increasing the maxRetryCount, which change should you implement in the job configuration?
3You are the Fabric Administrator for a large enterprise. You need to organize workspaces by business department (e.g., Finance, Marketing, Sales) to allow department heads to manage their own settings and users while still maintaining centralized billing. What is the most efficient way to achieve this grouping and delegated management?
4A Data Engineer needs to share a specific folder within a Lakehouse with a different team. The team should only be able to read the files in that specific folder and should not have access to any other data in the Lakehouse or the ability to run Spark notebooks. What is the most secure method to implement this?
5Your Fabric capacity is consistently reaching 100% utilization during the morning hours, causing background jobs to be delayed. You want to identify which specific items (e.g., specific Notebooks or Warehouses) are consuming the most Capacity Units (CUs). Which tool should you use?
6Refer to the exhibit. An administrator is reviewing the properties of a Lakehouse via the Fabric REST API. The property 'hasManagedPrivateEndpoint' is set to true. What does this indicate about the security configuration for this specific item?
7You are setting up a Microsoft Fabric environment for a development team. You want to use Git integration to allow developers to work in their own branches. Which THREE Fabric items are currently supported for Git integration?
8A company needs to implement a solution where data engineers can create and manage Lakehouses, but they should not be able to delete the workspace itself or modify the capacity settings. Which workspace role should be assigned to these engineers?
9You are configuring a new Microsoft Fabric tenant. You want to ensure that users can only create Fabric items if they are assigned to a specific security group. Where should you configure this restriction?
10Refer to the exhibit. Your Fabric capacity is showing a status of 'Throttled' for background operations. Based on the JSON snippet from the capacity monitoring logs, what is the most likely consequence for a new Spark Notebook scheduled to run immediately?
11You are optimizing a Fabric Warehouse for complex analytical queries involving large fact tables. Which TWO actions should you perform to improve query performance?
12Which component in Microsoft Fabric is primarily designed for data integration and orchestration of complex workflows?
13You need to monitor the performance of your Fabric SQL Warehouse. Which tool or feature should you use to identify long-running queries?
14Refer to the exhibit. Which command would be most effective for improving query performance on this table if you frequently filter by TransDate?
15Your organization requires that all data stored in the Fabric Lakehouse must be encrypted at rest using a customer-managed key (CMK). What is the mandatory step to achieve this?
16Which action must be taken to enable 'Time Travel' functionality on a Delta Lake table in Fabric?
17You are implementing a security model where users should only see rows matching their assigned department. Which Fabric feature enables this?
18Which approach is most efficient for loading a large volume of historical data into a Fabric Lakehouse from an external source?
19When designing an analytics solution, what is the primary purpose of the 'Gold' layer in a Medallion architecture?
20Your organization is implementing a multi-stage development lifecycle in Microsoft Fabric. You need to ensure that when content moves from the 'Test' workspace to the 'Production' workspace, the data source connection automatically switches from the test SQL database to the production SQL database. Which feature should you configure?
21A data engineering team is setting up Git integration for a Microsoft Fabric workspace. They need to ensure that the synchronization process is robust and follows best practices for collaborative development. Which TWO actions should the team perform to successfully manage version control for Fabric items? (Choose TWO)
22A data engineer needs to share a workspace with a colleague who must be able to create, edit, and delete items like Lakehouses and Notebooks, but should not be allowed to modify workspace permissions or add new members. Which workspace role should be assigned?
23A large enterprise wants to implement a 'Hub and Spoke' data architecture in Microsoft Fabric. They need to share a validated 'Gold' Lakehouse from a central workspace with multiple departmental workspaces without duplicating the underlying storage in OneLake. What is the most effective method to achieve this?
24An organization must comply with strict data residency requirements. They have a Microsoft Fabric tenant in the 'East US' region but need to create a workspace where data is stored and processed in 'North Europe'. How can the administrator achieve this?
25You are managing a Microsoft Fabric workspace and notice that several notebooks are failing because they cannot find specific Python libraries. You want to ensure that every notebook in the workspace has access to the same version of these libraries without manual installation in each notebook. What should you do?
26An organization is using the 'Fabric Capacity Metrics' app to monitor their F64 capacity. They see a high 'Background rejection' rate. What does this indicator typically mean for the analytics solution?
27You are implementing a security strategy for Microsoft Fabric. You need to ensure that data access is restricted based on sensitivity labels and that these labels persist when data is exported to Excel. Which TWO statements describe the behavior of sensitivity labels in Fabric? (Choose TWO)
28Your organization wants to automate the deployment of Fabric items using a CI/CD pipeline in Azure DevOps. You need to programmatically trigger the deployment of a Fabric workspace from the 'Development' stage to the 'Test' stage in a deployment pipeline. Which approach should you use?
29A large enterprise is organizing its Microsoft Fabric environment. They need to allow a team of developers to create and modify Lakehouses, Warehouses, and Notebooks within a specific workspace. However, the organization's security policy dictates that these developers must not be able to share items or modify the workspace's membership. Which workspace role should you assign to these developers?
30A company is using Git integration in Microsoft Fabric to manage their Lakehouse and Report items. They notice that after a developer committed changes to a branch and synced them to the workspace, certain sensitive metadata files are being tracked in the repository. Which file should be modified in the local Git repository to prevent specific Fabric item metadata from being tracked in the future?
31A company is using a Fabric F64 capacity. During a period of low activity, the administrator wants to reduce costs. What is the most direct way to stop incurring charges for the Fabric compute resources without deleting the capacity?
32Refer to the exhibit. An administrator is reviewing the capacity metrics for a Fabric F64 capacity. The logs indicate that the 'percentUtilization' has exceeded 100% and the 'throttlingStatus' is 'Throttled'. What is the most likely cause for this behavior in a Fabric environment?
33You are managing a Microsoft Fabric environment and need to implement 'Endorsement' for several high-quality datasets to help users find reliable data. Which TWO levels of endorsement can you apply to Fabric items?
34An organization wants to use Sensitivity Labels from Microsoft Purview to protect data in Microsoft Fabric. When a sensitivity label is applied to a Power BI report in a Fabric workspace, what is the default behavior regarding the protection of data exported from that report to an Excel file?
35You are implementing a multi-workspace architecture in Fabric. You need to enable a 'Managed Identity' for a specific Fabric workspace to allow it to securely access an Azure Data Lake Storage (ADLS) Gen2 account without managing service principal secrets. What is a key requirement for using Workspace Managed Identities in Fabric?
36A data engineering team is using a service principal to automate the deployment and management of Fabric items via the REST API. Which THREE of the following actions must be completed to enable a service principal to work with Fabric APIs?
37You are managing a Microsoft Fabric Lakehouse. You need to ensure that data in the Bronze layer is accessible to the Silver layer while enforcing strict row-level security for downstream users. What is the most efficient way to implement this architecture while maintaining performance?
38You are a data engineer at a retail company using Microsoft Fabric. The company has a workspace with a Lakehouse that contains a large sales table. You need to ensure that when you run a notebook, it uses a specific Spark pool with autoscaling enabled to handle varying workloads. Which configuration should you apply to the notebook?
39You are designing a Fabric analytics solution that uses OneLake. You need to ensure that when data is written to a Lakehouse table, it is immediately available for querying by other Fabric engines such as SQL analytics endpoint and Power BI, without manual refresh. Which storage format should you use for the Lakehouse tables?
40A data engineer creates a Fabric Data Pipeline that copies data from an Azure SQL Database into a Lakehouse. The pipeline occasionally fails during the copy activity due to transient network errors. The engineer wants the activity to automatically retry up to three times before marking the pipeline run as failed. What should the engineer configure on the Copy activity?
41A data engineer is designing a Fabric workspace that will host a Lakehouse and several notebooks. The workspace must support Git integration with an Azure DevOps repository. The engineer needs to ensure that when changes are committed, only the notebook definitions and Lakehouse metadata are versioned, while the actual Parquet data files remain in OneLake and are not pushed to Git. Which statement describes the correct behavior of Fabric Git integration?
42You are a data engineer at a retail company using Microsoft Fabric. A Delta table named Sales in a Lakehouse contains historical transaction data. The table currently has 1,200 small Parquet files, and users report that queries filtering by TransactionDate are slow. You need to optimize the table to improve query performance for filters on TransactionDate. What should you do?
43A data engineer needs to schedule a Fabric Data Pipeline to run every day at 2:00 AM. The pipeline copies data from an external source into a Lakehouse. The engineer wants to configure the schedule directly on the pipeline item. What should the engineer do?
44You are designing a Microsoft Fabric solution that includes a Data Pipeline and a Notebook. The pipeline must run the notebook and then, upon successful completion, send a notification email to the data engineering team. You need to configure the pipeline to achieve this with minimal effort. What should you do?
45A data engineer is configuring a Fabric Data Pipeline that must copy data from an on-premises SQL Server into a Lakehouse. The engineer needs to ensure the pipeline can connect securely to the on-premises source. Which two actions must the engineer perform? (Choose two.)
46You are a data engineer at a retail company using Microsoft Fabric. The company has a workspace with a Lakehouse that contains a large sales table. You need to create a shortcut to an external Azure Data Lake Storage Gen2 account so that analysts can query the data without copying it. The storage account uses a hierarchical namespace and the data is in Parquet format. You want to minimize data movement and ensure that the shortcut is available to all users in the workspace. What should you do?
47You are a Fabric data engineer managing a Lakehouse in a workspace that uses Fabric capacity. The Lakehouse contains a Delta table with 500 million rows. You need to enforce that every new write to this table automatically validates a set of data quality rules (for example, non-null keys and allowed status codes) before the data becomes visible to downstream consumers. Which approach should you implement?
48You are a data engineer for a retail company using Microsoft Fabric. The sales team wants a near real-time Power BI report that shows the total sales amount for the current day, updating every minute. The source data is continuously streamed into an Eventstream. You need to implement a solution that aggregates the streaming data and makes it available for the report with minimal latency. What should you do?
49A data engineer manages a Fabric workspace that contains a Lakehouse used by multiple teams. The engineer needs to ensure that when a notebook writes to a Delta table in the Lakehouse, other readers see a consistent snapshot and do not encounter partially written data. Which feature of Delta Lake in Fabric provides this guarantee?
50You are a data engineer for a financial services firm using Microsoft Fabric. You have a Fabric pipeline that ingests data from an on-premises SQL Server into a Lakehouse. The pipeline runs daily and must complete within a 2-hour window. You notice that the pipeline occasionally fails due to transient network errors. You need to ensure the pipeline is resilient and meets the SLA. What should you configure?
51You are designing a Microsoft Fabric analytics solution that ingests near real-time events from Azure Event Hubs into a Lakehouse and serves them to a Power BI report with sub-minute latency. You need to minimize data duplication and ensure the report reads from a single logical table. Which two components should you include in the solution? (Choose two.)
52You are designing a Microsoft Fabric solution that ingests data from an Azure SQL Database into a Lakehouse. The data volume is large and the ingestion must occur incrementally every 15 minutes. You need to minimize the load on the source system and ensure that only new or changed rows are copied. Which Fabric component should you use?
53A data engineer needs to schedule a nightly job in Microsoft Fabric that copies files from an Azure Data Lake Storage Gen2 account into a Lakehouse, then runs a notebook to transform the data. The engineer wants built-in retry, dependency, and monitoring capabilities without writing orchestration code. What should the engineer use?
54You are a data engineer working with a Microsoft Fabric Data Pipeline. The pipeline must copy data from an on-premises SQL Server to a Lakehouse. You have installed the on-premises data gateway. What should you do next to enable the pipeline to connect to the on-premises SQL Server?
55You manage a Microsoft Fabric workspace backed by Fabric capacity. A data engineer reports that a nightly Spark notebook writing to a Lakehouse table intermittently fails with an out-of-memory error during a large shuffle. You must reduce the chance of recurrence without changing the notebook logic or the data volume. Which action should you take?
56You are a data engineer working with Microsoft Fabric. You have a Lakehouse named SalesLakehouse that contains a Delta table named Sales. You need to optimize the table for query performance by reducing the number of small files. Which action should you take?
57You are designing a Microsoft Fabric workspace that will contain a Lakehouse, a Warehouse, and several Data Pipelines. Your organization's security policy requires that data engineers can create and modify items in the workspace, but they must not be able to grant permissions to other users or delete the workspace. Which workspace role should you assign to the data engineers?
58You are implementing a Microsoft Fabric solution where a data engineer must be able to create and modify Lakehouse items and run notebooks in a workspace, but must not be able to change workspace settings, add users, or delete the workspace. Which workspace role should you assign?
59You manage a Microsoft Fabric workspace containing a Lakehouse named SalesLakehouse. A downstream analytics team reports that queries against the Delta table dbo.FactSales are slow because the table contains millions of small Parquet files. You need to consolidate these files into larger files without changing the table schema or losing any data. What should you do?
60You are a data engineer at a logistics company using Microsoft Fabric. You have a Fabric workspace with a Lakehouse and several notebooks. You need to ensure that when a notebook is run, it uses a specific Spark pool configuration that includes custom libraries and a fixed number of executors. You also want to minimize startup time for interactive sessions. What should you do?
61You manage a Microsoft Fabric capacity that hosts a mission-critical Lakehouse. The workspace uses a custom domain and has sensitivity labels applied. You need to ensure that only users who are members of a specific Microsoft Entra ID security group can access the workspace, and that access is reviewed quarterly. Which combination of Fabric features should you use to meet these requirements?
62You manage a Fabric workspace that contains a Lakehouse with a Delta table named Sales. The table currently has 1,200 small Parquet files, and nightly queries that filter by OrderDate are slow. You need to reduce the number of files and improve filter performance without changing the table schema or losing the ability to incrementally append new data. What should you do?
63A data engineer needs to create a Microsoft Fabric item that provides a relational, SQL-based query endpoint over Delta tables stored in OneLake. The item must allow business analysts to connect using T-SQL without moving or duplicating the data. Which Fabric item should the engineer create?
64You are a data engineer in a Microsoft Fabric environment. You need to create a solution that allows business analysts to query data using T-SQL and also supports multi-table transactions. Which Fabric item should you use?
65You are monitoring a Microsoft Fabric data pipeline that copies data from an Azure SQL Database to a Lakehouse. The pipeline run failed with an error indicating that the source connection timed out. You need to ensure that future runs can recover automatically from transient network issues. What should you configure on the Copy activity?
66You are a data engineer at a healthcare company using Microsoft Fabric. You have a Warehouse named 'HealthDW' that contains patient data. You need to implement dynamic data masking to protect sensitive columns such as 'PatientName' and 'SSN'. The masking should allow users with the 'DataEngineer' role to see the full data, while other users see masked values. You also need to ensure that the masking rules are applied consistently across all queries. What should you do?
67A Fabric workspace contains a Lakehouse and a Warehouse. A data engineer needs to schedule a recurring refresh that copies new rows from an on-premises SQL Server into the Lakehouse and then runs a stored procedure in the Warehouse. The engineer wants a low-code orchestration experience with built-in scheduling and monitoring. What should the engineer use?
68You are optimizing a Microsoft Fabric Data Pipeline that ingests data from an on-premises Oracle database into a Lakehouse. The pipeline currently uses a single Copy activity with default settings and takes several hours to complete. You need to reduce the ingestion time without changing the source system or the destination schema. Which action should you take?
69You are a data engineer in a Microsoft Fabric workspace. You need to implement a solution that allows you to run Spark jobs to process data in a Lakehouse and then expose the results as a SQL table for reporting. The solution must minimize data duplication and support ACID transactions. Which approach should you use?
70You are designing a Microsoft Fabric solution that uses a Lakehouse to store Delta tables. A data engineer needs to update specific rows in a large Delta table based on a condition. The table is partitioned by date and contains billions of records. You need to minimize the amount of data rewritten during the update. What should you use?
71You are designing a Fabric Lakehouse solution. The Silver layer must contain cleaned, deduplicated data that is updated incrementally every 15 minutes. Queries against the Silver tables must return consistent results even while updates are in progress, and the solution must avoid full table rewrites. Which Delta Lake feature should you implement?
72You are implementing a medallion architecture in Microsoft Fabric. You have a Lakehouse with Bronze, Silver, and Gold layers. You need to ensure that data in the Gold layer is optimized for Power BI Direct Lake mode. Which two actions should you perform? (Choose two.)
73You are implementing a Microsoft Fabric solution that uses a Data Pipeline to copy data from an on-premises SQL Server to a Lakehouse. The pipeline runs on a schedule every hour. You need to ensure that the pipeline can connect to the on-premises SQL Server securely without exposing credentials in the pipeline definition. What should you do?
74You are a data engineer for a retail company using Microsoft Fabric. A Fabric pipeline loads daily sales data into a Lakehouse. The pipeline sometimes fails due to transient SQL errors when connecting to the on-premises source. You need to ensure that the activity automatically retries up to 3 times with a 30-second interval between attempts. Which pipeline activity setting should you configure?
75A data engineering team has a Microsoft Fabric workspace with a lakehouse that contains a shortcut to an external ADLS Gen2 container. They need to ensure that when a notebook reads the shortcut, it uses the workspace identity to authenticate to the external storage without embedding credentials. Which configuration should they use?
76You are a data engineer working with a Microsoft Fabric Lakehouse. You need to optimize a large Delta table named FactSales that is frequently queried with filters on the TransactionDate column and joins on the ProductKey column. The table is partitioned by TransactionDate. You notice that queries filtering on TransactionDate perform well, but queries joining on ProductKey are slow due to data shuffling. What should you do to improve the performance of queries involving ProductKey?
77You are a data engineer working with a Microsoft Fabric Data Pipeline. The pipeline contains a ForEach activity that iterates over a list of file names and runs a Notebook activity for each file. You need to ensure that the Notebook activities run in parallel to reduce overall execution time, but you must limit the parallelism to avoid overwhelming the capacity. What should you do?
78A data engineer is monitoring a Fabric Data Pipeline that copies data from an on-premises SQL Server to a lakehouse. The pipeline runs successfully but takes longer than expected. They need to identify the bottleneck without modifying the pipeline. Which feature should they use?
79You are a data engineer working with a Microsoft Fabric Data Pipeline that copies data from an Azure SQL Database to a Lakehouse. The pipeline uses a copy activity with a source dataset that includes a parameter for the table name. You need to ensure that the pipeline can dynamically select the table to copy based on a pipeline parameter. Which two actions should you perform? (Choose two.)
80You are a data engineer at a financial services company using Microsoft Fabric. You need to create a Lakehouse that will store sensitive customer data. Your security team requires that all data is encrypted at rest using a customer-managed key (CMK) stored in Azure Key Vault. What should you do?
81You are a data engineer using Microsoft Fabric. You have a Lakehouse with a Delta table named inventory that is frequently updated with new stock levels. You need to create a report that shows the current stock level for each product. The report must always reflect the latest data with minimal latency. Which Fabric feature should you use to serve the data to the report?
82You are a data engineer managing a Microsoft Fabric workspace that contains a Lakehouse with sensitive customer data. Your security team requires that downstream report authors using Direct Lake semantic models can only see data for customers in their own region, and that the filter is enforced at the semantic model level rather than in each report. You have already created a mapping table that links user principal names to region codes in the Lakehouse. What should you configure on the semantic model?
83You are designing a Microsoft Fabric solution that ingests streaming data from Azure Event Hubs into a Lakehouse. The data must be processed in near real-time and stored in Delta tables. You need to ensure that the solution can handle occasional spikes in data volume without data loss and with minimal latency. Which Fabric component should you use?
84A data engineer needs to give a group of analysts read-only access to a specific set of tables in a Fabric Lakehouse without granting them access to the rest of the workspace. The analysts use their own Fabric capacity workspace for reporting. Which Fabric capability should the engineer use to share only the required tables?
85A data engineer is building a Fabric Data Pipeline that copies a large table from an Azure SQL Database into a Lakehouse every night. The pipeline currently uses default settings and the copy takes longer than the maintenance window. The engineer observes that the source table has a numeric primary key and that the copy process is single-threaded. Which change should the engineer make to reduce the copy duration while keeping the load incremental?
Be able to deploy and monitor a Fabric analytics solution end to end: configure Git integration, read Capacity Metrics indicators, maintain Delta tables including partitioned updates, and pick the right item (Warehouse, Lakehouse, Eventhouse) for T-SQL and transactional needs.
The Courseiva DP-700 question bank contains 85 questions in the Implement and Manage an 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 Implement and Manage an 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