Microsoft PL-200 Exam Dumps, Practice Test Questions

100% Latest & Updated Microsoft PL-200 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!

Microsoft PL-200 Premium Bundle
$64.98
$54.98

PL-200 Premium Bundle

  • Premium File: 328 Questions & Answers. Last update: Nov 5, 2026
  • Training Course: 94 Video Lectures
  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates

PL-200 Premium Bundle

Microsoft PL-200 Premium Bundle
  • Premium File: 328 Questions & Answers. Last update: Nov 5, 2026
  • Training Course: 94 Video Lectures
  • Latest Questions
  • 100% Accurate Answers
  • Fast Exam Updates
$64.98
$54.98

Microsoft PL-200 Practice Test 13

Question 120

Department staff should automatically gain and lose team-based access as directory membership changes; the current team is manually maintained. Select THREE case-specific measures covering remediation, proof and longer-term prevention.

  1. Correct Dataverse role and record privileges first, then configure searchable tables and fields.
  2. Choose ownership model at design time because it constrains later security options.
  3. Test read behavior for unrelated business units and confirm no owner-dependent filters are needed.
  4. Treat directory group ownership and periodic access review as part of the authorization design.
  5. Use a supported Microsoft Entra ID group team with roles aligned to the directory group.
  6. Remove a pilot user from the directory group and verify effective Dataverse access updates after propagation.

Explanation

Correct Answers

D:

Treat directory group ownership and periodic access review as part of the authorization design. This reduces recurrence of: A manually maintained team can lag behind the identity source and retain stale members.

E:

Use a supported Microsoft Entra ID group team with roles aligned to the directory group. This directly addresses: A manually maintained team can lag behind the identity source and retain stale members.

F:

Remove a pilot user from the directory group and verify effective Dataverse access updates after propagation. This is required evidence before closure.

Incorrect Answers

A:

That approach is designed for search index leakage test: Search visibility and record authorization are distinct; hiding a search box is not an access control. The present case instead involves a manually maintained team can lag behind the identity source and retain stale members.

B:

The proposed step addresses table ownership mismatch, not the constraint in this scenario. The decisive issue is that a manually maintained team can lag behind the identity source and retain stale members.

C:

This would respond to a different requirement (table ownership mismatch). It does not establish the needed result here: remove a pilot user from the directory group and verify effective Dataverse access updates after propagation.

Question 121

HR agents may read employee names but must not view or change a salary column; current table role grants record read. What is the most directly supported diagnosis?

  1. Table-level Read privileges do not independently restrict an individual sensitive column.
  2. A flat role with organization-wide privileges would disclose peers' cases beyond the chain of command.
  3. Organization-level privilege depth overrides the intended branch visibility boundary.
  4. Retaining orphaned disposable drafts would leave invalid unrelated child rows.

Explanation

Correct Answer

A:

Enable column security and assign a column-security profile with appropriate read and update permissions. The observed cause is: Table-level Read privileges do not independently restrict an individual sensitive column.

Incorrect Answers

B:

This would respond to a different requirement (manager hierarchy visibility). It does not establish the needed result here: table-level Read privileges do not independently restrict an individual sensitive column.

C:

That choice can be relevant to business unit access boundary, but its assumptions are absent from this case. Here the direct diagnosis is table-level Read privileges do not independently restrict an individual sensitive column.

D:

The proposed step addresses cascade delete for disposable children, not the constraint in this scenario. The decisive issue is that table-level Read privileges do not independently restrict an individual sensitive column.

Question 122

HR agents may read employee names but must not view or change a salary column; current table role grants record read. What should the consultant configure to correct the observed behavior?

  1. Use a supported Microsoft Entra ID group team with roles aligned to the directory group.
  2. Add Create at the narrowest appropriate depth and confirm any required related-table privileges.
  3. Share only the approved row with the investigator or qualifying team using limited privileges.
  4. Enable column security and assign a column-security profile with appropriate read and update permissions.

Explanation

Correct Answer

D:

Enable column security and assign a column-security profile with appropriate read and update permissions. This addresses: Table-level Read privileges do not independently restrict an individual sensitive column.

Incorrect Answers

A:

The proposed step addresses entra group membership changes, not the constraint in this scenario. The decisive issue is that table-level Read privileges do not independently restrict an individual sensitive column.

B:

That choice can be relevant to role privilege for create, but its assumptions are absent from this case. Here the direct corrective action is enable column security and assign a column-security profile with appropriate read and update permissions.

C:

Applying this would shift attention to sharing one exceptional row without testing the actual fault. Table-level Read privileges do not independently restrict an individual sensitive column.

Question 123

HR agents may read employee names but must not view or change a salary column; current table role grants record read. What test would most clearly distinguish a successful fix from a superficial change?

  1. Test salary visibility and edit rights as HR, non-HR and administrator users using actual records.
  2. Share a test account and verify related private cases are not automatically readable.
  3. Log in as users from two branches and verify each sees only the permitted case rows.
  4. Test read behavior for unrelated business units and confirm no owner-dependent filters are needed.

