Table Types: Exploring Different Types in Microsoft Power Platform

Different Table Types in Microsoft Power Platform

Question

Please select all correct statements about the different table types.

Answers

Explanations

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.

  1. Standard Tables: Standard tables are the most commonly used tables in Power Platform. They are used to store data within the environment and are often used to represent a single entity or object. Standard tables can be created, updated, and deleted using the Power Apps maker portal or using Power Automate. Standard tables are the simplest type of table and do not require any external data source.

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.

  1. Activity Tables: Activity tables are similar to standard tables but are designed specifically to track activities, such as emails, appointments, and phone calls. Activity tables can connect to external data sources, such as Outlook or Exchange, to capture activity data automatically.

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.

  1. Virtual Tables: Virtual tables are created by using a data provider and a data source. They are used to expose data from external systems to Power Platform users. Virtual tables can be used to display data from a variety of sources, including SQL Server, SharePoint, and Salesforce.

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.