100% Latest & Updated Microsoft PL-200 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
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.
Question 31
A pricing service remains the system of record; the team wants a model-driven read-through table without importing snapshots. What is the most directly supported diagnosis?
- The account total is denormalized and updated only by users, so related-order changes are missed.
- Delete cascade is configured to remove related rows instead of blocking deletion.
- A local imported table creates a second stale copy of externally owned records.
- The table lacks an enforced alternate key on the stable external identifier.
Explanation
Correct Answer
C:Evaluate a Dataverse virtual table backed by a supported external data provider and document its feature limitations. The observed cause is: A local imported table creates a second stale copy of externally owned records.
Incorrect Answers
A:The proposed step addresses rollup child totals, not the constraint in this scenario. The decisive issue is that a local imported table creates a second stale copy of externally owned records.
B:That choice can be relevant to delete protected contract parent, but its assumptions are absent from this case. Here the direct diagnosis is a local imported table creates a second stale copy of externally owned records.
D:This would respond to a different requirement (alternate key duplicate external id). It does not establish the needed result here: a local imported table creates a second stale copy of externally owned records.
Question 32
A pricing service remains the system of record; the team wants a model-driven read-through table without importing snapshots. Which implementation decision best fixes the stated problem?
- Evaluate a Dataverse virtual table backed by a supported external data provider and document its feature limitations.
- 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.
- Add the intended column and dependencies to the source solution and export a new version for deployment.
Explanation
Correct Answer
A:Evaluate a Dataverse virtual table backed by a supported external data provider and document its feature limitations. This addresses: A local imported table creates a second stale copy of externally owned records.
Incorrect Answers
B:That choice can be relevant to supplier multiparty membership, but its assumptions are absent from this case. Here the direct corrective action is evaluate a Dataverse virtual table backed by a supported external data provider and document its feature limitations.
C:Applying this would shift attention to rollup child totals without testing the actual fault. A local imported table creates a second stale copy of externally owned records.
D:The proposed step addresses solution component missing column, not the constraint in this scenario. The decisive issue is that a local imported table creates a second stale copy of externally owned records.
Question 33
A pricing service remains the system of record; the team wants a model-driven read-through table without importing snapshots. Which observation would confirm the proposed design works as intended?
- Change a price in the source and verify the virtual-table view reflects the external value without an import job.
- Create contacts for two accounts and verify each lookup resolves to exactly one account while an account can display multiple related contacts.
- Create rows with two currencies and confirm base values and selected report totals reconcile with applicable rates.
- Validate migrated tickets have valid location references, then confirm new tickets cannot be saved without one.
Explanation
Correct Answer
A:Change a price in the source and verify the virtual-table view reflects the external value without an import job. This tests actual behavior, not just configuration presence.
Incorrect Answers
B:Applying this would shift attention to account–contact one-to-many without testing the actual fault. A local imported table creates a second stale copy of externally owned records.
C:This choice targets currency exchange reporting and leaves the described requirement unproven. The case calls for change a price in the source and verify the virtual-table view reflects the external value without an import job.
D:That choice can be relevant to required lookup migration, but its assumptions are absent from this case. Here the direct discriminating test is change a price in the source and verify the virtual-table view reflects the external value without an import job.
Question 34
A pricing service remains the system of record; the team wants a model-driven read-through table without importing snapshots. What repeatable design control fits the root cause?
- Require relational lookups for parent references and review relationship metadata before imports.
- Record virtual-table limitations, provider authorization, latency and source availability as design constraints.
- Capture audit requirements for activity history and avoid replacing activity records with unstructured notes.
- Specify reporting currency and exchange-rate provenance in financial solution requirements.
Explanation
Correct Answer
B:Record virtual-table limitations, provider authorization, latency and source availability as design constraints. This helps prevent recurrence of: A local imported table creates a second stale copy of externally owned records.
Incorrect Answers
A:That approach is designed for account–contact one-to-many: A text field cannot enforce a referential link to the parent account row. The present case instead involves a local imported table creates a second stale copy of externally owned records.
C:This choice targets activity history on a customer and leaves the described requirement unproven. The case calls for record virtual-table limitations, provider authorization, latency and source availability as design constraints.
D:Applying this would shift attention to currency exchange reporting without testing the actual fault. A local imported table creates a second stale copy of externally owned records.
Question 35
A pricing service remains the system of record; the team wants a model-driven read-through table without importing snapshots. Which TWO measures together implement the targeted correction and verify its result? Select TWO.
- Review the same stored instant for users in two time zones and confirm the report follows the defined date rule.
- Change a price in the source and verify the virtual-table view reflects the external value without an import job.
- Evaluate a Dataverse virtual table backed by a supported external data provider and document its feature limitations.
- Distinguish time instants from date-only business attributes in schema standards.
- Model supplier–group membership with a many-to-many relationship or an explicit junction table if membership needs attributes.
Explanation
Correct Answers
B:Change a price in the source and verify the virtual-table view reflects the external value without an import job. This is required evidence before closure.
C:Evaluate a Dataverse virtual table backed by a supported external data provider and document its feature limitations. This directly addresses: A local imported table creates a second stale copy of externally owned records.
Incorrect Answers
A:That approach is designed for timezone date reporting: User-local timezone conversion changes the displayed calendar date across time zones. The present case instead involves a local imported table creates a second stale copy of externally owned records.
D:This would respond to a different requirement (timezone date reporting). It does not establish the needed result here: record virtual-table limitations, provider authorization, latency and source availability as design constraints.
E:This choice targets supplier multiparty membership and leaves the described requirement unproven. The case calls for evaluate a Dataverse virtual table backed by a supported external data provider and document its feature limitations.
Question 36
Compliance requires Dataverse row auditing on a proposed virtual inventory table that reads an external service. What is the most directly supported diagnosis?
- Delete cascade is configured to remove related rows instead of blocking deletion.
- Transaction currency amounts are being mixed without a consistent base-currency comparison.
- Manually entered derived values become stale and violate a single source of truth.
- Dataverse virtual tables do not support ordinary local row auditing.
Explanation
Correct Answer
D:Keep audit events in the underlying source or persist audit-relevant transactions in a supported local Dataverse table. The observed cause is: Dataverse virtual tables do not support ordinary local row auditing.
Incorrect Answers
A:The proposed step addresses delete protected contract parent, not the constraint in this scenario. The decisive issue is that dataverse virtual tables do not support ordinary local row auditing.
B:That approach is designed for currency exchange reporting: Transaction currency amounts are being mixed without a consistent base-currency comparison. The present case instead involves dataverse virtual tables do not support ordinary local row auditing.
C:This would respond to a different requirement (formula per-row calculation). It does not establish the needed result here: dataverse virtual tables do not support ordinary local row auditing.
Question 37
Compliance requires Dataverse row auditing on a proposed virtual inventory table that reads an external service. Which implementation decision best fixes the stated problem?
- Use appropriate activity table types and associate activity regarding records with the customer.
- Review and restrict Reparent cascade to match the organization's row-security model.
- Replace the text field with an appropriate Dataverse choice column and migrate historical values through a mapping.
- Keep audit events in the underlying source or persist audit-relevant transactions in a supported local Dataverse table.
Explanation
Correct Answer
D:Keep audit events in the underlying source or persist audit-relevant transactions in a supported local Dataverse table. This addresses: Dataverse virtual tables do not support ordinary local row auditing.
Incorrect Answers
A: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 keep audit events in the underlying source or persist audit-relevant transactions in a supported local Dataverse table.
B:This would respond to a different requirement (missing cascading reparent behavior). It does not establish the needed result here: keep audit events in the underlying source or persist audit-relevant transactions in a supported local Dataverse table.
C:The proposed step addresses choice value normalization, not the constraint in this scenario. The decisive issue is that dataverse virtual tables do not support ordinary local row auditing.
Question 38
Compliance requires Dataverse row auditing on a proposed virtual inventory table that reads an external service. Which acceptance check should the team use?
- Move one test record and compare effective access before and after for related rows.
- Retrieve a source-side change log and prove that the required actor, action and timestamp are retained.
- Review the same stored instant for users in two time zones and confirm the report follows the defined date rule.
- Save known fractional test values and check stored values and reporting totals for expected precision.
Explanation
Correct Answer
B:Retrieve a source-side change log and prove that the required actor, action and timestamp are retained. This tests actual behavior, not just configuration presence.
Incorrect Answers
A:That choice can be relevant to missing cascading reparent behavior, but its assumptions are absent from this case. Here the direct discriminating test is retrieve a source-side change log and prove that the required actor, action and timestamp are retained.
C:The proposed step addresses timezone date reporting, not the constraint in this scenario. The decisive issue is that dataverse virtual tables do not support ordinary local row auditing.
D:Applying this would shift attention to currency precision concern without testing the actual fault. Dataverse virtual tables do not support ordinary local row auditing.
Question 39
Compliance requires Dataverse row auditing on a proposed virtual inventory table that reads an external service. Which preventive practice best reduces recurrence of this issue?
- Flag virtual-table feature restrictions before promising native Dataverse auditing or search.
- Use dependency and component inventories during solution release reviews.
- Distinguish optional references from required references before configuring relationship actions.
- Capture audit requirements for activity history and avoid replacing activity records with unstructured notes.
Explanation
Correct Answer
A:Flag virtual-table feature restrictions before promising native Dataverse auditing or search. This helps prevent recurrence of: Dataverse virtual tables do not support ordinary local row auditing.
Incorrect Answers
B:This choice targets solution component missing column and leaves the described requirement unproven. The case calls for flag virtual-table feature restrictions before promising native Dataverse auditing or search.
C: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 choice can be relevant to activity history on a customer, but its assumptions are absent from this case. Here the direct recurrence control is flag virtual-table feature restrictions before promising native Dataverse auditing or search.
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.
Microsoft Power Platform Functional Consultant (PL-200) Practice Tests