Exam PL-100 topic 2 question 39 discussion

Actual exam question from Microsoft's PL-100

Question #: 39
Topic #: 2

DRAG DROP -
You are designing a data model for a new app. The app will be supported by two tables. TableA will contain data that is unique to your industry. TableB will provide access to read-only data from an Azure SQL database.
You need to configure the tables.
Which table type should you use? To answer, drag the appropriate table types to the correct tables. Each table type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Show Suggested Answer

Suggested Answer:

Box 1: Custom -
Custom: Custom tables are unmanaged tables that are either imported from an unmanaged solution or are new tables created directly in the environment. Any user with appropriate privileges can fully customize these tables.

Box 2: Virtual -
A virtual table is a custom table in Dataverse that has columns containing data from an external data source. Virtual tables appear in your app to users as regular table rows, but contain data that is sourced from an external database dynamically at runtime, such as an Azure SQL Database. Rows based on virtual tables are available in all clients including custom clients developed using the Dataverse web services.
Incorrect:
* Standard: Several standard tables, also known as out-of-box tables, are included with a Power Platform environment, that includes Microsoft Dataverse.
Account, business unit, contact, task, and user tables are examples of standard tables in Dataverse.
Reference:
https://docs.microsoft.com/en-us/power-apps/maker/data-platform/types-of-entities

by et_learner at Sept. 10, 2022, 7:16 a.m.

Comments

Submit Cancel

Edriska

Highly Voted 1 year, 12 months ago

The answer is: Table A: Custom Table B: Virtual You should use a custom table for Table A because it will contain data that is unique to your industry and not based on any existing table. Custom tables allow you to define your own fields, relationships, and business logic. You should use a virtual table for Table B because it will provide access to read-only data from an Azure SQL database. Virtual tables allow you to connect to external data sources and use them as if they were native tables in your app.

upvoted 6 times

...

AP2020

Most Recent 2 years, 5 months ago

Correct

upvoted 1 times

...

SHNH

2 years, 5 months ago

@stokazz standard tables are ootb tables, custom tables are the ones you create and Table A's is 'unique to your industry' so it is a table that you have created and does not already pre-exist.

upvoted 3 times

...