Please select all correct statements about the different table types.
Click on the arrows to vote for the correct answer
A. B. C. D.Correct Answers: B and D
The Dataverse provides the three types of tables: Standard - this is a custom table type that users create the most.
These tables store data and navigation for model-driven apps.
Activity - this is a special custom table type for storing activity information like appointments, phone calls, emails, tasks, etc.
Virtual - this custom table type has columns that bring data from external sources, like Azure SQL Database or Azure Cosmos DB.Option B is correct because a virtual table requires the data provider and data source.
You need to create a custom data provider or use an OData Data provider.
For the custom data provider, you develop and register the plug-in that, using the data source, brings data to the Dataverse virtual table.
Option D is correct because after you create a standard table with one of the ownership types: user (group) or organization, you cannot change it.
Option A is incorrect because an activity table does not have access to the external data.
This table type provides the columns that help you properly store the data, such as start and end time, duration, due date.
Also, the Dataverse provides columns to capture the activity purpose, like subject and description.
Option C is incorrect because you cannot change the table type after table creation.
For more information about the Dataverse table types, please visit the below URLs:
Sure, I'd be happy to explain the different types of tables in Power Platform and the correctness of each statement.
D. You can not change the ownership of the standard table after its creation. This statement is correct. Once a standard table is created, you cannot change its ownership. The owner of the table is the person who created it, and this ownership cannot be transferred to another person or entity.
A. An activity table can connect to the external data source This statement is correct. Activity tables can connect to external data sources, such as Outlook or Exchange, to capture activity data automatically.
B. A virtual table needs a data provider and data source This statement is correct. To create a virtual table, you need to have a data provider and a data source. The data provider defines how the data is accessed and the data source defines where the data is located.
C. You can convert an existing standard table to a virtual table This statement is incorrect. You cannot convert an existing standard table to a virtual table. Instead, you must create a new virtual table and define the data provider and data source for it.
In summary, the correct statements are A, B, and D.