I85PREP
⌘ K
Fabric DP-700 study materials
Fabric DP-700 study resources

Fabric DP-700 practice questions

One question at a time. Build your Fabric DP-700 understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Implement and manage an analytics solution

A workspace administrator must be able to add and remove workspace members and delete the workspace. Which workspace role provides these capabilities?

  1. Admin Correct answer.
  2. Contributor
  3. Viewer
  4. Member

Explanation

Workspace roles are Admin, Member, Contributor, and Viewer. Only Admin can manage workspace membership and delete the workspace, in addition to all item permissions.

Question 2Implement and manage an analytics solution

Which configuration enables a workspace to host Fabric items such as lakehouses and notebooks?

  1. Assigning Power BI Premium Per User licenses to all users
  2. Assigning the workspace to a Fabric capacity Correct answer.
  3. Connecting the workspace to an Azure SQL database
  4. Assigning Power BI Pro licenses to all users

Explanation

Fabric items are created in workspaces that are backed by a capacity, such as a Fabric F SKU, a Power BI Premium P SKU, or a Fabric trial capacity. Per-user Pro or PPU licenses alone do not enable Fabric item creation.

Question 3Implement and manage an analytics solution

When data is loaded into a managed table in a Fabric lakehouse, where and in what format is the table stored?

  1. CSV files in the Files folder
  2. Parquet files in the Files folder without a transaction log
  3. JSON documents in the Tables folder
  4. Delta Lake files in the Tables folder Correct answer.

Explanation

Lakehouse managed tables are stored as Delta Lake tables under the Tables folder of the lakehouse. The Files folder is intended for files that are not managed as tables.

Question 4Implement and manage an analytics solution

What is the primary characteristic of a OneLake shortcut?

  1. It references data in another location without copying it Correct answer.
  2. It converts external data into CSV files
  3. It copies source data into the lakehouse on a recurring schedule
  4. It creates a cached replica that must be refreshed

Explanation

A shortcut is a OneLake item that points to data stored elsewhere, such as another lakehouse, ADLS Gen2, or Amazon S3. Reads go to the target data, so no copy is created.

Question 5Implement and manage an analytics solution

In a medallion architecture, what is the main purpose of the gold layer?

  1. Serve curated, aggregated data for BI Correct answer.
  2. Archive deleted records for compliance
  3. Store raw data exactly as received
  4. Hold deduplicated but unvalidated data

Explanation

The gold layer contains business-level, aggregated, and curated data that is ready for reporting and analytics. Raw data belongs to bronze, and cleaned but not yet modeled data belongs to silver.

Question 6Implement and manage an analytics solution

Which Fabric feature is designed to promote items from a development workspace through test and production workspaces?

  1. OneLake shortcuts
  2. Git-based source control integration
  3. Data pipelines
  4. Deployment pipelines Correct answer.

Explanation

Deployment pipelines define stages, such as development, test, and production, and deploy item definitions between the workspaces assigned to those stages. Git integration provides version control but does not manage staged promotion.

Question 7Implement and manage an analytics solution

Which source control providers can a Fabric workspace connect to for Git integration?

  1. Only on-premises Team Foundation Version Control
  2. Azure DevOps Repos and GitHub Correct answer.
  3. Only GitHub
  4. Only Azure DevOps Repos

Explanation

Fabric Git integration supports connecting a workspace to either an Azure DevOps repository or a GitHub repository. On-premises TFVC is not a supported provider.

Question 8Implement and manage an analytics solution

Which endorsement level indicates that an item has been reviewed and approved by an authorized reviewer?

  1. Promoted
  2. Verified
  3. Certified Correct answer.
  4. Endorsed

Explanation

Certified is the higher endorsement level and requires a reviewer with permission to certify items. Promoted indicates that the owner considers the item ready to use but does not require review.

Question 9Implement and manage an analytics solution

Which T-SQL construct enforces row-level security in a Fabric warehouse?

  1. A column-level GRANT statement
  2. A security policy with a predicate function Correct answer.
  3. A stored procedure that checks SUSER_SNAME()
  4. A view that filters rows with a WHERE clause

Explanation

