cert
cert-1
cert-2

Pass Microsoft DP-700 Exam in First Attempt Guaranteed!

Get 100% Latest Exam Questions, Accurate & Verified Answers to Pass the Actual Exam!
30 Days Free Updates, Instant Download!

cert-5
cert-6
DP-700 Exam - Verified By Experts
DP-700 Premium Bundle
$14.99

DP-700 Premium Bundle

$74.99
$89.98
  • Premium File 160 Questions & Answers. Last update: Nov 10, 2026
  • Training Course 160 Video Lectures
 
$89.98
$74.99
accept 159 downloads in last 7 days
block-screenshots
Purchase Microsoft DP-700 Exam Training Products Individually
Microsoft DP-700 Premium File
Premium File 160 Q&A
$76.99$69.99
Microsoft DP-700 Video Training Course
Training Course 160 Lectures
$21.99 $19.99
Microsoft DP-700 Practice Test 2

Question 10

A new product division needs its own catalog governance owner while retaining the central tenant's platform admins. Which configuration targets that responsibility?

  1. Create a Product domain and assign the approved domain administrators.
  2. Keep the domain for governance and implement separate row-level data controls for restricted records.
  3. Manage actual workspace, item, and data permissions separately from the Finance domain classification.
  4. Assign the relevant workspaces to a Finance domain with appropriate domain ownership.

Explanation

Correct Answer

A:

Domain administration delegates governance and organization for a business area; it does not require tenant-wide Fabric administrator privileges. Validate the domain administrator can manage the assigned domain.

Incorrect Answers

B:

Subject-area catalog grouping does not evaluate a user's row-level entitlements; a security rule must be enforced at a supported data access layer.

C:

Separating underlying workspace and data permissions is important because catalog domains do not themselves grant record access. It does not assign the business stewardship that this new Product domain needs; that requires approved domain administrators.

D:

Assigning workspaces to a Finance domain helps classify their assets and ownership context. It does not establish the Product division's separate governance administrator while preserving tenant-level platform administration.

Question 11

An analytics workspace is listed under the wrong subject area in the catalog. What change corrects its business classification?

  1. Organize the subsidiary under a subdomain within the existing domain hierarchy.
  2. Assign the relevant workspaces to a Finance domain with appropriate domain ownership.
  3. Create a Product domain and assign the approved domain administrators.
  4. Reassign the workspace to the proper domain in Fabric domain management.

Explanation

Correct Answer

D:

Workspace-domain association determines business organization and discoverability; renaming the workspace does not correct its domain membership. Confirm the domain workspace listing reflects the move.

Incorrect Answers

A:

A domain hierarchy provides structured subject-area grouping while preserving parent governance context instead of creating unrelated duplicate assets.

B:

Domains group workspace assets around a business subject and stewardship model, improving catalog navigation without converting them into data-security roles.

C:

Domain administration delegates governance and organization for a business area; it does not require tenant-wide Fabric administrator privileges.

Question 12

A subsidiary's datasets should be discoverable through a distinct subarea of an existing corporate domain. Which governance structure is most suitable?

  1. Manage actual workspace, item, and data permissions separately from the Finance domain classification.
  2. Organize the subsidiary under a subdomain within the existing domain hierarchy.
  3. Normalize workspace-to-domain assignments according to the approved business taxonomy.
  4. Designate domain administrators or owners with responsibility for that domain.

Explanation

Correct Answer

B:

A domain hierarchy provides structured subject-area grouping while preserving parent governance context instead of creating unrelated duplicate assets. Inspect the resulting parent and child domain tree.

Incorrect Answers

A:

Domains are organizational and governance constructs; they do not automatically grant underlying table or file access to every domain viewer.

C:

A consistent domain taxonomy reduces fragmented discovery; changing dataset permissions or capacities does not by itself correct a misclassified catalog entry.

D:

Domain governance requires explicit stewardship, which differs from giving every steward workspace administrator access to all data items.

Question 13

A user assumes a Finance domain grants permission to read every Finance lakehouse. What should the architect establish?

  1. Assign the relevant workspaces to a Finance domain with appropriate domain ownership.
  2. Manage actual workspace, item, and data permissions separately from the Finance domain classification.
  3. Organize the subsidiary under a subdomain within the existing domain hierarchy.
  4. Reassign the workspace to the proper domain in Fabric domain management.