Explanation

Correct Answer

A:

Test salary visibility and edit rights as HR, non-HR and administrator users using actual records. This tests actual behavior, not just configuration presence.

Incorrect Answers

B:

Applying this would shift attention to relationship cascade sharing without testing the actual fault. Table-level Read privileges do not independently restrict an individual sensitive column.

C:

This choice targets business unit access boundary and leaves the described requirement unproven. The case calls for test salary visibility and edit rights as HR, non-HR and administrator users using actual records.

D:

That choice can be relevant to table ownership mismatch, but its assumptions are absent from this case. Here the direct discriminating test is test salary visibility and edit rights as HR, non-HR and administrator users using actual records.

Question 124

HR agents may read employee names but must not view or change a salary column; current table role grants record read. Which preventive practice best reduces recurrence of this issue?

  1. Document hierarchy depth and review changes in reporting structure against access policies.
  2. Build approval assignments and time-bounded row sharing into workflow design.
  3. Record purpose, expiry and revocation for exceptional row shares.
  4. Apply data classification and column-security reviews to sensitive fields.

Explanation

Correct Answer

D:

Apply data classification and column-security reviews to sensitive fields. This helps prevent recurrence of: Table-level Read privileges do not independently restrict an individual sensitive column.

Incorrect Answers

A:

This choice targets manager hierarchy visibility and leaves the described requirement unproven. The case calls for apply data classification and column-security reviews to sensitive fields.

B:

That approach is designed for cross-business-unit approval: The base role's business-unit depth does not extend to the cross-unit record. The present case instead involves table-level Read privileges do not independently restrict an individual sensitive column.

C:

Applying this would shift attention to sharing one exceptional row without testing the actual fault. Table-level Read privileges do not independently restrict an individual sensitive column.

Question 125

HR agents may read employee names but must not view or change a salary column; current table role grants record read. Select TWO steps that both address this case and prove the desired behavior.

  1. Verify approval access to the one shared row and denied access to other rows in the target unit.
  2. Enable column security and assign a column-security profile with appropriate read and update permissions.
  3. Never rely on interface hiding as a substitute for server-side privileges.
  4. Test salary visibility and edit rights as HR, non-HR and administrator users using actual records.
  5. Evaluate hierarchy security configured for the approved management depth plus least-privilege base roles.

Explanation

Correct Answers

B:

Enable column security and assign a column-security profile with appropriate read and update permissions. This directly addresses: Table-level Read privileges do not independently restrict an individual sensitive column.

D:

Test salary visibility and edit rights as HR, non-HR and administrator users using actual records. This is required evidence before closure.

Incorrect Answers

A:

That approach is designed for cross-business-unit approval: The base role's business-unit depth does not extend to the cross-unit record. The present case instead involves table-level Read privileges do not independently restrict an individual sensitive column.

C:

This would respond to a different requirement (search index leakage test). It does not establish the needed result here: apply data classification and column-security reviews to sensitive fields.

E:

This choice targets manager hierarchy visibility and leaves the described requirement unproven. The case calls for enable column security and assign a column-security profile with appropriate read and update permissions.

Question 126

Supervisors need limited read access to direct reports' case records; broad organization-read privileges are prohibited. What is the most directly supported diagnosis?

  1. The secure column is not readable through the user's effective column security profile.
  2. A flat role with organization-wide privileges would disclose peers' cases beyond the chain of command.
  3. The base role's business-unit depth does not extend to the cross-unit record.
  4. Expanding the investigator's table privilege depth grants excessive unrelated access.

Explanation

Correct Answer

B:

Evaluate hierarchy security configured for the approved management depth plus least-privilege base roles. The observed cause is: A flat role with organization-wide privileges would disclose peers' cases beyond the chain of command.

Incorrect Answers

A:

This would respond to a different requirement (column profile no permission). It does not establish the needed result here: a flat role with organization-wide privileges would disclose peers' cases beyond the chain of command.

C:

The proposed step addresses cross-business-unit approval, not the constraint in this scenario. The decisive issue is that a flat role with organization-wide privileges would disclose peers' cases beyond the chain of command.

D:

That approach is designed for sharing one exceptional row: Expanding the investigator's table privilege depth grants excessive unrelated access. The present case instead involves a flat role with organization-wide privileges would disclose peers' cases beyond the chain of command.

Question 127

Supervisors need limited read access to direct reports' case records; broad organization-read privileges are prohibited. Which implementation decision best fixes the stated problem?

  1. Evaluate hierarchy security configured for the approved management depth plus least-privilege base roles.
  2. Assign a narrowly scoped custom security role and test required connector operations under that identity.
  3. Restrict audit-log access and configure supported retention/deletion aligned with the approved policy.
  4. Disable or narrow the relevant Share cascade for cases with independent confidentiality.

Explanation

Correct Answer

A:

Evaluate hierarchy security configured for the approved management depth plus least-privilege base roles. This addresses: A flat role with organization-wide privileges would disclose peers' cases beyond the chain of command.

Incorrect Answers

B:

