PL-200 · Question #287
A company is evaluating the capabilities in Dataverse and the scenarios for using virtual tables. You need to identify the capabilities of virtual tables. What is a capability of virtual tables?
The correct answer is B. Virtual tables retrieve data from an external data source. The defining capability of virtual tables in Dataverse is that they retrieve data in real time from an external data source without storing that data inside Dataverse.
Question
Options
- AVirtual tables store data in the Dataverse environment.
- BVirtual tables retrieve data from an external data source.
- CVirtual tables can be configured for user and team ownership.
- DVirtual tables support Dataverse auditing.
How the community answered
(55 responses)- A4% (2)
- B95% (52)
- C2% (1)
Why each option
The defining capability of virtual tables in Dataverse is that they retrieve data in real time from an external data source without storing that data inside Dataverse.
Virtual tables do not store data in the Dataverse environment - data remains in the external source and is only read through the virtual table provider at query time.
Virtual tables (also called virtual entities) use a data provider to connect to an external data source and retrieve records on demand at query time, meaning the data is never physically written into the Dataverse database. This allows the external data to appear as a standard Dataverse table and be used in model-driven apps and other Power Platform components without data duplication. The external system remains the authoritative data store, and changes there are reflected immediately when the virtual table is queried.
Virtual tables only support organization ownership and do not support user or team ownership, which is a known limitation compared to standard Dataverse tables.
Dataverse auditing is not supported for virtual tables because audit logs require data to be written to Dataverse, which virtual tables bypass.
Concept tested: Dataverse virtual tables external data retrieval capability
Source: https://learn.microsoft.com/en-us/power-apps/maker/data-platform/create-edit-virtual-entities
Topics
Community Discussion
No community discussion yet for this question.