Question 1
At Silvercrest University, the research IT team is implementing a laboratory scheduling app under requirements for research data controls. The architecture review finds: A field-service app needs an address lookup from an external system without copying the external catalog into Dataverse every hour. Which change BEST resolves this specific problem?
Explanation
Correct Answer
Choose a virtual table with a supported provider when live external rows must appear in Dataverse without replication. This specifically addresses A field-service app needs an address lookup from an external system without copying the external catalog into Dataverse every hour. For Silvercrest University, the design decision changes the underlying Power Platform solution behavior rather than an unrelated surface setting. A measurable acceptance result is: A field-service record opens current external catalog values while no duplicate catalog rows are stored locally.
Incorrect Answers
Use deterministic validated code or rules for the hard compliance threshold and reserve generative AI for nonbinding assistance. This is a plausible technique for a DIFFERENT requirement: A prototype relies on a generative model to determine whether a statutory hard limit is exceeded. The Silvercrest University failure described here instead concerns A field-service app needs an address lookup from an external system without copying the external catalog into Dataverse every hour. That choice does not establish the required correction; the acceptance result must be: A field-service record opens current external catalog values while no duplicate catalog rows are stored locally.
Move the authoritative calculation to deterministic server-side Dataverse logic and use client scripting only for presentation. This is a plausible technique for a DIFFERENT requirement: A team proposes client-side JavaScript for a finance calculation that must remain authoritative during batch integrations. The Silvercrest University failure described here instead concerns A field-service app needs an address lookup from an external system without copying the external catalog into Dataverse every hour. That choice does not establish the required correction; the acceptance result must be: A field-service record opens current external catalog values while no duplicate catalog rows are stored locally.
Evaluate an elastic table and its partitioning and consistency characteristics against the workload instead of defaulting to a standard table. This is a plausible technique for a DIFFERENT requirement: A cross-department app must store high-volume short-lived telemetry that would overwhelm a standard transactional Dataverse table. The Silvercrest University failure described here instead concerns A field-service app needs an address lookup from an external system without copying the external catalog into Dataverse every hour. That choice does not establish the required correction; the acceptance result must be: A field-service record opens current external catalog values while no duplicate catalog rows are stored locally.