Explanation

Correct Answer

B:

Domains are organizational and governance constructs; they do not automatically grant underlying table or file access to every domain viewer. Test a nonprivileged identity against the targeted data path.

Incorrect Answers

A:

Domains group workspace assets around a business subject and stewardship model, improving catalog navigation without converting them into data-security roles.

C:

A domain hierarchy provides structured subject-area grouping while preserving parent governance context instead of creating unrelated duplicate assets.

D:

Workspace-domain association determines business organization and discoverability; renaming the workspace does not correct its domain membership.

Question 14

The catalog presents two marketing workspaces in different business domains, confusing discovery and stewardship. What should the data owner review?

  1. Normalize workspace-to-domain assignments according to the approved business taxonomy.
  2. Keep the domain for governance and implement separate row-level data controls for restricted records.
  3. Assign the relevant workspaces to a Finance domain with appropriate domain ownership.
  4. Organize the subsidiary under a subdomain within the existing domain hierarchy.

Explanation

Correct Answer

A:

A consistent domain taxonomy reduces fragmented discovery; changing dataset permissions or capacities does not by itself correct a misclassified catalog entry. Review both workspaces in the intended domain view.

Incorrect Answers

B:

Subject-area catalog grouping does not evaluate a user's row-level entitlements; a security rule must be enforced at a supported data access layer.

C:

Domains group workspace assets around a business subject and stewardship model, improving catalog navigation without converting them into data-security roles.

D:

A domain hierarchy provides structured subject-area grouping while preserving parent governance context instead of creating unrelated duplicate assets.

Question 15

A new domain exists but no business steward can maintain its settings. What must be assigned?

  1. Reassign the workspace to the proper domain in Fabric domain management.
  2. Organize the subsidiary under a subdomain within the existing domain hierarchy.
  3. Designate domain administrators or owners with responsibility for that domain.
  4. Normalize workspace-to-domain assignments according to the approved business taxonomy.

Explanation

Correct Answer

C:

Domain governance requires explicit stewardship, which differs from giving every steward workspace administrator access to all data items. Test domain management with the steward's authorized account.

Incorrect Answers

A:

Workspace-domain association determines business organization and discoverability; renaming the workspace does not correct its domain membership.

B:

A domain hierarchy provides structured subject-area grouping while preserving parent governance context instead of creating unrelated duplicate assets.

D:

A consistent domain taxonomy reduces fragmented discovery; changing dataset permissions or capacities does not by itself correct a misclassified catalog entry.

Question 16

An auditor asks whether a catalog domain is a secure substitute for lakehouse row filters. How should the team respond?

  1. Designate domain administrators or owners with responsibility for that domain.
  2. Reassign the workspace to the proper domain in Fabric domain management.
  3. Assign the relevant workspaces to a Finance domain with appropriate domain ownership.
  4. Keep the domain for governance and implement separate row-level data controls for restricted records.

Explanation

Correct Answer

D:

Subject-area catalog grouping does not evaluate a user's row-level entitlements; a security rule must be enforced at a supported data access layer. Query restricted rows as two users with different entitlements.

Incorrect Answers

A:

Domain governance requires explicit stewardship, which differs from giving every steward workspace administrator access to all data items.

B:

Workspace-domain association determines business organization and discoverability; renaming the workspace does not correct its domain membership.

C:

Domains group workspace assets around a business subject and stewardship model, improving catalog navigation without converting them into data-security roles.

Question 17

A data engineering workspace repeatedly reads an Amazon S3 shortcut and wants to reduce repeated cross-cloud retrieval costs. Which workspace-level setting should be considered?

  1. Enable Spark DataFrame caching in each notebook that reads the shortcut.
  2. Enable supported OneLake shortcut caching in workspace settings and select a justified retention period.
  3. Stage the S3 data with an extra scheduled Dataflow Gen2 copy into the lakehouse.
  4. Increase the parallel read requests that the S3 connection makes for each Spark job.

Explanation

Correct Answer

B:

Workspace OneLake caching stores eligible external shortcut files locally for subsequent reads and may reduce repeat egress. Compare remote fetches and cache utilization for repeated reads of a test file.

Incorrect Answers

A:

