100% Latest & Updated Microsoft PL-200 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 40
Compliance requires Dataverse row auditing on a proposed virtual inventory table that reads an external service. Which THREE steps are justified for a complete controlled response? Select THREE.
- Add and edit related orders, force or await the rollup recalculation and compare with the expected sum.
- Use Remove Link for the delete action on an optional lookup so the inquiries remain with an empty parent reference.
- Keep audit events in the underlying source or persist audit-relevant transactions in a supported local Dataverse table.
- Capture audit requirements for activity history and avoid replacing activity records with unstructured notes.
- Flag virtual-table feature restrictions before promising native Dataverse auditing or search.
- Retrieve a source-side change log and prove that the required actor, action and timestamp are retained.
Explanation
Correct Answers
C:Keep audit events in the underlying source or persist audit-relevant transactions in a supported local Dataverse table. This directly addresses: Dataverse virtual tables do not support ordinary local row auditing.
E:Flag virtual-table feature restrictions before promising native Dataverse auditing or search. This reduces recurrence of: Dataverse virtual tables do not support ordinary local row auditing.
F:Retrieve a source-side change log and prove that the required actor, action and timestamp are retained. This is required evidence before closure.
Incorrect Answers
A:This choice targets rollup child totals and leaves the described requirement unproven. The case calls for retrieve a source-side change log and prove that the required actor, action and timestamp are retained.
B:Applying this would shift attention to account removal without child deletion without testing the actual fault. Dataverse virtual tables do not support ordinary local row auditing.
D:That approach is designed for activity history on a customer: A plain text table does not provide native Dataverse activity semantics. The present case instead involves dataverse virtual tables do not support ordinary local row auditing.
Question 41
Managers need the sum of each account's related order amounts; the current manually maintained numeric total often drifts. Which underlying design issue accounts for the observed behavior?
- A plain text table does not provide native Dataverse activity semantics.
- Assign cascade would also transfer case ownership contrary to the approved responsibility matrix.
- The account total is denormalized and updated only by users, so related-order changes are missed.
- Manually entered derived values become stale and violate a single source of truth.
Explanation
Correct Answer
C:Configure a supported rollup column to aggregate qualifying related orders and communicate its calculation schedule. The observed cause is: The account total is denormalized and updated only by users, so related-order changes are missed.
Incorrect Answers
A:This choice targets activity history on a customer and leaves the described requirement unproven. The case calls for the account total is denormalized and updated only by users, so related-order changes are missed.
B:That approach is designed for reassign without unintended cascade: Assign cascade would also transfer case ownership contrary to the approved responsibility matrix. The present case instead involves the account total is denormalized and updated only by users, so related-order changes are missed.
D:This would respond to a different requirement (formula per-row calculation). It does not establish the needed result here: the account total is denormalized and updated only by users, so related-order changes are missed.
Question 42
Managers need the sum of each account's related order amounts; the current manually maintained numeric total often drifts. Which implementation decision best fixes the stated problem?
- Use a supported integration or calculation at the external source and persist only necessary derived results.
- Configure the relationship's delete behavior as Restrict and retain contract ownership.
- Model supplier–group membership with a many-to-many relationship or an explicit junction table if membership needs attributes.
- Configure a supported rollup column to aggregate qualifying related orders and communicate its calculation schedule.
Explanation
Correct Answer
D:Configure a supported rollup column to aggregate qualifying related orders and communicate its calculation schedule. This addresses: The account total is denormalized and updated only by users, so related-order changes are missed.
Incorrect Answers
A:The proposed step addresses computed field external source, not the constraint in this scenario. The decisive issue is that the account total is denormalized and updated only by users, so related-order changes are missed.
B:That approach is designed for delete protected contract parent: Delete cascade is configured to remove related rows instead of blocking deletion. The present case instead involves the account total is denormalized and updated only by users, so related-order changes are missed.
C:This would respond to a different requirement (supplier multiparty membership). It does not establish the needed result here: configure a supported rollup column to aggregate qualifying related orders and communicate its calculation schedule.
Question 43
Managers need the sum of each account's related order amounts; the current manually maintained numeric total often drifts. Which acceptance check should the team use?
- Associate two suppliers with two groups and confirm reciprocal membership without overwriting a previous association.
- Add and edit related orders, force or await the rollup recalculation and compare with the expected sum.
- Change external values and prove the displayed derived value updates through the chosen supported integration.
- Change a price in the source and verify the virtual-table view reflects the external value without an import job.
Explanation
Correct Answer
B:Add and edit related orders, force or await the rollup recalculation and compare with the expected sum. This tests actual behavior, not just configuration presence.
Incorrect Answers
A:That choice can be relevant to supplier multiparty membership, but its assumptions are absent from this case. Here the direct discriminating test is add and edit related orders, force or await the rollup recalculation and compare with the expected sum.
C:The proposed step addresses computed field external source, not the constraint in this scenario. The decisive issue is that the account total is denormalized and updated only by users, so related-order changes are missed.
D:This would respond to a different requirement (external read-only price catalog). It does not establish the needed result here: add and edit related orders, force or await the rollup recalculation and compare with the expected sum.
Question 44
Managers need the sum of each account's related order amounts; the current manually maintained numeric total often drifts. What repeatable design control fits the root cause?
- Include referential-delete behavior in solution design review and destructive-operation tests.
- Distinguish time instants from date-only business attributes in schema standards.
- Govern alternate-key uniqueness and monitor integration reconciliation failures.
- Document rollup refresh behavior and test edge cases such as filters and deleted children.
Explanation
Correct Answer
D:Document rollup refresh behavior and test edge cases such as filters and deleted children. This helps prevent recurrence of: The account total is denormalized and updated only by users, so related-order changes are missed.
Incorrect Answers
A:The proposed step addresses delete protected contract parent, not the constraint in this scenario. The decisive issue is that the account total is denormalized and updated only by users, so related-order changes are missed.
B:Applying this would shift attention to timezone date reporting without testing the actual fault. The account total is denormalized and updated only by users, so related-order changes are missed.
C:That choice can be relevant to alternate key duplicate external id, but its assumptions are absent from this case. Here the direct recurrence control is document rollup refresh behavior and test edge cases such as filters and deleted children.
Question 45
Managers need the sum of each account's related order amounts; the current manually maintained numeric total often drifts. Select TWO steps that both address this case and prove the desired behavior.
- Configure a supported rollup column to aggregate qualifying related orders and communicate its calculation schedule.
- Reimport the same external ID and confirm one row is updated rather than a second row created.
- Use appropriate activity table types and associate activity regarding records with the customer.
- Distinguish time instants from date-only business attributes in schema standards.
- Add and edit related orders, force or await the rollup recalculation and compare with the expected sum.
Explanation
Correct Answers
A:Configure a supported rollup column to aggregate qualifying related orders and communicate its calculation schedule. This directly addresses: The account total is denormalized and updated only by users, so related-order changes are missed.
E:Add and edit related orders, force or await the rollup recalculation and compare with the expected sum. This is required evidence before closure.
Incorrect Answers
B:Applying this would shift attention to alternate key duplicate external id without testing the actual fault. The account total is denormalized and updated only by users, so related-order changes are missed.
C:That choice can be relevant to activity history on a customer, but its assumptions are absent from this case. Here the direct corrective action is configure a supported rollup column to aggregate qualifying related orders and communicate its calculation schedule.
D:This choice targets timezone date reporting and leaves the described requirement unproven. The case calls for document rollup refresh behavior and test edge cases such as filters and deleted children.
Question 46
A service ticket must show remaining warranty days derived from its own expiry date; editors currently key the value manually. Which underlying design issue accounts for the observed behavior?
- A text field cannot enforce a referential link to the parent account row.
- Transaction currency amounts are being mixed without a consistent base-currency comparison.
- Assign cascade would also transfer case ownership contrary to the approved responsibility matrix.
- Manually entered derived values become stale and violate a single source of truth.
Explanation
Correct Answer
D:Use a supported formula or calculated column with the appropriate date logic for row-local derivation. The observed cause is: Manually entered derived values become stale and violate a single source of truth.
Incorrect Answers
A:This choice targets account–contact one-to-many and leaves the described requirement unproven. The case calls for manually entered derived values become stale and violate a single source of truth.
B:Applying this would shift attention to currency exchange reporting without testing the actual fault. Manually entered derived values become stale and violate a single source of truth.
C:That approach is designed for reassign without unintended cascade: Assign cascade would also transfer case ownership contrary to the approved responsibility matrix. The present case instead involves manually entered derived values become stale and violate a single source of truth.
Question 47
A service ticket must show remaining warranty days derived from its own expiry date; editors currently key the value manually. Which implementation decision best fixes the stated problem?
- Review and restrict Reparent cascade to match the organization's row-security model.
- Use appropriate activity table types and associate activity regarding records with the customer.
- Add the intended column and dependencies to the source solution and export a new version for deployment.
- Use a supported formula or calculated column with the appropriate date logic for row-local derivation.
Explanation
Correct Answer
D:Use a supported formula or calculated column with the appropriate date logic for row-local derivation. This addresses: Manually entered derived values become stale and violate a single source of truth.
Incorrect Answers
A:This choice targets missing cascading reparent behavior and leaves the described requirement unproven. The case calls for use a supported formula or calculated column with the appropriate date logic for row-local derivation.
B:That approach is designed for activity history on a customer: A plain text table does not provide native Dataverse activity semantics. The present case instead involves manually entered derived values become stale and violate a single source of truth.
C:This would respond to a different requirement (solution component missing column). It does not establish the needed result here: use a supported formula or calculated column with the appropriate date logic for row-local derivation.
Question 48
A service ticket must show remaining warranty days derived from its own expiry date; editors currently key the value manually. Which acceptance check should the team use?
- Attempt to delete a customer with contracts and confirm the operation is denied while contracts remain intact.
- Set known expiry dates and compare the resulting value with hand-calculated expected days.
- Associate two suppliers with two groups and confirm reciprocal membership without overwriting a previous association.
- Create contacts for two accounts and verify each lookup resolves to exactly one account while an account can display multiple related contacts.
Explanation
Correct Answer
B:Set known expiry dates and compare the resulting value with hand-calculated expected days. This tests actual behavior, not just configuration presence.
Incorrect Answers
A:That approach is designed for delete protected contract parent: Delete cascade is configured to remove related rows instead of blocking deletion. The present case instead involves manually entered derived values become stale and violate a single source of truth.
C:The proposed step addresses supplier multiparty membership, not the constraint in this scenario. The decisive issue is that manually entered derived values become stale and violate a single source of truth.
D:This would respond to a different requirement (account–contact one-to-many). It does not establish the needed result here: set known expiry dates and compare the resulting value with hand-calculated expected days.
Question 49
A service ticket must show remaining warranty days derived from its own expiry date; editors currently key the value manually. Which preventive practice best reduces recurrence of this issue?
- Use calculated data types within their supported functions and avoid rewriting source dates.
- Document cardinality and decide early whether the association requires its own status or effective-date columns.
- Distinguish time instants from date-only business attributes in schema standards.
- Document rollup refresh behavior and test edge cases such as filters and deleted children.
Explanation
Correct Answer
A:Use calculated data types within their supported functions and avoid rewriting source dates. This helps prevent recurrence of: Manually entered derived values become stale and violate a single source of truth.
Incorrect Answers
B:That choice can be relevant to supplier multiparty membership, but its assumptions are absent from this case. Here the direct recurrence control is use calculated data types within their supported functions and avoid rewriting source dates.
C:The proposed step addresses timezone date reporting, not the constraint in this scenario. The decisive issue is that manually entered derived values become stale and violate a single source of truth.
D:This would respond to a different requirement (rollup child totals). It does not establish the needed result here: use calculated data types within their supported functions and avoid rewriting source dates.
Question 50
A service ticket must show remaining warranty days derived from its own expiry date; editors currently key the value manually. Which THREE steps are justified for a complete controlled response? Select THREE.
- Attempt to delete a customer with contracts and confirm the operation is denied while contracts remain intact.
- Use a supported formula or calculated column with the appropriate date logic for row-local derivation.
- Document cardinality and decide early whether the association requires its own status or effective-date columns.
- Use calculated data types within their supported functions and avoid rewriting source dates.
- Set known expiry dates and compare the resulting value with hand-calculated expected days.
- Set the relationship's Assign behavior to Cascade None for independently owned service cases.
Explanation
Correct Answers
B:Use a supported formula or calculated column with the appropriate date logic for row-local derivation. This directly addresses: Manually entered derived values become stale and violate a single source of truth.
D:Use calculated data types within their supported functions and avoid rewriting source dates. This reduces recurrence of: Manually entered derived values become stale and violate a single source of truth.
E:Set known expiry dates and compare the resulting value with hand-calculated expected days. This is required evidence before closure.
Incorrect Answers
A:That choice can be relevant to delete protected contract parent, but its assumptions are absent from this case. Here the direct discriminating test is set known expiry dates and compare the resulting value with hand-calculated expected days.
C:Applying this would shift attention to supplier multiparty membership without testing the actual fault. Manually entered derived values become stale and violate a single source of truth.
F:The proposed step addresses reassign without unintended cascade, not the constraint in this scenario. The decisive issue is that manually entered derived values become stale and violate a single source of truth.
Microsoft Power Platform Functional Consultant (PL-200) Practice Tests