Row-level security in a Fabric warehouse is implemented with CREATE SECURITY POLICY, which applies an inline table-valued function as a predicate to a table. Views and stored procedures can be bypassed and do not enforce RLS by themselves.

Question 10Implement and manage an analytics solution

A varchar column uses the default dynamic data masking function, and a user has no UNMASK permission. What does the user see in that column?

  1. 0
  2. XXXX Correct answer.
  3. NULL
  4. 1900-01-01

Explanation

Default masking replaces string values with XXXX, numeric values with 0, and date/time values with 1900-01-01. Users who need the real values must be granted UNMASK.

Question 11Implement and manage an analytics solution

A scheduled pipeline must read from Azure Data Lake Storage Gen2 when no user is signed in. Which identity should be granted access to the storage account?

  1. The tenant's Power BI service account
  2. The workspace identity Correct answer.
  3. The capacity administrator's user account
  4. The pipeline author's user account

Explanation

A workspace identity is a Microsoft Entra service principal associated with the workspace, and Fabric items can use it for automated access to external storage. Granting the workspace identity permission on the storage account allows scheduled runs without user credentials.

Question 12Implement and manage an analytics solution

A pipeline must copy 20 source tables with different names into a lakehouse. What is the most maintainable design?

  1. Use a single copy activity with a wildcard query
  2. Create 20 pipelines triggered by one schedule
  3. Create 20 separate copy activities with hard-coded table names
  4. Use a ForEach activity with a parameterized copy activity Correct answer.

Explanation

A ForEach activity can iterate over a list of table names and pass each name as a parameter to a single copy activity. This avoids duplicating pipeline logic and makes changes easier.

Question 13Implement and manage an analytics solution

Which Fabric item is best suited for analysts who need low-code transformations with Power Query connectors before writing results to a lakehouse?

  1. Spark notebook
  2. Dataflow Gen2 Correct answer.
  3. Mirrored database
  4. KQL queryset

Explanation

Dataflow Gen2 provides a Power Query low-code experience with many connectors and supports a lakehouse or warehouse as an output destination. Notebooks require code, KQL querysets query KQL databases, and mirrored databases replicate source data.

Question 14Implement and manage an analytics solution

A Spark notebook is attached to a lakehouse. Which action makes a DataFrame available as a managed table through the lakehouse SQL analytics endpoint?

  1. Writing the DataFrame to the Files folder as CSV
  2. Saving the DataFrame as a Delta table in the Tables folder Correct answer.
  3. Calling df.cache()
  4. Registering a temporary view with createOrReplaceTempView

Explanation

Managed tables appear in the lakehouse SQL analytics endpoint when Delta data is written under the Tables folder, for example with saveAsTable. Temporary views are scoped to the notebook session and are not exposed through the endpoint.

Question 15Implement and manage an analytics solution

A solution must ingest thousands of events per second from Azure Event Hubs and route them to a KQL database with minimal code. Which Fabric item should be used?

  1. Notebook with a scheduled trigger
  2. Data pipeline with a copy activity
  3. Dataflow Gen2
  4. Eventstream Correct answer.

Explanation

Eventstream is the Fabric real-time ingestion item that can read from Event Hubs and route events to destinations such as a KQL database, lakehouse, or derived stream. Pipelines and dataflows are batch-oriented, and scheduled notebooks introduce latency.

Question 16Implement and manage an analytics solution

What does Fabric mirroring provide for a source such as Azure SQL Database?

  1. A one-time copy that must be refreshed manually
  2. Query federation that leaves the data in the original source system
  3. A writable copy that replaces the source
  4. Continuous replication of changes into OneLake as read-only Delta tables Correct answer.

Explanation

Mirroring continuously replicates source changes into OneLake, where the data is stored as Delta tables that are read-only. The source system remains the system of record and no ETL is required.

Question 17Implement and manage an analytics solution

Before renaming a warehouse table, a developer wants to see which reports and downstream items depend on it. Which feature should they use?

  1. Deployment pipelines
  2. Capacity metrics app
  3. Lineage view Correct answer.
  4. Sensitivity labels

Explanation

