External Data Storage in Microsoft Power Platform | PL-200 Exam Answer

Read-Only Table Type in Dataverse Database

Question

You create a new read-only table in the Dataverse database that has external data storage.

What is the type of this table?

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D. E.

Correct Answer: D

Dataverse provides the three types of tables (entities): Standard - this is a usual custom table type that users can create.

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.

Virtual tables have a list of limitations.

There are two most important limitations: data in these tables are read-only, and users cannot create or update records.

You need to use a classic interface for the creation of the virtual table.

From the Power Apps portal, you can access Advanced settings, and then on the Administration screen, select Virtual Entity Data Sources.

There you can create a new data source you would use for the virtual table creation (Number 2)

Then from the Solutions/Default Solutions on the Power Apps portal screen, you can select the “Switch to classic” option.

Portal will open the Dynamics 365 Default Solution screen.

In the menu tree, you choose Entities and push the New button on the tab toolbar.

You need to provide a name for the new table, check the Virtual Entity box (Number 1), and select a Data Source (Number 2).

Power Apps

@_ https://trialcb1420.crm.dynamics.com/tools/systemcustomization/entiti

Entity: New
manageentity.aspx?appSolutionid=%7bFD140AAF-4DF4-11DD-BD17...

ted Gy Save and Close 3 Show Dependencies BA Peport Solutios @Help ~
Power Apps
, Solution: Pefault Solutior fed Ee save and close @ttelp
# /& Entities File
Solution Default Solution congonait Tae (ER New Working on solution: Default Solution =

3 @) Information

§F Information yew | > Delete | [B Publish | 43 she
fig Components 10 General Primary Field
; ommon
= intities 0 Display Name + ©
@) Information Entity Definition
[8 Option sets
49] Client Extensions f& Account or potential...
@) Web Resources Display Name * WLRecord Virtual Entity
processes Action Card dec Plural Name * WLRecords “Data Source WlDataProvider ~ | Is.
~<a] Plug-in Assemblies - @ Fields Name * hnew_wirecord Ownership *
i} Sdk Message Processing S... (Activity [Fl Keys incall ” ; ri Define as an activity entity. by a user. ...
@ Service Endpoints ag 1:N Relationships eT EIN — Display in Activity M
ie isplay in Activity Menus
(53) Dashboards [A] Address $a Nt Relationships External Collection Name* —WLRecord ul ed to store.
[FE] Dialog Boxes 33 NN Rel hips Primary Image v.
3 N:N Relationships
2] Reports \@ AI Builder Dataset File i nna au Color ff
§ Connection Roles id oo Description
Bj Email Templates (Appointment rval with st...
(3) Mail Merge Templates
& Security Roles ja) Attachment
& Field Security Profiles Areas that display this entity
a peeaes ® Business Unit O training O settings |
6 Virtual Entity Data Providers & Challenge Process
G Virtual Entity Data Sources Business process flows (fields will be created) +
ie Mobile Offline Profiles 2. t
7 . Communication & Collaboration i

Pere Be es, &. Challenge Management Process agement
.& Solution Component Conf. 24 Channel Access Profile OO Feedback + fa.
@ Solution Component Relati... () Notes (includes attachments) t
& Setting Definitions [8 Channel Access Profile Rule sociating c.
@ Connection References 1
4 Help Pages fe? Channel Access Profile Rule Item 2 set for th...

Chatbots
a subcomponents @ = Chatbot bot bot Managed True Non Applicable Represents a Power Virtual Agents Chatbot. http...

Catalogs
Fr Cae Sore ‘& Component Layer Data Source — msdyn_componentlay..._msdyn_componentlay... Managed True Disabled

Custom APIs
@ Custom API Request Para... 3 Connection connection Connection Managed True Disabled Relationship between two entities.

Gp Custom API Response Pro...
_@ Organization Settings

1-50 of 84 (0 selected)

It is important to remember that you cannot change the table type after table creation.

All other options are incorrect.

For more information about Dataverse table types, please visit the below URLs:

The correct answer to the question is D. Virtual.

When creating a new table in Dataverse, you have the option to specify the data storage mode for that table. There are two main types of storage modes available in Dataverse: standard and external. Standard tables are stored within the Dataverse database, while external tables store data in an external system and provide a virtual representation of that data in Dataverse.

In the case of the question, the table has external data storage, meaning that it is a virtual table. Virtual tables are read-only by default and can be used to access data from external sources such as SQL Server, SharePoint, or Dynamics 365.

The other answer options are:

A. Standard: This option refers to tables that are stored within the Dataverse database.

B. Relational: This option is not related to the storage mode of a table. Instead, it refers to the way tables are related to each other through common fields.

C. Activity: This option is not related to the storage mode of a table. Instead, it refers to a specific type of table that is used to track activities in Dataverse.

E. System: This option refers to system tables that are used by Dataverse to manage data and metadata.