Microsoft DP-700 Practice Test 1
Question 1
A team needs eight Spark notebooks to run with identical package versions without repeating notebook-level installations. Which configuration best centralizes this dependency?
- Attach a dedicated environment with suitable compute configuration to that notebook only.
- Create and publish a reusable Fabric environment with the required libraries and attach it to those notebooks.
- Right-size Spark resource-profile inputs to typical data volume and intended workload.
- Use Spark settings resource-profile recommendations for the write-heavy bronze use case and expected data volume.
Explanation
Correct Answer
B:Environment items supply governed Spark libraries and session configuration to multiple notebooks; a published environment avoids ad hoc dependencies. Run two attached notebooks and compare the resolved package versions.
Incorrect Answers
A:Per-item environment selection is useful when one notebook needs a separate Spark configuration. It does not centrally manage matching library versions across the eight notebooks in this question; they need one published reusable Fabric environment.
C:Spark resource-profile sizing is about matching compute to workload and data volume. It does not publish a common set of library versions for the eight notebooks, so it cannot satisfy their shared package-dependency requirement.
D:A bronze-workload resource profile recommends Spark compute settings for ingestion characteristics. The requested common package versions are a library-and-environment governance problem rather than a write-heavy compute-sizing problem.
Question 2
A bronze ingestion workspace runs mostly write-heavy Spark jobs on moderate data. Which workspace-level tuning approach fits its workload rather than assuming a read-optimized profile?
- Publish the environment changes and start a new Spark session that uses the published configuration.
- Create a common environment item and enable it as the default environment for workspace Spark workloads.
- Attach a dedicated environment with suitable compute configuration to that notebook only.
- Use Spark settings resource-profile recommendations for the write-heavy bronze use case and expected data volume.
Explanation
Correct Answer
D:Fabric resource profiles recommend Spark compute settings from declared workload characteristics; bronze ingestion is not interchangeable with selective reporting queries. Measure throughput and capacity consumption on a representative load.
Incorrect Answers
A:Publishing an environment activates staged library configuration for new Spark sessions. This is not a method of choosing Spark resource-profile settings for a write-heavy bronze workload; the question asks for workload-based compute tuning at workspace level.
B:A workspace default environment distributes a common runtime and libraries to jobs that inherit it. That solves dependency consistency, whereas this bronze ingestion case calls for a Spark resource profile chosen for write-heavy processing and measured data volume.
C:A dedicated notebook environment isolates one Spark job's compute settings without changing other notebooks. The requested decision is workspace-level tuning for the bronze ingestion workload, not per-notebook isolation.
Question 3
A single memory-intensive notebook must use larger executors while unrelated jobs keep their existing defaults. What should the engineer change?
- Create and publish a reusable Fabric environment with the required libraries and attach it to those notebooks.
- Use Spark settings resource-profile recommendations for the write-heavy bronze use case and expected data volume.
- Attach a dedicated environment with suitable compute configuration to that notebook only.
- Publish the environment changes and start a new Spark session that uses the published configuration.
Explanation
Correct Answer
C:Per-item environment selection scopes Spark compute differences without destabilizing the entire workspace default for other workloads. Confirm the notebook session is launched with the selected environment.
Incorrect Answers
A:Environment items supply governed Spark libraries and session configuration to multiple notebooks; a published environment avoids ad hoc dependencies.
B:Fabric resource profiles recommend Spark compute settings from declared workload characteristics; bronze ingestion is not interchangeable with selective reporting queries.
D:Editing a Fabric environment alone changes its staging state; publishing and an appropriately restarted session are required to use the new package version.
Question 4
New notebooks should inherit one tested Spark runtime and dependency baseline without requiring authors to select it each time. What should the workspace admin do?
- Create and publish a reusable Fabric environment with the required libraries and attach it to those notebooks.
- Right-size Spark resource-profile inputs to typical data volume and intended workload.
- Set the approved Fabric environment as the workspace default in Spark settings.
- Publish the environment changes and start a new Spark session that uses the published configuration.
Explanation
Correct Answer
C:A workspace default environment provides the common runtime and libraries when notebooks select Workspace default; it is distinct from manually changing each notebook. Create a new notebook and inspect the inherited environment.
Incorrect Answers
A:Environment items supply governed Spark libraries and session configuration to multiple notebooks; a published environment avoids ad hoc dependencies.
B:Pool sizing should reflect workload characteristics rather than maximizing resources; oversized sessions can waste capacity without improving short jobs.
D:Editing a Fabric environment alone changes its staging state; publishing and an appropriately restarted session are required to use the new package version.
Question 5
A library update is saved in a Fabric environment but running notebooks still use the old package. Which lifecycle step is missing?
- Create a common environment item and enable it as the default environment for workspace Spark workloads.
- Use Spark settings resource-profile recommendations for the write-heavy bronze use case and expected data volume.
- Publish the environment changes and start a new Spark session that uses the published configuration.
- Right-size Spark resource-profile inputs to typical data volume and intended workload.
Explanation
Correct Answer
C:Editing a Fabric environment alone changes its staging state; publishing and an appropriately restarted session are required to use the new package version. Inspect the published libraries in a fresh notebook session.
Incorrect Answers
A:An environment-backed workspace default supports consistent libraries and runtime across notebooks and Spark job definitions that inherit the default.
B:Fabric resource profiles recommend Spark compute settings from declared workload characteristics; bronze ingestion is not interchangeable with selective reporting queries.
D:Pool sizing should reflect workload characteristics rather than maximizing resources; oversized sessions can waste capacity without improving short jobs.
Question 6
A data scientist has unique experimental packages and must not alter the default used by production notebooks. What is the appropriate isolation?
- Create and publish a reusable Fabric environment with the required libraries and attach it to those notebooks.
- Select a dedicated per-notebook environment for the experimental workload.
- Right-size Spark resource-profile inputs to typical data volume and intended workload.
- Use Spark settings resource-profile recommendations for the write-heavy bronze use case and expected data volume.
Explanation
Correct Answer
B:A notebook-specific environment isolates library and compute settings from the workspace default, preventing an experiment from silently changing production jobs. Compare the notebook environment assignment with production notebooks.
Incorrect Answers
A:Environment items supply governed Spark libraries and session configuration to multiple notebooks; a published environment avoids ad hoc dependencies.
C:Pool sizing should reflect workload characteristics rather than maximizing resources; oversized sessions can waste capacity without improving short jobs.
D:Fabric resource profiles recommend Spark compute settings from declared workload characteristics; bronze ingestion is not interchangeable with selective reporting queries.
Question 7
A team repeatedly consumes capacity with oversized Spark sessions for tiny daily jobs. Which setting should they revisit first?
- Right-size Spark resource-profile inputs to typical data volume and intended workload.
- Set the approved Fabric environment as the workspace default in Spark settings.
- Create a common environment item and enable it as the default environment for workspace Spark workloads.
- Create and publish a reusable Fabric environment with the required libraries and attach it to those notebooks.
Explanation
Correct Answer
A:Pool sizing should reflect workload characteristics rather than maximizing resources; oversized sessions can waste capacity without improving short jobs. Compare job completion and CU use before and after the sizing change.
Incorrect Answers
B:A workspace default environment provides the common runtime and libraries when notebooks select Workspace default; it is distinct from manually changing each notebook.
C:An environment-backed workspace default supports consistent libraries and runtime across notebooks and Spark job definitions that inherit the default.
D:Environment items supply governed Spark libraries and session configuration to multiple notebooks; a published environment avoids ad hoc dependencies.
Question 8
A workspace default uses Spark settings but the team expects one version-controlled environment to govern both notebooks and Spark job definitions. What should be configured?
- Select a dedicated per-notebook environment for the experimental workload.
- Use Spark settings resource-profile recommendations for the write-heavy bronze use case and expected data volume.
- Publish the environment changes and start a new Spark session that uses the published configuration.
- Create a common environment item and enable it as the default environment for workspace Spark workloads.
Explanation
Correct Answer
D:An environment-backed workspace default supports consistent libraries and runtime across notebooks and Spark job definitions that inherit the default. Verify that both item types resolve the same published environment.
Incorrect Answers
A:A notebook-specific environment isolates library and compute settings from the workspace default, preventing an experiment from silently changing production jobs.
B:Fabric resource profiles recommend Spark compute settings from declared workload characteristics; bronze ingestion is not interchangeable with selective reporting queries.
C:Editing a Fabric environment alone changes its staging state; publishing and an appropriately restarted session are required to use the new package version.
Question 9
Finance teams cannot find certified finance assets among hundreds of workspaces and need a business ownership grouping. Which Fabric feature organizes their discovery boundary?
- Designate domain administrators or owners with responsibility for that domain.
- Reassign the workspace to the proper domain in Fabric domain management.
- Organize the subsidiary under a subdomain within the existing domain hierarchy.
- Assign the relevant workspaces to a Finance domain with appropriate domain ownership.
Explanation
Correct Answer
D:Domains group workspace assets around a business subject and stewardship model, improving catalog navigation without converting them into data-security roles. Check that the workspaces appear under the expected OneLake catalog domain.
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:A domain hierarchy provides structured subject-area grouping while preserving parent governance context instead of creating unrelated duplicate assets.
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?
- Create a Product domain and assign the approved domain administrators.
- Keep the domain for governance and implement separate row-level data controls for restricted records.
- Manage actual workspace, item, and data permissions separately from the Finance domain classification.
- 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.
