Microsoft DP-700 Practice Test 2

Question 10

An analytics team has a stable workspace default Spark runtime, but one compatibility-test notebook must use a newer runtime and associated packages without changing other notebooks. Which TWO actions satisfy that requirement?

Create or configure a Fabric environment with the required supported runtime and package versions, and publish it.
Replace the workspace default environment with the test environment for every notebook.
Change only the test notebook’s default lakehouse.
Attach that published environment explicitly to the compatibility-test notebook and start a fresh session.
Assign the compatibility-test notebook to a separate Fabric domain while leaving its runtime selection unchanged.

Explanation

Correct Answers

An environment item isolates a chosen Spark runtime and libraries; publishing applies the configuration needed by a new session.

A notebook-level environment selection overrides Workspace default for that notebook, leaving other workloads on the original workspace setting.

Incorrect Answers

A workspace-wide switch would change unrelated notebooks using Workspace default, violating the requirement to isolate the test.

The default lakehouse controls which data is mounted; it does not select a Spark runtime or library set.

Domain association is a governance choice at workspace level, not a runtime override for a single notebook.

Question 11

One test notebook launches with an older Spark runtime while sibling notebooks use the upgraded workspace default. Its notebook-level environment was explicitly attached six months ago. What best explains the different runtime?

The explicit notebook environment selection takes precedence over the changed Workspace default.
Every notebook in a Fabric workspace must always use a single fixed runtime.
A Fabric domain assignment automatically pins notebook runtime versions.
The last lakehouse shortcut created in the workspace chooses the notebook runtime.

Explanation

Correct Answer

The notebook binds to its attached environment rather than inheriting Workspace default, so updating the default does not replace its explicitly selected runtime.

Incorrect Answers

Fabric permits supported per-notebook environments; differences are possible when item-level environment selection differs.

Domains organize governance and catalog discoverability; they do not choose a notebook Spark runtime.

Shortcuts control access to data in OneLake, not Spark runtime selection.

Question 12

A test notebook was intentionally assigned an environment with a newer Spark runtime. Which verification most directly demonstrates isolation from notebooks still using Workspace default?

Compare only the item labels on both notebooks.
Confirm both notebooks can write into the same OneLake Files directory.
Check that both notebooks have the same workspace domain.
Inspect the test notebook’s attached environment and effective runtime, then compare it with a fresh session started from Workspace default.

Explanation

Correct Answer

This directly measures whether the test workload uses its explicit configuration while ordinary workloads still resolve to the unchanged workspace default runtime.

Incorrect Answers

Sensitivity or descriptive labels do not show the effective Spark runtime version selected for execution.

Shared file-system access is compatible with different runtimes and therefore cannot prove the runtime is isolated.

Domain grouping is independent of notebook environment selection and says nothing about the runtime each session loaded.

Question 13

A developer uploads a new private wheel to a Fabric environment that is already attached to a scheduled notebook. The upcoming run must import the new version. What is the appropriate next step?

Only rename the wheel file to match the notebook name.
Save and publish the updated environment, then execute the notebook in a fresh session that uses it.
Move the notebook into a separate workspace domain.
Create a warehouse SQL view with the same name as the wheel.

Explanation

Correct Answer

The published library inventory, rather than an unsaved or uncommitted edit, governs installation in a new Spark session. Restarting prevents reuse of a session created before publication.

Incorrect Answers

Changing a filename does not publish an environment dependency or cause an existing Spark session to resolve a new package.

Domain assignments cannot publish private libraries or refresh the package environment loaded by a Spark session.

SQL views represent query logic and cannot install a Python wheel into a Fabric Spark environment.

Question 14

A Fabric environment displays a newly uploaded package in the editor, but a notebook session started earlier still imports the previous release. The engineer saved changes but never published. Which condition explains the mismatch?

The new library definition is not yet published, and the existing session has not reloaded a published version.
The workspace domain forces Python packages to be cached for 30 days.
OneLake requires the wheel to be written into a warehouse table first.
New versions of packages can only be made active by changing the workspace region.

Explanation

Correct Answer

Save and Publish are distinct operations. Pending library edits do not alter the active environment configuration, and long-running Spark sessions retain their loaded dependencies.

Incorrect Answers

Domain governance has no fixed package-cache policy that would explain an unpublished environment change.

Fabric environments manage custom library packages directly; a data warehouse table is not a supported prerequisite.

Publishing an environment and creating a new session is the relevant workflow; the region is not a publication switch.

Question 15

A team has published an updated Fabric environment and scheduled a new notebook run. Which observable result most directly confirms that the new custom wheel is active for the run?

Verify that a sensitivity label appears on the workspace.
Confirm the same lakehouse is mounted as before the update.
Read the audit log entry for the workspace creation date.
Inspect the new session’s attached environment and import the wheel to read its resolved package version or metadata.

Explanation

Correct Answer

A successful import of the expected version within the newly started Spark runtime confirms the library is actually resolved, not merely visible in an editor.

Incorrect Answers

A governance label cannot show the package build installed in the Spark session.

The lakehouse attachment may remain unchanged even if the environment library version differs.

Workspace creation evidence is unrelated to whether a specific newly published wheel is installed at runtime.

Question 16

