100% Latest & Updated Microsoft PL-200 Practice Test Questions, Exam Dumps & Verified Answers!
30 Days Free Updates, Instant Download!
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.
Question 51
An international account report shows different totals for base and transaction currencies; the designer added raw currency values without conversion. Which underlying design issue accounts for the observed behavior?
- Manually entered derived values become stale and violate a single source of truth.
- A text field cannot enforce a referential link to the parent account row.
- The column was not added as a required solution component before export.
- Transaction currency amounts are being mixed without a consistent base-currency comparison.
Explanation
Correct Answer
D:Preserve Dataverse currency and exchange-rate metadata and report using a consistent currency basis. The observed cause is: Transaction currency amounts are being mixed without a consistent base-currency comparison.
Incorrect Answers
A:Applying this would shift attention to formula per-row calculation without testing the actual fault. Transaction currency amounts are being mixed without a consistent base-currency comparison.
B:That choice can be relevant to account–contact one-to-many, but its assumptions are absent from this case. Here the direct diagnosis is transaction currency amounts are being mixed without a consistent base-currency comparison.
C:This choice targets solution component missing column and leaves the described requirement unproven. The case calls for transaction currency amounts are being mixed without a consistent base-currency comparison.
Question 52
An international account report shows different totals for base and transaction currencies; the designer added raw currency values without conversion. Which targeted change best addresses this requirement?
- Use appropriate activity table types and associate activity regarding records with the customer.
- Preserve Dataverse currency and exchange-rate metadata and report using a consistent currency basis.
- Use a supported integration or calculation at the external source and persist only necessary derived results.
- Replace the text entry with a Contact-to-Account lookup using the native one-to-many relationship.
Explanation
Correct Answer
B:Preserve Dataverse currency and exchange-rate metadata and report using a consistent currency basis. This addresses: Transaction currency amounts are being mixed without a consistent base-currency comparison.
Incorrect Answers
A:This choice targets activity history on a customer and leaves the described requirement unproven. The case calls for preserve Dataverse currency and exchange-rate metadata and report using a consistent currency basis.
C:That approach is designed for computed field external source: Virtual-table columns do not support normal Dataverse rollup and calculated column behavior. The present case instead involves transaction currency amounts are being mixed without a consistent base-currency comparison.
D:Applying this would shift attention to account–contact one-to-many without testing the actual fault. Transaction currency amounts are being mixed without a consistent base-currency comparison.
Question 53
An international account report shows different totals for base and transaction currencies; the designer added raw currency values without conversion. What test would most clearly distinguish a successful fix from a superficial change?
- 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.
- Record a phone call and an email and verify both surface as activities on the related customer's timeline.
- Reimport the same external ID and confirm one row is updated rather than a second row created.
Explanation
Correct Answer
A:Create rows with two currencies and confirm base values and selected report totals reconcile with applicable rates. This tests actual behavior, not just configuration presence.
Incorrect Answers
B:This would respond to a different requirement (required lookup migration). It does not establish the needed result here: create rows with two currencies and confirm base values and selected report totals reconcile with applicable rates.
C: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 transaction currency amounts are being mixed without a consistent base-currency comparison.
D:This choice targets alternate key duplicate external id and leaves the described requirement unproven. The case calls for create rows with two currencies and confirm base values and selected report totals reconcile with applicable rates.
Question 54
An international account report shows different totals for base and transaction currencies; the designer added raw currency values without conversion. What repeatable design control fits the root cause?
- Include mandatory-field impact analysis in schema change and deployment plans.
- Record virtual-table limitations, provider authorization, latency and source availability as design constraints.
- Specify reporting currency and exchange-rate provenance in financial solution requirements.
- Distinguish time instants from date-only business attributes in schema standards.
Explanation
Correct Answer
C:Specify reporting currency and exchange-rate provenance in financial solution requirements. This helps prevent recurrence of: Transaction currency amounts are being mixed without a consistent base-currency comparison.
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 transaction currency amounts are being mixed without a consistent base-currency comparison.
B:The proposed step addresses external read-only price catalog, not the constraint in this scenario. The decisive issue is that transaction currency amounts are being mixed without a consistent base-currency comparison.
D:This would respond to a different requirement (timezone date reporting). It does not establish the needed result here: specify reporting currency and exchange-rate provenance in financial solution requirements.
Question 55
An international account report shows different totals for base and transaction currencies; the designer added raw currency values without conversion. Select TWO steps that both address this case and prove the desired behavior.
- Create rows with two currencies and confirm base values and selected report totals reconcile with applicable rates.
- Retrieve a source-side change log and prove that the required actor, action and timestamp are retained.
- Use Remove Link for the delete action on an optional lookup so the inquiries remain with an empty parent reference.
- Preserve Dataverse currency and exchange-rate metadata and report using a consistent currency basis.
- Record virtual-table limitations, provider authorization, latency and source availability as design constraints.
Explanation
Correct Answers
A:Create rows with two currencies and confirm base values and selected report totals reconcile with applicable rates. This is required evidence before closure.
D:Preserve Dataverse currency and exchange-rate metadata and report using a consistent currency basis. This directly addresses: Transaction currency amounts are being mixed without a consistent base-currency comparison.
Incorrect Answers
B:The proposed step addresses virtual-table auditing request, not the constraint in this scenario. The decisive issue is that transaction currency amounts are being mixed without a consistent base-currency comparison.
C:This would respond to a different requirement (account removal without child deletion). It does not establish the needed result here: preserve Dataverse currency and exchange-rate metadata and report using a consistent currency basis.
E:That choice can be relevant to external read-only price catalog, but its assumptions are absent from this case. Here the direct recurrence control is specify reporting currency and exchange-rate provenance in financial solution requirements.
Question 56
Incident severity is entered as free text, yielding 'Severe', 'severe' and 'high' values that break filters. Which explanation best fits the described evidence?
- Reparenting cascade behavior propagates relationship changes to children beyond the intended boundary.
- The relationship's delete behavior would delete the inquiries along with the account.
- The table lacks an enforced alternate key on the stable external identifier.
- An unconstrained text column allows synonymous labels that are not one controlled classification.
Explanation
Correct Answer
D:Replace the text field with an appropriate Dataverse choice column and migrate historical values through a mapping. The observed cause is: An unconstrained text column allows synonymous labels that are not one controlled classification.
Incorrect Answers
A:Applying this would shift attention to missing cascading reparent behavior without testing the actual fault. An unconstrained text column allows synonymous labels that are not one controlled classification.
B:The proposed step addresses account removal without child deletion, not the constraint in this scenario. The decisive issue is that an unconstrained text column allows synonymous labels that are not one controlled classification.
C:That choice can be relevant to alternate key duplicate external id, but its assumptions are absent from this case. Here the direct diagnosis is an unconstrained text column allows synonymous labels that are not one controlled classification.
Question 57
Incident severity is entered as free text, yielding 'Severe', 'severe' and 'high' values that break filters. Which implementation decision best fixes the stated problem?
- Configure a supported rollup column to aggregate qualifying related orders and communicate its calculation schedule.
- Review and restrict Reparent cascade to match the organization's row-security model.
- Evaluate a Dataverse virtual table backed by a supported external data provider and document its feature limitations.
- Replace the text field with an appropriate Dataverse choice column and migrate historical values through a mapping.
Explanation
Correct Answer
D:Replace the text field with an appropriate Dataverse choice column and migrate historical values through a mapping. This addresses: An unconstrained text column allows synonymous labels that are not one controlled classification.
Incorrect Answers
A:That choice can be relevant to rollup child totals, but its assumptions are absent from this case. Here the direct corrective action is replace the text field with an appropriate Dataverse choice column and migrate historical values through a mapping.
B:Applying this would shift attention to missing cascading reparent behavior without testing the actual fault. An unconstrained text column allows synonymous labels that are not one controlled classification.
C:This choice targets external read-only price catalog and leaves the described requirement unproven. The case calls for replace the text field with an appropriate Dataverse choice column and migrate historical values through a mapping.
Question 58
Incident severity is entered as free text, yielding 'Severe', 'severe' and 'high' values that break filters. What test would most clearly distinguish a successful fix from a superficial change?
- Validate migrated tickets have valid location references, then confirm new tickets cannot be saved without one.
- Review the same stored instant for users in two time zones and confirm the report follows the defined date rule.
- Import sample legacy labels and verify each maps to a permitted choice value in views and reports.
- Save known fractional test values and check stored values and reporting totals for expected precision.
Explanation
Correct Answer
C:Import sample legacy labels and verify each maps to a permitted choice value in views and reports. This tests actual behavior, not just configuration presence.
Incorrect Answers
A:Applying this would shift attention to required lookup migration without testing the actual fault. An unconstrained text column allows synonymous labels that are not one controlled classification.
B:This choice targets timezone date reporting and leaves the described requirement unproven. The case calls for import sample legacy labels and verify each maps to a permitted choice value in views and reports.
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 an unconstrained text column allows synonymous labels that are not one controlled classification.
Question 59
Incident severity is entered as free text, yielding 'Severe', 'severe' and 'high' values that break filters. Which governance practice most directly protects this requirement over time?
- Use dependency and component inventories during solution release reviews.
- Specify numeric precision and rounding rules with finance stakeholders before schema creation.
- Distinguish optional references from required references before configuring relationship actions.
- Govern the choice taxonomy and retire ad-hoc text values after a validated migration.
Explanation
Correct Answer
D:Govern the choice taxonomy and retire ad-hoc text values after a validated migration. This helps prevent recurrence of: An unconstrained text column allows synonymous labels that are not one controlled classification.
Incorrect Answers
A:That approach is designed for solution component missing column: The column was not added as a required solution component before export. The present case instead involves an unconstrained text column allows synonymous labels that are not one controlled classification.
B:This choice targets currency precision concern and leaves the described requirement unproven. The case calls for govern the choice taxonomy and retire ad-hoc text values after a validated migration.
C:This would respond to a different requirement (account removal without child deletion). It does not establish the needed result here: govern the choice taxonomy and retire ad-hoc text values after a validated migration.
Question 60
Incident severity is entered as free text, yielding 'Severe', 'severe' and 'high' values that break filters. Which THREE steps are justified for a complete controlled response? Select THREE.
- Replace the text field with an appropriate Dataverse choice column and migrate historical values through a mapping.
- Govern the choice taxonomy and retire ad-hoc text values after a validated migration.
- Distinguish optional references from required references before configuring relationship actions.
- Plan a staged migration that populates or resolves missing locations before enforcing requiredness.
- Add and edit related orders, force or await the rollup recalculation and compare with the expected sum.
- Import sample legacy labels and verify each maps to a permitted choice value in views and reports.
Explanation
Correct Answers
A:Replace the text field with an appropriate Dataverse choice column and migrate historical values through a mapping. This directly addresses: An unconstrained text column allows synonymous labels that are not one controlled classification.
B:Govern the choice taxonomy and retire ad-hoc text values after a validated migration. This reduces recurrence of: An unconstrained text column allows synonymous labels that are not one controlled classification.
F:Import sample legacy labels and verify each maps to a permitted choice value in views and reports. This is required evidence before closure.
Incorrect Answers
C:The proposed step addresses account removal without child deletion, not the constraint in this scenario. The decisive issue is that an unconstrained text column allows synonymous labels that are not one controlled classification.
D: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 an unconstrained text column allows synonymous labels that are not one controlled classification.
E:This would respond to a different requirement (rollup child totals). It does not establish the needed result here: import sample legacy labels and verify each maps to a permitted choice value in views and reports.
Microsoft Power Platform Functional Consultant (PL-200) Practice Tests