Different Table Types

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, here's a detailed explanation of each statement and whether it is correct or not:

A. An activity table can connect to the external data source

This statement is partially correct. An activity table is a type of table in the Power Platform that is used to store data related to activities, such as emails, appointments, tasks, and phone calls. An activity table can connect to an external data source, but it can only do so if that data source is a Dynamics 365 Customer Engagement instance. So, if the external data source is not a Dynamics 365 Customer Engagement instance, then this statement is incorrect.

B. A virtual table needs a data provider and data source

This statement is correct. A virtual table is a type of table in the Power Platform that is created by defining a data provider and a data source. The data provider is responsible for defining the schema of the virtual table, while the data source is responsible for providing the data that the virtual table will contain. Without both a data provider and data source, a virtual table cannot be created.

C. You can convert an existing standard table to a virtual table

This statement is incorrect. Once a table is created as a standard table, it cannot be converted to a virtual table. However, you can create a virtual table that is based on the schema of a standard table, but this involves creating a new virtual table and defining a data provider and data source for it.

D. You cannot change the ownership of the standard table after its creation

This statement is partially correct. By default, the owner of a standard table is the user who created it. This ownership can be changed by someone with the appropriate permissions. However, once a standard table is included in a solution, its ownership cannot be changed unless it is removed from the solution first. So, if the standard table has not been included in a solution, then this statement is incorrect.