The lineage view shows the upstream and downstream dependencies of an item in the workspace. It helps identify the reports and other items affected by a change.

Question 18Implement and manage an analytics solution

Users report slow interactive queries and rejected operations during peak hours. Which tool helps confirm that the workspace is exceeding its capacity compute limits?

  1. OneLake file explorer
  2. Deployment pipeline history
  3. Git integration history
  4. The Capacity Metrics app Correct answer.

Explanation

The Microsoft Fabric Capacity Metrics app shows capacity unit consumption, throttling, and the effect of smoothing over time. It is the primary tool for investigating capacity pressure.

Question 19Implement and manage an analytics solution

A sensitivity label is applied to a lakehouse. What happens to downstream Fabric items that reference the lakehouse?

  1. They are automatically blocked from being shared
  2. They are moved to a labeled workspace
  3. They inherit the label when it is more restrictive than their own Correct answer.
  4. They keep the workspace default label and ignore the lakehouse label

Explanation

Sensitivity labels propagate from upstream items to downstream items, and the most restrictive label is retained. This keeps protection consistent across the data estate.

Question 20Implement and manage an analytics solution

A user must be able to view one report in a workspace without access to the other items. What should be done?

  1. Assign the user the Viewer workspace role for the workspace
  2. Assign the user the Contributor workspace role for the workspace
  3. Share the report item directly with the user Correct answer.
  4. Add the user to the workspace Admin role

Explanation

Sharing an individual item grants access to that item without granting workspace-wide access. Workspace roles apply to all items in the workspace.

Question 21Implement and manage an analytics solution

A lakehouse contains a folder named HR with sensitive files, and several teams have Contributor access to the workspace. How can access to the HR folder be limited to a specific security group?

  1. Apply a sensitivity label to the HR folder that restricts access
  2. Create a OneLake data access role scoped to the HR folder Correct answer.
  3. Move the folder to the Files section
  4. Create a workspace role assignment for the group

Explanation

OneLake data access roles grant or restrict access at the folder level inside a lakehouse, independent of workspace roles. Assigning the security group to a role scoped to the HR folder restricts other workspace users from reading that folder.

Question 22Implement and manage an analytics solution

In a deployment pipeline, the source connection string differs between the test and production stages. What should be configured?

  1. A parameter rule that overrides the value at deployment
  2. A deployment schedule per stage
  3. A data source rule that changes the connection Correct answer.
  4. A separate pipeline for each stage

Explanation

Deployment pipeline rules let you change values during deployment. A data source rule substitutes the connection used by an item in the target stage, while parameter rules override parameter values.

Question 23Implement and manage an analytics solution

A Delta table is frequently filtered on a customer ID column, and queries scan many small files. Which action improves read performance by colocating related rows?

  1. Enabling the table for mirroring
  2. Converting the table to CSV
  3. Running OPTIMIZE with ZORDER BY on the column Correct answer.
  4. Running VACUUM with a one-hour retention period

Explanation

OPTIMIZE compacts small files, and ZORDER BY colocates rows with similar values in the same files. This reduces the amount of data read when queries filter on the Z-ordered column.

Question 24Implement and manage an analytics solution

Which condition causes a Direct Lake semantic model to fall back to DirectQuery at query time?

  1. The model is refreshed on a schedule
  2. The model contains a measure written in DAX
  3. The lakehouse uses Delta Parquet tables
  4. The model uses row-level security Correct answer.

Explanation

Direct Lake reads Delta files directly, but some features cannot be served that way, including row-level security defined in the semantic model, which causes a fallback to DirectQuery. DAX measures and Delta tables are normal and do not cause fallback.

Question 25Implement and manage an analytics solution

A partner organization in another Microsoft Entra tenant needs read access to a specific lakehouse folder, and the data must not be copied. Which Fabric capability should be used?

  1. A data pipeline that copies the folder
  2. External data sharing Correct answer.
  3. A shortcut to the partner's storage
  4. A mirrored database

Explanation

External data sharing lets a tenant share OneLake data with users in another tenant without copying it. The recipient accesses the shared data through a shared item in their own tenant.

Question 26Implement and manage an analytics solution

