DP-700 Practice Test

Sample DP-700 Practice Questions

10 real questions from the free DP-700bank. Pick an answer in your head, then open “Show answer” for the explanation.

1. 1. A data engineer without the workspace Admin role wants to change the default Spark pool used by notebooks in a workspace. What happens when they try to open Spark settings in Workspace settings?

   • A. They can view but not modify Spark Compute settings, since changing Spark settings for a workspace requires the Admin role
   • B. They can freely change the default pool, since Spark settings are open to workspace roles
   • C. They can change the default pool if they are a Contributor, but not if they are a Member
   • D. They can change the default pool during active Spark sessions
   Show answer

   Correct answer: A

   Making changes to Spark settings in a workspace requires the Admin role for that workspace. Option B is incorrect since access is role-restricted, not open to everyone. Option C inverts the actual requirement - Contributor is a lower privilege than Member, and neither has this right without Admin. Option D describes no real Fabric restriction tied to active sessions.

2. 2. A domain admin for the Marketing domain wants to rename the domain and add a colleague as a second domain admin. Can the domain admin perform both actions themselves?

   • A. No, a domain admin can update the domain description and manage contributors and settings delegation, but cannot rename the domain or add other domain admins
   • B. Yes, domain admins have full control equivalent to a Fabric admin over their own domain
   • C. No, domain admins cannot make any changes to their domain at without Fabric admin approval
   • D. Yes, but the rename is allowed; adding domain admins is blocked permanently by design
   Show answer

   Correct answer: A

   Domain admins can update the domain description, define or update domain contributors, associate workspaces, and override delegated tenant settings, but they cannot delete the domain, change the domain name, or add or delete other domain admins - those require a Fabric admin. Option B overstates domain admin authority. Option C understates it, since domain admins clearly can make several categories of changes. Option D is incorrect about the rename half of the claim, since renaming is one of the actions domain admins cannot perform.

3. 3. A team enables shortcut caching for an Amazon S3 shortcut and sets the retention period to 28 days to minimize cross-cloud egress costs. One file in the shortcut's source is 1.5 GB. What happens to that specific file with respect to caching?

   • A. It is cached but for 1 day regardless of the configured retention setting
   • B. It is cached if the workspace is assigned to a Trial capacity
   • C. It is not cached, because individual files greater than 1 GB in size are excluded from shortcut caching regardless of the configured retention period
   • D. It is cached normally, since the 28-day retention period overrides the file-size exclusion
   Show answer

   Correct answer: C

   Shortcut caching explicitly excludes individual files greater than 1 GB in size from being cached, regardless of the retention period configured. Option D incorrectly assumes retention period can override the size exclusion - it cannot. Option A invents a forced 1-day retention that has no basis in the caching design. Option B fabricates a capacity-tier dependency unrelated to the file-size exclusion rule.

4. 4. An engineer creates a new Fabric connection with Workspace identity authentication for a Notebook resource, intending to let Airflow DAGs (a code-first artifact) use that connection, but forgets to select the Allow Code-First Artifacts checkbox during creation. After the fact, they try to edit the connection to enable that option. What happens?

   • A. The checkbox can be toggled at any time from the connection's settings page with no other impact
   • B. The connection automatically enables the checkbox the first time an Airflow DAG attempts to use it
   • C. A Fabric admin, not the connection owner, can retroactively enable this checkbox
   • D. The option cannot be changed after the connection is created, so the engineer must create a new connection with the checkbox selected from the start
   Show answer

   Correct answer: D

   The Allow Code-First Artifacts checkbox must be selected during connection creation and cannot be changed afterward, since Apache Airflow is a code-first artifact and this setting is fixed at creation time - the engineer must create a new connection instead. Option A contradicts the documented immutability of this setting after creation. Option B invents automatic self-correcting behavior that does not exist. Option C is also incorrect, since the constraint is that the setting can't be changed post-creation by anyone, not merely restricted to non-admins.

5. 5. A team ingests data through a OneLake shortcut pointing at an ADLS Gen2 account in the same Azure region, and wants to enable shortcut caching to reduce read costs. At the same time, compliance requires that this specific dataset never be served from a cached copy more than 24 hours old, since the source table is corrected intraday. The team is debating whether tuning shortcut caching's retention period can satisfy both the cost-reduction goal and the 24-hour freshness requirement for this shortcut. What should they conclude?

   • A. Yes - enable caching with the full 28-day retention period, which maximizes cost-saving reuse, and accept that reads may occasionally serve data up to 28 days old
   • B. Yes - enable caching with the minimum 1-day retention period, which keeps served data within the freshness requirement, even though it captures less cost-saving reuse than a longer window
   • C. No - OneLake shortcut caching has a minimum retention period of 90 days, which would violate the 24-hour freshness requirement no matter how the setting is configured
   • D. Neither goal is reachable through caching here, because ADLS shortcuts are not among OneLake's supported caching source types (GCS, S3, S3-compatible, and on-premises gateway shortcuts), so the team should evaluate other cost controls
   Show answer

   Correct answer: D

   ADLS shortcuts are not included in OneLake's supported shortcut-caching source types at all, so no retention-period tuning changes that outcome, and the cost-versus-freshness tradeoff never actually arises for this specific shortcut. Option A assumes caching applies and picks the retention value that favors cost savings, which would violate the 24-hour freshness requirement if caching were actually available. Option B assumes caching applies and picks the retention value that favors freshness, but tuning retention is moot here since ADLS shortcuts do not support caching regardless of the value chosen. Option C invents an incorrect 90-day minimum retention figure for shortcut caching, confusing it with OneLake lifecycle management's unrelated cold-tier minimum retention period.