100% Latest & Updated Microsoft PL-200 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
Question 20
An imported account is obsolete, but associated draft inquiries must survive without pointing to the removed account. Which THREE steps are justified for a complete controlled response? Select THREE.
- Create contacts for two accounts and verify each lookup resolves to exactly one account while an account can display multiple related contacts.
- Document cardinality and decide early whether the association requires its own status or effective-date columns.
- Use Remove Link for the delete action on an optional lookup so the inquiries remain with an empty parent reference.
- Delete the test parent and confirm related inquiries still exist and their account lookups are cleared.
- Distinguish optional references from required references before configuring relationship actions.
- Add the intended column and dependencies to the source solution and export a new version for deployment.
Explanation
Correct Answers
C:Use Remove Link for the delete action on an optional lookup so the inquiries remain with an empty parent reference. This directly addresses: The relationship's delete behavior would delete the inquiries along with the account.
D:Delete the test parent and confirm related inquiries still exist and their account lookups are cleared. This is required evidence before closure.
E:Distinguish optional references from required references before configuring relationship actions. This reduces recurrence of: The relationship's delete behavior would delete the inquiries along with the account.
Incorrect Answers
A:That choice can be relevant to account–contact one-to-many, but its assumptions are absent from this case. Here the direct discriminating test is delete the test parent and confirm related inquiries still exist and their account lookups are cleared.
B:Applying this would shift attention to supplier multiparty membership without testing the actual fault. The relationship's delete behavior would delete the inquiries along with the account.
F:The proposed step addresses solution component missing column, not the constraint in this scenario. The decisive issue is that the relationship's delete behavior would delete the inquiries along with the account.
Question 21
Regional account owners change, but related service cases have separate accountable owners; the maker set account Assign to Cascade All. Which explanation best fits the described evidence?
- Assign cascade would also transfer case ownership contrary to the approved responsibility matrix.
- 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.
- Reusing an ambiguous display label risks binding the wrong logical table to new components.
Explanation
Correct Answer
A:Set the relationship's Assign behavior to Cascade None for independently owned service cases. The observed cause is: Assign cascade would also transfer case ownership contrary to the approved responsibility matrix.
Incorrect Answers
B:Applying this would shift attention to timezone date reporting without testing the actual fault. Assign cascade would also transfer case ownership contrary to the approved responsibility matrix.
C:This choice targets formula per-row calculation and leaves the described requirement unproven. The case calls for assign cascade would also transfer case ownership contrary to the approved responsibility matrix.
D:That choice can be relevant to table naming collision, but its assumptions are absent from this case. Here the direct diagnosis is assign cascade would also transfer case ownership contrary to the approved responsibility matrix.
Question 22
Regional account owners change, but related service cases have separate accountable owners; the maker set account Assign to Cascade All. What should the consultant configure to correct the observed behavior?
- Use a supported integration or calculation at the external source and persist only necessary derived results.
- Plan a staged migration that populates or resolves missing locations before enforcing requiredness.
- Evaluate a Dataverse virtual table backed by a supported external data provider and document its feature limitations.
- Set the relationship's Assign behavior to Cascade None for independently owned service cases.
Explanation
Correct Answer
D:Set the relationship's Assign behavior to Cascade None for independently owned service cases. This addresses: Assign cascade would also transfer case ownership contrary to the approved responsibility matrix.
Incorrect Answers
A:Applying this would shift attention to computed field external source without testing the actual fault. Assign cascade would also transfer case ownership contrary to the approved responsibility matrix.
B: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 assign cascade would also transfer case ownership contrary to the approved responsibility matrix.
C:This choice targets external read-only price catalog and leaves the described requirement unproven. The case calls for set the relationship's Assign behavior to Cascade None for independently owned service cases.
Question 23
Regional account owners change, but related service cases have separate accountable owners; the maker set account Assign to Cascade All. What test would most clearly distinguish a successful fix from a superficial change?
- 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.
- Reassign an account and confirm case owners remain unchanged while the account owner changes.
- Change external values and prove the displayed derived value updates through the chosen supported integration.
Explanation
Correct Answer
C:Reassign an account and confirm case owners remain unchanged while the account owner changes. This tests actual behavior, not just configuration presence.
Incorrect Answers
A:That approach is designed for supplier multiparty membership: The one-to-many lookup cannot represent both sides having multiple memberships. The present case instead involves assign cascade would also transfer case ownership contrary to the approved responsibility matrix.
B:This choice targets currency precision concern and leaves the described requirement unproven. The case calls for reassign an account and confirm case owners remain unchanged while the account owner changes.
D:This would respond to a different requirement (computed field external source). It does not establish the needed result here: reassign an account and confirm case owners remain unchanged while the account owner changes.
Question 24
Regional account owners change, but related service cases have separate accountable owners; the maker set account Assign to Cascade All. Which preventive practice best reduces recurrence of this issue?
- Use calculated data types within their supported functions and avoid rewriting source dates.
- Include mandatory-field impact analysis in schema change and deployment plans.
- Review assignment and sharing cascades independently for each ownership boundary.
- Document cardinality and decide early whether the association requires its own status or effective-date columns.
Explanation
Correct Answer
C:Review assignment and sharing cascades independently for each ownership boundary. This helps prevent recurrence of: Assign cascade would also transfer case ownership contrary to the approved responsibility matrix.
Incorrect Answers
A: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 assign cascade would also transfer case ownership contrary to the approved responsibility matrix.
B:This would respond to a different requirement (required lookup migration). It does not establish the needed result here: review assignment and sharing cascades independently for each ownership boundary.
D:The proposed step addresses supplier multiparty membership, not the constraint in this scenario. The decisive issue is that assign cascade would also transfer case ownership contrary to the approved responsibility matrix.
Question 25
Regional account owners change, but related service cases have separate accountable owners; the maker set account Assign to Cascade All. Which TWO choices form a coherent fix-and-validation response? Select TWO.
- Set the relationship's Assign behavior to Cascade None for independently owned service cases.
- Save known fractional test values and check stored values and reporting totals for expected precision.
- Replace the text field with an appropriate Dataverse choice column and migrate historical values through a mapping.
- Use calculated data types within their supported functions and avoid rewriting source dates.
- Reassign an account and confirm case owners remain unchanged while the account owner changes.
Explanation
Correct Answers
A:Set the relationship's Assign behavior to Cascade None for independently owned service cases. This directly addresses: Assign cascade would also transfer case ownership contrary to the approved responsibility matrix.
E:Reassign an account and confirm case owners remain unchanged while the account owner changes. This is required evidence before closure.
Incorrect Answers
B:The proposed step addresses currency precision concern, not the constraint in this scenario. The decisive issue is that assign cascade would also transfer case ownership contrary to the approved responsibility matrix.
C:This would respond to a different requirement (choice value normalization). It does not establish the needed result here: set the relationship's Assign behavior to Cascade None for independently owned service cases.
D:That choice can be relevant to formula per-row calculation, but its assumptions are absent from this case. Here the direct recurrence control is review assignment and sharing cascades independently for each ownership boundary.
Question 26
Users need an email and phone-call timeline related to a customer; the maker created an ordinary text table for notes. What mechanism should the consultant identify before making changes?
- Transaction currency amounts are being mixed without a consistent base-currency comparison.
- The account total is denormalized and updated only by users, so related-order changes are missed.
- A plain text table does not provide native Dataverse activity semantics.
- An unconstrained text column allows synonymous labels that are not one controlled classification.
Explanation
Correct Answer
C:Use appropriate activity table types and associate activity regarding records with the customer. The observed cause is: A plain text table does not provide native Dataverse activity semantics.
Incorrect Answers
A:That choice can be relevant to currency exchange reporting, but its assumptions are absent from this case. Here the direct diagnosis is a plain text table does not provide native Dataverse activity semantics.
B:Applying this would shift attention to rollup child totals without testing the actual fault. A plain text table does not provide native Dataverse activity semantics.
D:The proposed step addresses choice value normalization, not the constraint in this scenario. The decisive issue is that a plain text table does not provide native Dataverse activity semantics.
Question 27
Users need an email and phone-call timeline related to a customer; the maker created an ordinary text table for notes. What should the consultant configure to correct the observed behavior?
- Use a supported formula or calculated column with the appropriate date logic for row-local derivation.
- 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.
- Use appropriate activity table types and associate activity regarding records with the customer.
Explanation
Correct Answer
D:Use appropriate activity table types and associate activity regarding records with the customer. This addresses: A plain text table does not provide native Dataverse activity semantics.
Incorrect Answers
A:Applying this would shift attention to formula per-row calculation without testing the actual fault. A plain text table does not provide native Dataverse activity semantics.
B:This choice targets supplier multiparty membership and leaves the described requirement unproven. The case calls for use appropriate activity table types and associate activity regarding records with the customer.
C:That choice can be relevant to rollup child totals, but its assumptions are absent from this case. Here the direct corrective action is use appropriate activity table types and associate activity regarding records with the customer.
Question 28
Users need an email and phone-call timeline related to a customer; the maker created an ordinary text table for notes. Which validation would demonstrate that the intended result has been achieved?
- Create rows with two currencies and confirm base values and selected report totals reconcile with applicable rates.
- Associate two suppliers with two groups and confirm reciprocal membership without overwriting a previous association.
- Record a phone call and an email and verify both surface as activities on the related customer's timeline.
- Review the same stored instant for users in two time zones and confirm the report follows the defined date rule.
Explanation
Correct Answer
C:Record a phone call and an email and verify both surface as activities on the related customer's timeline. This tests actual behavior, not just configuration presence.
Incorrect Answers
A:Applying this would shift attention to currency exchange reporting without testing the actual fault. A plain text table does not provide native Dataverse activity semantics.
B:That approach is designed for supplier multiparty membership: The one-to-many lookup cannot represent both sides having multiple memberships. The present case instead involves a plain text table does not provide native Dataverse activity semantics.
D:This choice targets timezone date reporting and leaves the described requirement unproven. The case calls for record a phone call and an email and verify both surface as activities on the related customer's timeline.
Question 29
Users need an email and phone-call timeline related to a customer; the maker created an ordinary text table for notes. Which governance practice most directly protects this requirement over time?
- Capture audit requirements for activity history and avoid replacing activity records with unstructured notes.
- Distinguish time instants from date-only business attributes in schema standards.
- Flag virtual-table feature restrictions before promising native Dataverse auditing or search.
- Specify numeric precision and rounding rules with finance stakeholders before schema creation.
Explanation
Correct Answer
A:Capture audit requirements for activity history and avoid replacing activity records with unstructured notes. This helps prevent recurrence of: A plain text table does not provide native Dataverse activity semantics.
Incorrect Answers
B:This choice targets timezone date reporting and leaves the described requirement unproven. The case calls for capture audit requirements for activity history and avoid replacing activity records with unstructured notes.
C:This would respond to a different requirement (virtual-table auditing request). It does not establish the needed result here: capture audit requirements for activity history and avoid replacing activity records with unstructured notes.
D:That approach is designed for currency precision concern: Column precision configuration truncates or rounds values before downstream formulas execute. The present case instead involves a plain text table does not provide native Dataverse activity semantics.
Question 30
Users need an email and phone-call timeline related to a customer; the maker created an ordinary text table for notes. Select THREE case-specific measures covering remediation, proof and longer-term prevention.
- Record a phone call and an email and verify both surface as activities on the related customer's timeline.
- Distinguish optional references from required references before configuring relationship actions.
- Use appropriate activity table types and associate activity regarding records with the customer.
- Capture audit requirements for activity history and avoid replacing activity records with unstructured notes.
- Create rows with two currencies and confirm base values and selected report totals reconcile with applicable rates.
- Evaluate a Dataverse virtual table backed by a supported external data provider and document its feature limitations.
Explanation
Correct Answers
A:Record a phone call and an email and verify both surface as activities on the related customer's timeline. This is required evidence before closure.
C:Use appropriate activity table types and associate activity regarding records with the customer. This directly addresses: A plain text table does not provide native Dataverse activity semantics.
D:Capture audit requirements for activity history and avoid replacing activity records with unstructured notes. This reduces recurrence of: A plain text table does not provide native Dataverse activity semantics.
Incorrect Answers
B:The proposed step addresses account removal without child deletion, not the constraint in this scenario. The decisive issue is that a plain text table does not provide native Dataverse activity semantics.
E:This would respond to a different requirement (currency exchange reporting). It does not establish the needed result here: record a phone call and an email and verify both surface as activities on the related customer's timeline.
F:That approach is designed for external read-only price catalog: A local imported table creates a second stale copy of externally owned records. The present case instead involves a plain text table does not provide native Dataverse activity semantics.
Microsoft Power Platform Functional Consultant (PL-200) Practice Tests