An F64 Fabric capacity is used only during business hours, and the administrators want to stop compute billing overnight. What should they do?

  1. Enable autoscale on the capacity.
  2. Change the capacity SKU to F2.
  3. Pause the capacity in the Azure portal. Correct answer.
  4. Remove the workspace assignment from the capacity each evening.

Explanation

Pausing a Fabric capacity stops compute billing until it is resumed, while data remains in OneLake. Resuming restores the same capacity size and workspace assignments. Storage charges continue while the capacity is paused.

Question 27Implement and manage an analytics solution

A user must be able to create and edit items in a workspace but must not be able to grant other users access to that workspace. Which workspace role should be assigned?

  1. Contributor Correct answer.
  2. Admin
  3. Member
  4. Viewer

Explanation

The Contributor role can create, edit, and delete workspace items but cannot manage workspace access. Member and Admin roles include the ability to add users to the workspace. Viewer is read-only.

Question 28Implement and manage an analytics solution

An organization wants to group workspaces by business unit so that governance can be delegated to owners in each unit. Which Fabric feature should be used?

  1. Deployment pipelines
  2. Endorsement
  3. Sensitivity labels
  4. Domains Correct answer.

Explanation

Domains group workspaces and items by business area and allow domain admins to govern their own area. A workspace can be assigned to a single domain. This supports federated governance across a large tenant.

Question 29Implement and manage an analytics solution

A lakehouse must expose Delta tables that already reside in an Azure Data Lake Storage Gen2 account, and the data must not be duplicated. What should be created?

  1. An OneLake shortcut that points to the storage location Correct answer.
  2. A dataflow Gen2 that loads the tables into the lakehouse
  3. A mirrored database for the storage account
  4. A data pipeline that copies the tables into the lakehouse

Explanation

A shortcut is a reference to data held in another location, so Fabric reads the files in place without copying them. Copy activities, dataflows, and mirroring all materialize a second copy of the data.

Question 30Implement and manage an analytics solution

A team needs a relational T-SQL surface that supports full DML and multi-statement transactions over tables stored in OneLake. Which Fabric item should they use?

  1. A warehouse Correct answer.
  2. A KQL database
  3. A lakehouse SQL analytics endpoint
  4. A mirrored database

Explanation

A Fabric warehouse is a full T-SQL engine that supports INSERT, UPDATE, DELETE, and multi-statement transactions over Delta tables in OneLake. Its SQL analytics endpoint counterpart exposes read-only queries over lakehouse tables.

Question 31Implement and manage an analytics solution

Which write-time Parquet optimization stores Delta files in a layout that Fabric compute engines can read faster because it applies sorting and compression in a specific format?

  1. Z-Order
  2. Optimize write
  3. VACUUM
  4. V-Order Correct answer.

Explanation

V-Order is applied when Parquet files are written and produces a layout optimized for Fabric engines such as Direct Lake and Spark. Z-Order is a data-skipping layout applied during OPTIMIZE, and VACUUM removes unreferenced files.

Question 32Implement and manage an analytics solution

Which Delta operation permanently deletes data files that are no longer referenced by the table log and are older than the retention threshold?

  1. FSCK REPAIR TABLE
  2. A log checkpoint
  3. VACUUM Correct answer.
  4. OPTIMIZE

Explanation

VACUUM removes files that the transaction log no longer references once they exceed the retention threshold, which defaults to seven days. Running it with a shorter threshold reduces the window in which time travel is possible.

Question 33Implement and manage an analytics solution

A developer needs to read a Delta table exactly as it existed three versions ago. Which capability should be used?

  1. Query the table with time travel by specifying the version. Correct answer.
  2. Create a shortcut to the table's folder.
  3. Restore the workspace from a backup.
  4. Query the SQL analytics endpoint with NOLOCK.

Explanation

Delta keeps a transaction log of table versions, so a query can specify a version or timestamp to read historical data. Time travel is bounded by log retention and by VACUUM removing old files.

Question 34Implement and manage an analytics solution

