Microsoft DP-700 Practice Test 7
Question 60
A release introduces a new Spark runtime and must allow rollback. Which practice best preserves recovery?
- Replace the copied custom pool reference with a valid destination-workspace pool or starter pool.
- Publish and validate the environment on a test notebook before changing the default assignment.
- Pin the tested environment definition and retain a previous reviewed source revision for redeployment.
- Verify that the notebook is attached to the intended published environment in the target workspace.
Explanation
Correct Answer
C:Versioning the runtime and dependencies enables deliberate rollback to a known configuration rather than relying on memory of portal settings. Rebuild a test session from the prior approved revision.
Incorrect Answers
A:Custom Spark pools are workspace-scoped, so unchanged source pool identifiers may not exist in the promoted workspace.
B:A controlled test prevents unreviewed package versions from becoming the baseline for every new job.
D:A valid environment definition does not ensure every notebook references or inherits it correctly after promotion.
Question 61
A contractor must inspect reports but cannot create or edit workspace items. Which workspace role fits?
- Assign the Viewer workspace role.
- Assign the Admin workspace role to the contractor.
- Assign the Contributor workspace role to the contractor.
- Assign the Member workspace role to the contractor.
Explanation
Correct Answer
A:Viewer grants read-oriented workspace access while withholding Contributor authoring privileges. Check the contractor cannot modify a notebook.
Incorrect Answers
B:Admin allows workspace administration and membership management, contradicting least privilege for an observer. Such a change is legitimate for its own purpose, but a contractor must inspect reports but cannot create or edit workspace items.
C:Contributor grants editing and item creation abilities, so it is unnecessarily broad for a read-only contractor. The target requirement is different: a contractor must inspect reports but cannot create or edit workspace items.
D:Member has content authoring and sharing responsibilities that exceed the required inspect-only access.
Question 62
An engineer must create and edit notebooks but must not administer workspace membership. Which workspace role is appropriate?
- Assign the Admin workspace role to the engineer.
- Assign the Member workspace role to the engineer.
- Assign the Viewer workspace role to the engineer.
- Assign the Contributor workspace role.
Explanation
Correct Answer
D:Contributor supports item authoring without workspace member-management authority. Verify the engineer can create a notebook but not add members.
Incorrect Answers
A:Admin includes workspace management, deletion, and access administration, much more than notebook authoring. Such a change is legitimate for its own purpose, but an engineer must create and edit notebooks but must not administer workspace membership.
B:Member can author content but also grant members or lower-role workspace access; that exceeds the explicit restriction on administering membership. The target requirement is different: an engineer must create and edit notebooks but must not administer workspace membership.
C:Viewer is intended for observing content and does not grant the required notebook creation or editing rights.
Question 63
A team lead must edit and share content and add team members, without tenant or workspace deletion privileges. Which role best matches?
- Assign the Member workspace role.
- Assign the Viewer workspace role to the team lead.
- Assign the Contributor workspace role to the team lead.
- Assign the Admin workspace role to the team lead.
Explanation
Correct Answer
A:Member can modify and share items and manage some workspace membership, unlike Viewer and Contributor. Test the intended membership action with least privilege.
Incorrect Answers
B:Viewer cannot author and share items or add workspace members.
C:Contributor can author items but cannot grant new workspace members the required access.
D:Admin includes deleting the workspace and adding other admins, powers explicitly excluded by the scenario. The scenario, however, is that a team lead must edit and share content and add team members, without tenant or workspace deletion privileges.
Question 64
A platform administrator must delete a workspace and change administrator access. Which role is required?
- Elevate the analyst to Contributor only if the new authoring responsibility is approved.
- Assign the Admin workspace role to the authorized platform owner.
- Share the specific supported item with narrow item-level permissions.
- Grant only the data and item read permissions needed, not workspace Admin.
Explanation
Correct Answer
B:Workspace Admin is the role with broad management rights, including workspace deletion and administrator assignment. Confirm the admin operations are restricted to approved staff.
Incorrect Answers
A:Viewer does not authorize workspace item modification; Contributor is the least broad authoring role in the standard hierarchy.
C:Item permissions can expose an individual asset without adding the recipient to every workspace item.
D:Workspace management authority is broader than a data query requirement; separate permissions reduce impact from accidental changes.
Question 65
An analyst with Viewer access is asked to modify a data pipeline. What change grants appropriate authoring without administrator rights?
- Assign the Admin workspace role to the authorized platform owner.
- Elevate the analyst to Contributor only if the new authoring responsibility is approved.
- Share the specific supported item with narrow item-level permissions.
- Assign the Member workspace role.
Explanation
Correct Answer
B:Viewer does not authorize workspace item modification; Contributor is the least broad authoring role in the standard hierarchy. Record approval and test editing with the elevated account.
Incorrect Answers
A:Workspace Admin is the role with broad management rights, including workspace deletion and administrator assignment.
C:Item permissions can expose an individual asset without adding the recipient to every workspace item.
D:Member can modify and share items and manage some workspace membership, unlike Viewer and Contributor.
Question 66
A temporary external specialist needs one report but no broad workspace visibility. Which access model avoids a workspace role?
- Elevate the analyst to Contributor only if the new authoring responsibility is approved.
- Review the user's effective workspace permissions and remove unnecessary high-privilege membership.
- Share the specific supported item with narrow item-level permissions.
- Assign the Admin workspace role to the authorized platform owner.
Explanation
Correct Answer
C:Item permissions can expose an individual asset without adding the recipient to every workspace item. Check the specialist cannot enumerate unrelated items.
Incorrect Answers
A:Viewer does not authorize workspace item modification; Contributor is the least broad authoring role in the standard hierarchy.
B:A lower Viewer assignment does not neutralize stronger workspace permissions; overbroad membership should be corrected at the source.
D:Workspace Admin is the role with broad management rights, including workspace deletion and administrator assignment.
Question 67
Two groups receive Member and Viewer roles on the same workspace through separate assignments. Which issue should be evaluated?
- Share the specific supported item with narrow item-level permissions.
- Assign the Viewer workspace role.
- Assign the Contributor workspace role.
- Review the user's effective workspace permissions and remove unnecessary high-privilege membership.
Explanation
Correct Answer
D:A lower Viewer assignment does not neutralize stronger workspace permissions; overbroad membership should be corrected at the source. Test the user's effective ability to edit and share.
Incorrect Answers
A:Item permissions can expose an individual asset without adding the recipient to every workspace item.
B:Viewer grants read-oriented workspace access while withholding Contributor authoring privileges.
C:Contributor supports item authoring without workspace member-management authority.
Question 68
A trainee requests admin rights merely to read lakehouse results. What is the safer first decision?
- Grant only the data and item read permissions needed, not workspace Admin.
- Elevate the analyst to Contributor only if the new authoring responsibility is approved.
- Review the user's effective workspace permissions and remove unnecessary high-privilege membership.
- Assign the Member workspace role.
Explanation
Correct Answer
A:Workspace management authority is broader than a data query requirement; separate permissions reduce impact from accidental changes. Check required queries work while administration remains unavailable.
Incorrect Answers
B:Viewer does not authorize workspace item modification; Contributor is the least broad authoring role in the standard hierarchy.
C:A lower Viewer assignment does not neutralize stronger workspace permissions; overbroad membership should be corrected at the source.
D:Member can modify and share items and manage some workspace membership, unlike Viewer and Contributor.
Question 69
A vendor needs one warehouse query surface but should not browse every workspace item. How should access be scoped?
- Check the warehouse's data-plane SQL permissions rather than only workspace visibility.
- Provide report-consumption permissions without unnecessary direct OneLake file grants.
- Grant the appropriate underlying OneLake permission only when direct data access is required.
- Grant the vendor the necessary item-level access plus the supported query-data permission.
Explanation
Correct Answer
D:Item sharing and data query rights are separable; workspace-wide roles are unnecessary for a single item. Test the query with the vendor identity and inspect unrelated item visibility.
Incorrect Answers
A:Object listing is not the same as data access; SQL permissions determine allowed table operations for the identity.
B:Artifact consumption and underlying file access are independent; broad data grants can leak information beyond the approved report.
C:Read access to a report's metadata or rendered visuals does not automatically authorize direct reads of its underlying files.
Question 70
A report is shared to a stakeholder but its Direct Lake data cannot be queried directly from OneLake. What should be explained?
- Grant access to the relevant supported item and dataset without a general workspace membership.
- Grant the vendor the necessary item-level access plus the supported query-data permission.
- Grant the appropriate underlying OneLake permission only when direct data access is required.
- Use the pipeline's supported item execution permission rather than broad workspace edit rights.
Explanation
Correct Answer
C:Read access to a report's metadata or rendered visuals does not automatically authorize direct reads of its underlying files. Attempt a direct OneLake read using the stakeholder identity.
Incorrect Answers
A:Item-scoped permission avoids visibility and editing of unrelated jobs and assets.
B:Item sharing and data query rights are separable; workspace-wide roles are unnecessary for a single item.
D:Execute and Write are distinct item-level capabilities where supported; editing permission is unnecessary merely to run a job.