Spark DataFrame caching accelerates reuse within a Spark application, but is not the workspace OneLake shortcut cache shared across subsequent remote-file reads.

C:

A separate materialized copy can be useful for an ETL design but adds ingestion and storage rather than activating the existing shortcut's workspace cache. In the current incident, a data engineering workspace repeatedly reads an Amazon S3 shortcut and wants to reduce repeated cross-cloud retrieval costs.

D:

Increasing parallel source calls may improve a single load while leaving repeat cross-cloud transfers and their egress costs in place. Those effects are relevant to a different technical condition. In this case, a data engineering workspace repeatedly reads an Amazon S3 shortcut and wants to reduce repeated cross-cloud retrieval costs.

Question 18

A team must grant Read access to /Files/Reports and all nested date folders without granting access to unrelated sibling folders. Where should the OneLake security role be scoped?

  1. Assign a scoped OneLake ReadWrite role on the target folder, with necessary item read permissions.
  2. Enable supported OneLake shortcut caching in workspace settings and select a justified retention period.
  3. Grant Read access on the lakehouse root so all sibling folders inherit access along with Reports.
  4. Grant OneLake security access at the parent Reports folder so descendant paths inherit it.

Explanation

Correct Answer

D:

Grant OneLake Read access at /Files/Reports and rely on the supported folder inheritance for its date subfolders. Test an existing and newly created descendant, and confirm the user cannot read an unrelated sibling directory.

Incorrect Answers

A:

ReadWrite roles can grant scoped writes to otherwise read-only users; granting Contributor for the whole workspace would be unnecessarily broad. OneLake folder permissions flow downward to children; the grant need not be copied manually to each new date subfolder. Verify access to both existing and newly created child paths.

B:

Workspace OneLake caching stores eligible external shortcut files locally for subsequent reads and may reduce repeat egress. OneLake folder permissions flow downward to children; the grant need not be copied manually to each new date subfolder. Verify access to both existing and newly created child paths.

C:

A grant at the /Files root would also make sibling directories accessible, exceeding the requested Reports-only access scope. Grant the role on Reports so its descendants inherit the permission, then test that an unrelated sibling remains inaccessible.

Question 19

An external data shortcut is visible in a lakehouse, but a viewer is denied when reading its contents. What must be verified?

  1. Enable supported OneLake shortcut caching in workspace settings and select a justified retention period.
  2. Grant the viewer a broad workspace Contributor role without examining the restricted shortcut or underlying external source access.
  3. Check both OneLake role access to the shortcut and the external connection's source credentials.
  4. Use a Read-only role for row or column security and separate permitted write access appropriately.

Explanation

Correct Answer

C:

A visible shortcut is a reference, not a bypass of external storage authorization or Fabric data permissions. Test the shortcut path and connection credential independently.

Incorrect Answers

A:

Workspace OneLake caching stores eligible external shortcut files locally for subsequent reads and may reduce repeat egress.

B:

Contributor may be unnecessarily broad and cannot substitute for verifying both OneLake authorization and an external source connection with valid credentials. Test the shortcut path and connection credential independently.

D:

OneLake roles with ReadWrite cannot contain RLS or CLS restrictions, so the design cannot rely on that combination in one role.

Question 20

A user may read one child folder but should not gain access to its sibling folder. What OneLake behavior enables navigation safely?

  1. Assess the union of grants from both roles, after each role's own restrictions are evaluated.
  2. Enable supported OneLake shortcut caching in workspace settings and select a justified retention period.
  3. Assign a scoped OneLake ReadWrite role on the target folder, with necessary item read permissions.
  4. Allow parent traversal for the permitted child without granting sibling data access.

Explanation

Correct Answer

D:

OneLake can expose enough ancestor listing to reach an authorized child while retaining data restrictions on unrelated sibling paths. Validate that sibling file reads still fail.

Incorrect Answers

A:

OneLake uses grant-based role composition; a narrower role does not globally deny data allowed by a separate broader role.

B:

Workspace shortcut caching can reduce repeated remote reads, but it does not grant permission to traverse an allowed child folder or protect sibling folders. The stated problem is ancestor navigation with strict sibling access boundaries.

C:

A scoped ReadWrite role controls where a user can edit files; it is not required merely to traverse ancestors toward an authorized child. Preserve the child's read permission and avoid granting data rights to its siblings.

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