PL-200 EXAM: MICROSOFT POWER PLATFORM
FUNCTIONAL CONSULTANT
Standard or Complex - Answer -Types of tables
Standard Table Type - Answer -Base set of tables that are created for every instance of
a Microsoft Dataverse database. You can add more columns to any table, but you can
only delete columns from a custom table.
Advanced Find - Answer -When a user is making a personal view or doing an
improvised advanced search, this will be the default view of the search results. This
system view is editable, but there can only be one per entity. When a user is in
Advanced Find and changes the columns, it can be saved and shared as a personal
view.
Alternate Key - Answer -A unique field or combination of fields that identify a record.
Always Indexed. Limit of 5 per table.
Associated View - Answer -Users view data on records from the host entity but can
also view related entities. When selected these related data tables load on the host form
in a new tab. Each entity can have more than one.
Basic User Role - Answer -Can run an app within the environment and perform
common tasks for the records that they own. Note that this only applies to non-custom
entities.
Bing Maps - Answer -Can be displayed on a form for the account, contact, lead, quote,
order, invoice, competitor, and system user entities.
Business logic with code - Answer -Supports advanced developer scenarios that
extend the application directly through code.
Business process flows - Answer -Guide users to ensure they enter data consistently
and follow the same steps every time. Business process flows are currently supported
only for model-driven apps.
Business Rules - Answer -Allow you to apply and maintain business logic at the data
layer instead of the app layer. If you create business rules in Microsoft Dataverse, they
are in effect regardless of where you interact with the data. Validate data across
multiple columns in a table, and provide warning and error messages, regardless of the
app that's used to create the data.
Business rules that can be used by canvas and model driven apps - Answer -Set
column values, Clear column values, Validate data and show error messages
, Business rules that can be used model driven apps only - Answer -Show or hide
columns, Enable or disable columns, Create business recommendations based on
business intelligence
Card - Answer -Shows the field's label and value. Each card represents a single field of
a record. Configured to show key fields at a glance in the entity feed. There are several
options available to configure including color coding based on criteria such as record
status. Use to display form data on a dashboard.
Charts - Answer -These controls let you add charts so that users can perform instant
analysis while they're on the road. Types include Column, Bar, Area, Line, Pie, Funnel,
Tag and Doughnut
Choices - Answer -A list of options that are displayed by using a drop-down menu
during data entry. Best suited for a small set of standard short terms rather than long list
of complex entries. Can choose from over 100 standard choices or create a list. Custom
lists can be either global (default) or made local to the table.
Classic Administration Center (Solution Explorer) - Answer -Full set of admin
capabilities, not all have been migrated to the new portal. Can access by going to
Advanced Settings -> Customizations -> Customize the System in the Admin Center.
Columns - Answer -A way to store a discrete piece of information within a row in a
table. You might think of them as a column in Excel. Columns have data types, meaning
that you can store data of a certain type in a column that matches that data type.
Complex Table Type - Answer -Tables that contain complex, server-side business
logic, including real-time workflows or plug-ins. Some of the tables that are used in
Dynamics 365 applications are complex. Care must be taken if you add server-side
logic to ensure that users have the proper license to use the complex table.
Compound Key - Answer -Unique value for a row made up of a combination of two or
more column values.
Custom Table Type - Answer -Created for a specific business application. All licensed
users of Dataverse can access custom tables if they are assigned proper security
permissions to do so.
Dashboard - Answer -Shows several areas of d365 on a single display. Designed for a
specific job role or department.
Data Type: Autonumber - Answer -Can be a String prefixed number, a date prefixed
number or a custom format. Can also choose a seed value to start numbering from.
FUNCTIONAL CONSULTANT
Standard or Complex - Answer -Types of tables
Standard Table Type - Answer -Base set of tables that are created for every instance of
a Microsoft Dataverse database. You can add more columns to any table, but you can
only delete columns from a custom table.
Advanced Find - Answer -When a user is making a personal view or doing an
improvised advanced search, this will be the default view of the search results. This
system view is editable, but there can only be one per entity. When a user is in
Advanced Find and changes the columns, it can be saved and shared as a personal
view.
Alternate Key - Answer -A unique field or combination of fields that identify a record.
Always Indexed. Limit of 5 per table.
Associated View - Answer -Users view data on records from the host entity but can
also view related entities. When selected these related data tables load on the host form
in a new tab. Each entity can have more than one.
Basic User Role - Answer -Can run an app within the environment and perform
common tasks for the records that they own. Note that this only applies to non-custom
entities.
Bing Maps - Answer -Can be displayed on a form for the account, contact, lead, quote,
order, invoice, competitor, and system user entities.
Business logic with code - Answer -Supports advanced developer scenarios that
extend the application directly through code.
Business process flows - Answer -Guide users to ensure they enter data consistently
and follow the same steps every time. Business process flows are currently supported
only for model-driven apps.
Business Rules - Answer -Allow you to apply and maintain business logic at the data
layer instead of the app layer. If you create business rules in Microsoft Dataverse, they
are in effect regardless of where you interact with the data. Validate data across
multiple columns in a table, and provide warning and error messages, regardless of the
app that's used to create the data.
Business rules that can be used by canvas and model driven apps - Answer -Set
column values, Clear column values, Validate data and show error messages
, Business rules that can be used model driven apps only - Answer -Show or hide
columns, Enable or disable columns, Create business recommendations based on
business intelligence
Card - Answer -Shows the field's label and value. Each card represents a single field of
a record. Configured to show key fields at a glance in the entity feed. There are several
options available to configure including color coding based on criteria such as record
status. Use to display form data on a dashboard.
Charts - Answer -These controls let you add charts so that users can perform instant
analysis while they're on the road. Types include Column, Bar, Area, Line, Pie, Funnel,
Tag and Doughnut
Choices - Answer -A list of options that are displayed by using a drop-down menu
during data entry. Best suited for a small set of standard short terms rather than long list
of complex entries. Can choose from over 100 standard choices or create a list. Custom
lists can be either global (default) or made local to the table.
Classic Administration Center (Solution Explorer) - Answer -Full set of admin
capabilities, not all have been migrated to the new portal. Can access by going to
Advanced Settings -> Customizations -> Customize the System in the Admin Center.
Columns - Answer -A way to store a discrete piece of information within a row in a
table. You might think of them as a column in Excel. Columns have data types, meaning
that you can store data of a certain type in a column that matches that data type.
Complex Table Type - Answer -Tables that contain complex, server-side business
logic, including real-time workflows or plug-ins. Some of the tables that are used in
Dynamics 365 applications are complex. Care must be taken if you add server-side
logic to ensure that users have the proper license to use the complex table.
Compound Key - Answer -Unique value for a row made up of a combination of two or
more column values.
Custom Table Type - Answer -Created for a specific business application. All licensed
users of Dataverse can access custom tables if they are assigned proper security
permissions to do so.
Dashboard - Answer -Shows several areas of d365 on a single display. Designed for a
specific job role or department.
Data Type: Autonumber - Answer -Can be a String prefixed number, a date prefixed
number or a custom format. Can also choose a seed value to start numbering from.