The proposed step addresses service account overprivilege, not the constraint in this scenario. The decisive issue is that a flat role with organization-wide privileges would disclose peers' cases beyond the chain of command.

C:

This would respond to a different requirement (audit sensitive data retention). It does not establish the needed result here: evaluate hierarchy security configured for the approved management depth plus least-privilege base roles.

D:

That choice can be relevant to relationship cascade sharing, but its assumptions are absent from this case. Here the direct corrective action is evaluate hierarchy security configured for the approved management depth plus least-privilege base roles.

Question 128

Supervisors need limited read access to direct reports' case records; broad organization-read privileges are prohibited. What test would most clearly distinguish a successful fix from a superficial change?

  1. Have two team members process a test case while a nonmember is denied unauthorized access.
  2. Share a test account and verify related private cases are not automatically readable.
  3. Impersonate a manager, a subordinate and an unrelated peer to verify access boundaries.
  4. Verify Tax ID is visible to authorized users and still protected from unauthorized users.

Explanation

Correct Answer

C:

Impersonate a manager, a subordinate and an unrelated peer to verify access boundaries. This tests actual behavior, not just configuration presence.

Incorrect Answers

A:

Applying this would shift attention to teams owning cases without testing the actual fault. A flat role with organization-wide privileges would disclose peers' cases beyond the chain of command.

B:

The proposed step addresses relationship cascade sharing, not the constraint in this scenario. The decisive issue is that a flat role with organization-wide privileges would disclose peers' cases beyond the chain of command.

D:

That choice can be relevant to column profile no permission, but its assumptions are absent from this case. Here the direct discriminating test is impersonate a manager, a subordinate and an unrelated peer to verify access boundaries.

Question 129

Supervisors need limited read access to direct reports' case records; broad organization-read privileges are prohibited. What enduring control should be added to prevent this class of failure?

  1. Document hierarchy depth and review changes in reporting structure against access policies.
  2. Use least-privilege role matrices and test create/read/write/delete separately.
  3. Include audit data in privacy impact and retention reviews.
  4. Limit destructive cascade to relationships whose child lifecycle truly depends on the parent.

Explanation

Correct Answer

A:

Document hierarchy depth and review changes in reporting structure against access policies. This helps prevent recurrence of: A flat role with organization-wide privileges would disclose peers' cases beyond the chain of command.

Incorrect Answers

B:

That choice can be relevant to role privilege for create, but its assumptions are absent from this case. Here the direct recurrence control is document hierarchy depth and review changes in reporting structure against access policies.

C:

This choice targets audit sensitive data retention and leaves the described requirement unproven. The case calls for document hierarchy depth and review changes in reporting structure against access policies.

D:

Applying this would shift attention to cascade delete for disposable children without testing the actual fault. A flat role with organization-wide privileges would disclose peers' cases beyond the chain of command.

Question 130

Supervisors need limited read access to direct reports' case records; broad organization-read privileges are prohibited. Which THREE choices combine the needed correction, a meaningful test and a preventive control? Select THREE.

  1. Conduct periodic least-privilege reviews of application users and service identities.
  2. Document hierarchy depth and review changes in reporting structure against access policies.
  3. Impersonate a manager, a subordinate and an unrelated peer to verify access boundaries.
  4. Remove a pilot user from the directory group and verify effective Dataverse access updates after propagation.
  5. Evaluate hierarchy security configured for the approved management depth plus least-privilege base roles.
  6. Configure the specific optional child relationship with Cascade All on delete after validating scope.

Explanation

Correct Answers

B:

Document hierarchy depth and review changes in reporting structure against access policies. This reduces recurrence of: A flat role with organization-wide privileges would disclose peers' cases beyond the chain of command.

C:

Impersonate a manager, a subordinate and an unrelated peer to verify access boundaries. This is required evidence before closure.

E:

Evaluate hierarchy security configured for the approved management depth plus least-privilege base roles. This directly addresses: A flat role with organization-wide privileges would disclose peers' cases beyond the chain of command.

Incorrect Answers

A:

That approach is designed for service account overprivilege: The account has far more privileges than its operation requires. The present case instead involves a flat role with organization-wide privileges would disclose peers' cases beyond the chain of command.

D:

This choice targets entra group membership changes and leaves the described requirement unproven. The case calls for impersonate a manager, a subordinate and an unrelated peer to verify access boundaries.

F:

Applying this would shift attention to cascade delete for disposable children without testing the actual fault. A flat role with organization-wide privileges would disclose peers' cases beyond the chain of command.

Microsoft Power Platform Functional Consultant (PL-200) Practice Tests

UP

SPECIAL OFFER: GET 10% OFF

This is ONE TIME OFFER

ExamSnap Discount Offer
Enter Your Email Address to Receive Your 10% Off Discount Code

A confirmation link will be sent to this email address to verify your login. *We value your privacy. We will not rent or sell your email address.

Download Free Demo of VCE Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your e-mail address below to get started with our interactive software demo of your free trial.

Free Demo Limits: In the demo version you will be able to access only first 5 questions from exam.