Schema support is enabled for a new lakehouse. Which statement describes how its tables are organized by default?

  1. Tables are created in a schema named dbo unless another schema is specified. Correct answer.
  2. Tables cannot be created until an administrator creates a schema manually.
  3. All tables are placed in a single schema that cannot be renamed or extended.
  4. Tables are created in a schema named default until one is renamed.

Explanation

When schemas are enabled, the lakehouse includes a dbo schema that is used when no schema is named. Additional schemas can then be created to group tables by subject area or layer.

Question 35Implement and manage an analytics solution

A report developer needs read-only T-SQL access to the Delta tables in a lakehouse. Which endpoint provides this capability?

  1. The workspace Git remote endpoint
  2. The eventhouse query endpoint
  3. The lakehouse OneLake DFS endpoint
  4. The lakehouse SQL analytics endpoint Correct answer.

Explanation

Every lakehouse exposes a SQL analytics endpoint that serves read-only T-SQL over its Delta tables. The OneLake DFS endpoint is a storage API used by engines and tools rather than an interactive T-SQL surface.

Question 36Implement and manage an analytics solution

A query in a Fabric warehouse must join a table that resides in a second warehouse in the same workspace. How should the second table be referenced?

  1. Through a linked server defined on the warehouse.
  2. With a four-part name that includes a server address.
  3. With a three-part name in the form database.schema.table. Correct answer.
  4. By copying the table into the first warehouse before querying.

Explanation

Fabric warehouses support cross-database queries within the same workspace by using three-part names. No linked server or server address is involved because the databases share the workspace's SQL endpoint.

Question 37Implement and manage an analytics solution

Analysts must be able to create new reports from an existing semantic model but must not be able to change the model itself. Which permission should be granted on the semantic model?

  1. Write
  2. Build Correct answer.
  3. Reshare
  4. Read

Explanation

Build permission lets a user create new reports and other content on top of a semantic model without editing it. Read only allows viewing existing reports that use the model.

Question 38Implement and manage an analytics solution

In a Fabric warehouse, a user must be able to query some columns of the dbo.Customers table but must not see the Email column. Which approach enforces this requirement?

  1. Grant SELECT on the permitted columns only. Correct answer.
  2. Add the user to the workspace Viewer role.
  3. Deny SELECT on the table to the user.
  4. Apply a dynamic data masking rule to the Email column.

Explanation

Granting SELECT on individual columns implements column-level security, so the user can query only those columns. Masking keeps the column visible and returns masked values instead of hiding the column entirely.

Question 39Implement and manage an analytics solution

What is created automatically when a new lakehouse is added to a workspace?

  1. A KQL database
  2. A default semantic model for the lakehouse Correct answer.
  3. A mirrored database
  4. A deployment pipeline

Explanation

A lakehouse is created together with a SQL analytics endpoint and a default semantic model so its Delta tables can be consumed by Power BI. The default model is generated from the lakehouse tables.

Question 40Implement and manage an analytics solution

A Spark notebook requires a specific third-party Python library and custom Spark pool settings. Which Fabric item should supply these to the notebook?

  1. A KQL database
  2. An environment Correct answer.
  3. A data pipeline
  4. A warehouse

Explanation

An environment item stores Spark runtime settings, libraries, and pool configuration that notebooks and Spark job definitions can use. Attaching the environment applies those settings whenever the Spark session starts.

Question 41Implement and manage an analytics solution

A Spark job must run against a lakehouse on a schedule without an interactive notebook session. Which Fabric item is designed for this?

  1. An eventstream
  2. A stored procedure in a warehouse
  3. A Spark job definition Correct answer.
  4. A dataflow Gen2

Explanation

A Spark job definition runs a script against a lakehouse on demand or on a schedule, for example when invoked from a pipeline. It is intended for batch Spark workloads that do not need an interactive session.

Question 42Implement and manage an analytics solution

What does high concurrency mode provide for Fabric notebooks?

  1. Notebooks execute only on the capacity's driver node.
  2. Notebooks bypass the lakehouse and read data through the SQL analytics endpoint.
  3. Each user receives a dedicated Spark cluster that stays running indefinitely.
  4. Multiple users share a single Spark session, which reduces startup time and resource consumption. Correct answer.

Explanation

