100% Latest & Updated Microsoft PL-200 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 210
A solution deploys a custom table but its critical new schema column is absent in the target environment. Which THREE steps are justified for a complete controlled response? Select THREE.
- Import to a clean test environment and inspect the table schema for the exact expected column logical name.
- Save known fractional test values and check stored values and reporting totals for expected precision.
- Use dependency and component inventories during solution release reviews.
- Review and restrict Reparent cascade to match the organization's row-security model.
- Add the intended column and dependencies to the source solution and export a new version for deployment.
- Capture audit requirements for activity history and avoid replacing activity records with unstructured notes.
Explanation
Correct Answers
A:Import to a clean test environment and inspect the table schema for the exact expected column logical name. This is required evidence before closure.
C:Use dependency and component inventories during solution release reviews. This reduces recurrence of: The column was not added as a required solution component before export.
E:Add the intended column and dependencies to the source solution and export a new version for deployment. This directly addresses: The column was not added as a required solution component before export.
Incorrect Answers
B:This would respond to a different requirement (currency precision concern). It does not establish the needed result here: import to a clean test environment and inspect the table schema for the exact expected column logical name.
D:That approach is designed for missing cascading reparent behavior: Reparenting cascade behavior propagates relationship changes to children beyond the intended boundary. The present case instead involves the column was not added as a required solution component before export.
F:The proposed step addresses activity history on a customer, not the constraint in this scenario. The decisive issue is that the column was not added as a required solution component before export.
Question 211
An integration service principal has the System Administrator role solely to update one custom table. Which explanation best fits the described evidence?
- Retaining orphaned disposable drafts would leave invalid unrelated child rows.
- Their security role grants Read but lacks a sufficient Create privilege for the Order table.
- The account has far more privileges than its operation requires.
- Organization-level privilege depth overrides the intended branch visibility boundary.
Explanation
Correct Answer
C:Assign a narrowly scoped custom security role and test required connector operations under that identity. The observed cause is: The account has far more privileges than its operation requires.
Incorrect Answers
A:The proposed step addresses cascade delete for disposable children, not the constraint in this scenario. The decisive issue is that the account has far more privileges than its operation requires.
B:This would respond to a different requirement (role privilege for create). It does not establish the needed result here: the account has far more privileges than its operation requires.
D:That choice can be relevant to business unit access boundary, but its assumptions are absent from this case. Here the direct diagnosis is the account has far more privileges than its operation requires.
Question 212
An integration service principal has the System Administrator role solely to update one custom table. Which targeted change best addresses this requirement?
- Use a supported Microsoft Entra ID group team with roles aligned to the directory group.
- Add Create at the narrowest appropriate depth and confirm any required related-table privileges.
- Assign a narrowly scoped custom security role and test required connector operations under that identity.
- Reduce the relevant Read privilege depth and align record ownership and business units to the approved scope.
Explanation
Correct Answer
C:Assign a narrowly scoped custom security role and test required connector operations under that identity. This addresses: The account has far more privileges than its operation requires.
Incorrect Answers
A:That choice can be relevant to entra group membership changes, but its assumptions are absent from this case. Here the direct corrective action is assign a narrowly scoped custom security role and test required connector operations under that identity.
B:Applying this would shift attention to role privilege for create without testing the actual fault. The account has far more privileges than its operation requires.
D:The proposed step addresses business unit access boundary, not the constraint in this scenario. The decisive issue is that the account has far more privileges than its operation requires.
Question 213
An integration service principal has the System Administrator role solely to update one custom table. What test would most clearly distinguish a successful fix from a superficial change?
- Inspect audit visibility for nonprivileged users and verify purging obeys retention controls.
- Impersonate a manager, a subordinate and an unrelated peer to verify access boundaries.
- Delete a test registration and confirm only its related disposable draft rows are removed.
- Execute create/update/read tests for the integration while verifying unrelated privileged actions are denied.
Explanation
Correct Answer
D:Execute create/update/read tests for the integration while verifying unrelated privileged actions are denied. This tests actual behavior, not just configuration presence.
Incorrect Answers
A:This choice targets audit sensitive data retention and leaves the described requirement unproven. The case calls for execute create/update/read tests for the integration while verifying unrelated privileged actions are denied.
B:Applying this would shift attention to manager hierarchy visibility without testing the actual fault. The account has far more privileges than its operation requires.
C:That choice can be relevant to cascade delete for disposable children, but its assumptions are absent from this case. Here the direct discriminating test is execute create/update/read tests for the integration while verifying unrelated privileged actions are denied.
Question 214
An integration service principal has the System Administrator role solely to update one custom table. What enduring control should be added to prevent this class of failure?
- Test privilege depth with representative users whenever organizational boundaries change.
- Conduct periodic least-privilege reviews of application users and service identities.
- Review secured-column profile membership during onboarding and role changes.
- Treat directory group ownership and periodic access review as part of the authorization design.
Explanation
Correct Answer
B:Conduct periodic least-privilege reviews of application users and service identities. This helps prevent recurrence of: The account has far more privileges than its operation requires.
Incorrect Answers
A:This choice targets business unit access boundary and leaves the described requirement unproven. The case calls for conduct periodic least-privilege reviews of application users and service identities.
C:Applying this would shift attention to column profile no permission without testing the actual fault. The account has far more privileges than its operation requires.
D:That approach is designed for entra group membership changes: A manually maintained team can lag behind the identity source and retain stale members. The present case instead involves the account has far more privileges than its operation requires.
Question 215
An integration service principal has the System Administrator role solely to update one custom table. Which TWO choices form a coherent fix-and-validation response? Select TWO.
- Assign a narrowly scoped custom security role and test required connector operations under that identity.
- Share a test account and verify related private cases are not automatically readable.
- Test privilege depth with representative users whenever organizational boundaries change.
- Execute create/update/read tests for the integration while verifying unrelated privileged actions are denied.
- Disable or narrow the relevant Share cascade for cases with independent confidentiality.
Explanation
Correct Answers
A:Assign a narrowly scoped custom security role and test required connector operations under that identity. This directly addresses: The account has far more privileges than its operation requires.
D:Execute create/update/read tests for the integration while verifying unrelated privileged actions are denied. This is required evidence before closure.
Incorrect Answers
B:That approach is designed for relationship cascade sharing: Relationship Share cascade is granting related-row access through the parent share. The present case instead involves the account has far more privileges than its operation requires.
C:This would respond to a different requirement (business unit access boundary). It does not establish the needed result here: conduct periodic least-privilege reviews of application users and service identities.
E:This choice targets relationship cascade sharing and leaves the described requirement unproven. The case calls for assign a narrowly scoped custom security role and test required connector operations under that identity.
Question 216
Two source systems import Contacts with an external employee ID that should identify one Dataverse row, but repeated loads create duplicates. What mechanism should the consultant identify before making changes?
- User-local timezone conversion changes the displayed calendar date across time zones.
- Manually entered derived values become stale and violate a single source of truth.
- The table lacks an enforced alternate key on the stable external identifier.
- Making the lookup required before backfilling historical rows will block valid migration and editing.
Explanation
Correct Answer
C:Configure a suitable alternate key and correct existing duplicates before using idempotent upserts. The observed cause is: The table lacks an enforced alternate key on the stable external identifier.
Incorrect Answers
A:The proposed step addresses timezone date reporting, not the constraint in this scenario. The decisive issue is that the table lacks an enforced alternate key on the stable external identifier.
B:That approach is designed for formula per-row calculation: Manually entered derived values become stale and violate a single source of truth. The present case instead involves the table lacks an enforced alternate key on the stable external identifier.
D:This would respond to a different requirement (required lookup migration). It does not establish the needed result here: the table lacks an enforced alternate key on the stable external identifier.
Question 217
Two source systems import Contacts with an external employee ID that should identify one Dataverse row, but repeated loads create duplicates. What is the most appropriate next configuration action?
- Use Remove Link for the delete action on an optional lookup so the inquiries remain with an empty parent reference.
- Replace the text field with an appropriate Dataverse choice column and migrate historical values through a mapping.
- Use appropriate activity table types and associate activity regarding records with the customer.
- Configure a suitable alternate key and correct existing duplicates before using idempotent upserts.
Explanation
Correct Answer
D:Configure a suitable alternate key and correct existing duplicates before using idempotent upserts. This addresses: The table lacks an enforced alternate key on the stable external identifier.
Incorrect Answers
A:That choice can be relevant to account removal without child deletion, but its assumptions are absent from this case. Here the direct corrective action is configure a suitable alternate key and correct existing duplicates before using idempotent upserts.
B:This would respond to a different requirement (choice value normalization). It does not establish the needed result here: configure a suitable alternate key and correct existing duplicates before using idempotent upserts.
C:The proposed step addresses activity history on a customer, not the constraint in this scenario. The decisive issue is that the table lacks an enforced alternate key on the stable external identifier.
Question 218
Two source systems import Contacts with an external employee ID that should identify one Dataverse row, but repeated loads create duplicates. Which acceptance check should the team use?
- Reassign an account and confirm case owners remain unchanged while the account owner changes.
- Associate two suppliers with two groups and confirm reciprocal membership without overwriting a previous association.
- Save known fractional test values and check stored values and reporting totals for expected precision.
- Reimport the same external ID and confirm one row is updated rather than a second row created.
Explanation
Correct Answer
D:Reimport the same external ID and confirm one row is updated rather than a second row created. This tests actual behavior, not just configuration presence.
Incorrect Answers
A:Applying this would shift attention to reassign without unintended cascade without testing the actual fault. The table lacks an enforced alternate key on the stable external identifier.
B:That choice can be relevant to supplier multiparty membership, but its assumptions are absent from this case. Here the direct discriminating test is reimport the same external ID and confirm one row is updated rather than a second row created.
C:The proposed step addresses currency precision concern, not the constraint in this scenario. The decisive issue is that the table lacks an enforced alternate key on the stable external identifier.
Question 219
Two source systems import Contacts with an external employee ID that should identify one Dataverse row, but repeated loads create duplicates. What enduring control should be added to prevent this class of failure?
- Document cardinality and decide early whether the association requires its own status or effective-date columns.
- Include referential-delete behavior in solution design review and destructive-operation tests.
- Maintain a publisher-prefix and logical-name registry for solution components.
- Govern alternate-key uniqueness and monitor integration reconciliation failures.
Explanation
Correct Answer
D:Govern alternate-key uniqueness and monitor integration reconciliation failures. This helps prevent recurrence of: The table lacks an enforced alternate key on the stable external identifier.
Incorrect Answers
A:Applying this would shift attention to supplier multiparty membership without testing the actual fault. The table lacks an enforced alternate key on the stable external identifier.
B:This choice targets delete protected contract parent and leaves the described requirement unproven. The case calls for govern alternate-key uniqueness and monitor integration reconciliation failures.
C:That choice can be relevant to table naming collision, but its assumptions are absent from this case. Here the direct recurrence control is govern alternate-key uniqueness and monitor integration reconciliation failures.
Question 220
Two source systems import Contacts with an external employee ID that should identify one Dataverse row, but repeated loads create duplicates. Select THREE case-specific measures covering remediation, proof and longer-term prevention.
- Include mandatory-field impact analysis in schema change and deployment plans.
- Govern alternate-key uniqueness and monitor integration reconciliation failures.
- Add and edit related orders, force or await the rollup recalculation and compare with the expected sum.
- Configure a suitable alternate key and correct existing duplicates before using idempotent upserts.
- Reimport the same external ID and confirm one row is updated rather than a second row created.
- Use Remove Link for the delete action on an optional lookup so the inquiries remain with an empty parent reference.
Explanation
Correct Answers
B:Govern alternate-key uniqueness and monitor integration reconciliation failures. This reduces recurrence of: The table lacks an enforced alternate key on the stable external identifier.
D:Configure a suitable alternate key and correct existing duplicates before using idempotent upserts. This directly addresses: The table lacks an enforced alternate key on the stable external identifier.
E:Reimport the same external ID and confirm one row is updated rather than a second row created. This is required evidence before closure.
Incorrect Answers
A:That approach is designed for required lookup migration: Making the lookup required before backfilling historical rows will block valid migration and editing. The present case instead involves the table lacks an enforced alternate key on the stable external identifier.
C:This choice targets rollup child totals and leaves the described requirement unproven. The case calls for reimport the same external ID and confirm one row is updated rather than a second row created.
F:Applying this would shift attention to account removal without child deletion without testing the actual fault. The table lacks an enforced alternate key on the stable external identifier.
Microsoft Power Platform Functional Consultant (PL-200) Practice Tests