An enterprise wants separate data domains for Retail and Finance. The existing Retail workspace is not associated with any domain. A Fabric domain administrator must make its items discoverable under Retail without relocating the workspace. What action meets this goal?

Rename every lakehouse item to begin with the word Retail.
Copy all Retail data into a new OneLake storage account.
Assign the existing Retail workspace to the Retail domain using Fabric domain assignment controls.
Change every employee to Workspace Admin in the Retail workspace.

Explanation

Correct Answer

A domain groups workspaces and their items logically. Assigning the workspace associates its contained Fabric items with that domain without moving the data into a new workspace.

Incorrect Answers

Naming conventions can help humans recognize assets, but they do not create the official workspace-to-domain association.

Domains are governance and discovery groupings; no physical OneLake copy is required for membership.

Broad administrative permissions are unnecessary and would create a security risk rather than establish domain organization.

Question 17

A Fabric admin creates a domain called Finance. Finance workspaces exist, but their items still appear outside that domain in the catalog. What is the most likely missing configuration?

The workspace lakehouse tables lack V-Order optimization.
The workspaces are missing a special Python runtime.
Each workspace must be recreated with Finance in its name.
The workspaces have not been assigned to the Finance domain.

Explanation

Correct Answer

Creating a domain does not automatically associate every matching workspace. The domain or an authorized contributor/admin must assign workspace membership.

Incorrect Answers

Delta file-layout optimization concerns query performance, not Fabric domain associations.

Domain catalog ownership does not depend on the Spark runtime used by notebooks.

Existing workspaces can be assigned to a domain; recreation is not a prerequisite.

Question 18

A domain administrator assigned a Finance workspace to the Finance Fabric domain. What should an auditor inspect to verify that the assignment affects catalog governance as intended?

Check the notebook’s Spark driver memory allocation.
Check the workspace’s effective domain association and verify its items appear under the Finance domain in the OneLake catalog.
Compare the number of rows in the Finance warehouse before and after assignment.
Inspect the Eventstream connector retry count.

Explanation

Correct Answer

The workspace membership and item discovery view directly show whether domain organization now applies to the existing assets.

Incorrect Answers

Spark session resources cannot establish governance-domain membership.

Domain assignment does not inherently alter warehouse data and row counts could remain identical.

Streaming retries are unrelated to where workspace items appear in the OneLake catalog.

Question 19

A business owner is the Admin of the Analytics workspace and must be allowed to associate that workspace with its Fabric domain, but must not administer tenant-wide settings. What is the least-privilege approach?

Grant the owner Fabric tenant Admin rights for all domains.
Make the owner a Warehouse database user only.
Give the owner a notebook Contributor role with no workspace administration.
Authorize the owner as a domain contributor, retaining their required workspace Admin role.

Explanation

Correct Answer

Domain contributors who are workspace admins can associate their own workspaces with a domain from workspace settings without receiving tenant-wide Fabric admin rights.

Incorrect Answers

Tenant-wide authority is broader than necessary for assigning a workspace they already administer.

Warehouse SQL privileges do not grant workspace-to-domain assignment rights.

Domain contributor assignment requires the principal to be an Admin of the workspace being associated.

Question 20

An authorized Fabric domain contributor can view the Analytics workspace but cannot assign it to a domain. The user has the workspace Member role, not Admin. Which limitation is responsible?

Only a KQL database administrator can assign Fabric workspaces to domains.
The user must publish an environment item before domain assignment is available.
A domain contributor must also have the Admin role in the workspace they want to assign.
Domain contributors can modify only workspaces containing exactly one lakehouse.

Explanation

Correct Answer

The two permissions serve different scopes: domain contributor authorization alone does not replace the required workspace administration privilege for assignment.

Incorrect Answers

KQL database permission controls Eventhouse data, not workspace-domain membership.

Spark environment publishing has no bearing on domain-contributor permission checks.

The documented requirement is the relevant workspace Admin role; membership is not restricted by a one-item rule.

Implementing Data Engineering Solutions Using Microsoft Fabric (DP-700) Practice Tests

Microsoft DP-700 Practice Test 1 - 10 Questions (Last Reviewed 03-Nov-2026)
Microsoft DP-700 Practice Test 2 - 10 Questions (Last Reviewed 02-Nov-2026)
Microsoft DP-700 Practice Test 3 - 10 Questions (Last Reviewed 01-Nov-2026)
Microsoft DP-700 Practice Test 4 - 10 Questions (Last Reviewed 31-Oct-2026)

Pass Your Microsoft DP-700 Exam Easy!

Question 10

Explanation

Correct Answers

Incorrect Answers

Question 11

Explanation

Correct Answer

Incorrect Answers

Question 12

Explanation

Correct Answer

Incorrect Answers

Question 13

Explanation

Correct Answer

Incorrect Answers

Question 14

Explanation

Correct Answer

Incorrect Answers

Question 15

Explanation

Correct Answer

Incorrect Answers

Question 16

Explanation

Correct Answer

Incorrect Answers

Question 17

Explanation

Correct Answer

Incorrect Answers

Question 18

Explanation

Correct Answer

Incorrect Answers

Question 19

Explanation

Correct Answer

Incorrect Answers

Question 20

Explanation

Correct Answer

Incorrect Answers

Implementing Data Engineering Solutions Using Microsoft Fabric (DP-700) Practice Tests