High concurrency mode lets several users or jobs share one Spark session in the same workspace, so sessions are reused instead of started per user. This lowers startup latency and resource use but introduces shared-session considerations for isolation.

Question 43Implement and manage an analytics solution

A pipeline must run the same copy activity once for each of 30 table names supplied as an array. Which activity provides the iteration?

  1. Switch
  2. Wait
  3. Lookup
  4. ForEach Correct answer.

Explanation

The ForEach activity iterates over a collection and runs the contained activities once per item. The collection can come from an array parameter, a variable, or the output of a Lookup activity.

Question 44Implement and manage an analytics solution

A pipeline must notify a Teams channel when a critical activity fails. What is the recommended configuration?

  1. Enable the secure output option on the activities.
  2. Set the pipeline concurrency to 1.
  3. Add a retry count of 3 to each activity.
  4. Connect the failure output of the critical activity to a Teams notification activity. Correct answer.

Explanation

Pipeline activities expose dependency outputs, including a failure path, so a notification activity can be chained to run only when the upstream activity fails. Retrying may recover transient errors but does not inform anyone when the failure persists.

Question 45Implement and manage an analytics solution

A notebook must read from an ADLS Gen2 account whose firewall permits only selected networks, and the account must not be opened to public access. Which Fabric capability allows this?

  1. Publishing the lakehouse to a Power BI workspace.
  2. Storing a shared access signature in a notebook cell.
  3. Enabling V-Order on the lakehouse tables.
  4. Configuring trusted workspace access for the workspace. Correct answer.

Explanation

Trusted workspace access allows a Fabric workspace to reach a firewall-protected storage account without exposing it to all networks, using the workspace identity for authorization. Network rules on the storage account are then satisfied by the trusted workspace.

Question 46Implement and manage an analytics solution

A notebook writes a large Delta table that is almost always filtered on a TransDate column. Which write option creates a physical layout that lets queries skip irrelevant files?

  1. Setting mergeSchema to true during the write.
  2. Setting overwriteSchema to true during the write.
  3. Creating a log checkpoint after every ten commits.
  4. Partitioning the table by the TransDate column during the write. Correct answer.

Explanation

Partitioning stores rows in separate folders keyed by the column value, so a filter on that column reads only the relevant folders. Schema options and checkpoints affect table evolution and log handling, not data pruning.

Question 47Implement and manage an analytics solution

In which format does a Fabric lakehouse store its tables by default?

  1. Avro
  2. CSV
  3. Delta Parquet Correct answer.
  4. JSON

Explanation

Lakehouse tables are Delta Lake tables, meaning Parquet data files plus a transaction log. This format enables time travel, ACID guarantees, and Direct Lake reading by semantic models.

Question 48Implement and manage an analytics solution

What must a workspace be assigned to before the Fabric items it contains can run?

  1. A separate compute cluster for each item.
  2. A Fabric capacity, such as an F SKU, or a Fabric trial capacity. Correct answer.
  3. A Power BI Pro per-user license.
  4. An Azure subscription that includes a storage account.

Explanation

Fabric workloads consume compute from a capacity, so a workspace must be assigned to a Fabric capacity or a trial capacity. Per-user Power BI licenses govern access to Power BI experiences but do not supply Fabric compute.

Question 49Implement and manage an analytics solution

A team must ingest streaming telemetry, query it with KQL, and retain a year of history. Which Fabric item should they use?

  1. A mirrored database
  2. A lakehouse
  3. An eventhouse that contains a KQL database Correct answer.
  4. A warehouse

Explanation

An eventhouse hosts KQL databases that are optimized for high-volume ingestion and KQL queries over telemetry. Retention policies on the KQL database control how long data is kept.

Question 50Implement and manage an analytics solution

A developer needs Delta time travel on a table to be available for 60 days. Which table property should be increased?

  1. delta.minReaderVersion
  2. delta.logRetentionDuration Correct answer.
  3. delta.columnMapping.mode
  4. delta.appendOnly

Explanation

The log retention duration controls how long historical versions remain in the transaction log, and time travel depends on those versions. The files must also be retained, so VACUUM must not remove data older than the desired window.