Microsoft PL-200 Exam Questions
Microsoft Power Platform Functional Consultant (Page 9 )

Updated On: 13-Jun-2026

DRAG DROP (Drag and Drop is not supported)

A company uses Power Apps.

You create a custom table and configure a child table relationship with the contact table.
You need to configure the cascading rules for each action.

Which behavior should you use? To answer, drag the appropriate behaviors to the correct actions. Each behavior 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:

  1. See Explanation section for answer.

Answer(s): A

Explanation:





Box 1: Cascade All
Cascade All
Perform the action on all referencing table records associated with the referenced table record.

Box 2: Restrict
Restrict
Prevent the Referenced table record from being deleted when referencing tables exist.

Incorrect:
Cascade None
Do nothing.


Reference:

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/configure-entity-relationship- cascading-behavior



You plan to add a Power Apps app to Microsoft Teams.

A Microsoft Dataverse for Teams environment has not been provisioned.

You need to create a Dataverse for Teams environment.

Which two actions can you perform? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

  1. Create a new app in Teams.
  2. Install an existing app in Teams.
  3. Create a new environment in the Microsoft Power Platform Admin Center.
  4. Create an app permission policy in the Teams admin center.

Answer(s): A,B

Explanation:

Provisioning Dataverse for Teams
Dataverse for Teams is provisioned in Teams automatically when you create an app or install one of the pre- made sample or template apps for Teams.
Build an app
The first way to provision Dataverse for Teams in Teams is to create a new app.
Install a sample app
The second way to provision Dataverse for Teams in your team is by installing one of the ready-made sample apps for Teams. These are fully functional apps that provide a complete experience, but are also easy to enhance and configure to meet your specifications.


Reference:

https://learn.microsoft.com/en-us/power-apps/teams/how-to/enable-dataverse-sample-app



A company uses Power Apps with Microsoft Dataverse.

The company enables auditing on the Dataverse database. The company tenant reaches the maximum storage capacity.

You need to delete some auditing data.

Which three deletion options should you use? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

  1. by record
  2. between two specified dates
  3. by table
  4. older than a specified date
  5. by column

Answer(s): A,C,D



A company uses a Power Apps app with Microsoft Dataverse.

The company requires the import of records into Dataverse. Duplicate records in the data must be deleted without user intervention.

You create a duplicate detection rule.

You need to configure the rule for the data import.

Which option should you configure?

  1. Enable the During data import option.
  2. Enable the Templates for Data Import option.
  3. Disable the Allow Duplicates option.
  4. Enable the When a record is created or updated option.

Answer(s): A

Explanation:

Detect duplicate data so you can fix or remove it
You can detect duplicates:

* When you create or update records for tables that enabled for duplicate detection.
* When Dynamics 365 for Outlook goes from offline to online.
* During data import. You can specify whether or not to check for duplicates during the import.
When you use the Import Data wizard to bring in contacts, leads, accounts, or other types of data, the wizard detects any duplicate records as long as you enable duplicate detection in the wizard.


Reference:

https://learn.microsoft.com/en-us/power-platform/admin/detect-duplicate-data



DRAG DROP (Drag and Drop is not supported)

A company has a model-driven app that uses Microsoft Dataverse.

Users need to add an alternate phone number when entering their account information. The users also require a list that displays the customers that do not have an alternate phone number.

You need to enable the required features.

Which features should you use? To answer, drag the appropriate features to the correct requirements. Each feature 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.

Select and Place:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: Column
Users need to add an alternate phone number when entering their account information.

Add an extra column for the alternate phone number.

Box 2: View
The users also require a list that displays the customers that do not have an alternate phone number.

Use a view to find the required information.



HOTSPOT (Drag and Drop is not supported)

You create a model-driven app for an automobile parts help desk.

A help desk agent uses a form to gather information about customers' automobiles in two custom tables. The names of the tables are Client and Automobile.

The form must prepopulate the following information about the customer from the client table:

First name

Last name

The agent must be able to type the following information about the automobile:

Automobile make

Automobile model

You need to implement the form.

What should you configure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: Virtual table
Imagine that you want to access, create, update, and delete some personal information about a contact from an external data source within your model-driven app. You can model a virtual table named with columns mapped to the external schema to these operations at runtime from an OData web service.

Box 2: Connector
As part of the custom page public preview, the new page type based on canvas can be added into a new or existing model-driven app. This allows the power and flexibility of a canvas experience within the model-driven app.

In Power Apps, add a data connection to an existing canvas app or to an app that you're building from scratch. Your app can connect to SharePoint, Microsoft Dataverse, Salesforce, OneDrive, or many other data sources.

Add data source
1. In the center pane, select connect to data to open the Data pane.

2. If this were an existing app and the screen already contained a control, select View > Data sources to open the same pane.

3. Select Add data source.

4. Expand Connectors, and if the list of connections includes the one that you want, select it to add it to the app. Otherwise, skip to the next step. To connect to a table in Microsoft Dataverse instead, choose a table from the list of tables.

5. Etc.


Reference:

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/virtual-entity-walkthrough-using-

odata-provider https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/add-data-connection



HOTSPOT (Drag and Drop is not supported)

A company uses Power Apps. You enable auditing in Microsoft Dataverse.

Users report the following issues when viewing the audit logs:

Unable to view the read access audit logs.

Unable to view the Account table audit logs.

You need to troubleshoot the issues.

What are the causes of the issues? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:





Box 1: Auditing is not enabled at the environment level.
Unable to view the read access audit logs.

Audit data is now stored separately from customer records so an organization's audit log can grow to many terabytes in size without limiting available Database capacity.

Audit Retention Policy:
In the `Admin Center', on the `Environment' page now we have `Auditing -> Manage' option to set the Audit Retention Policy.



Select one of the options from the dropdown to set the retention duration.



Box 2: Auditing is disabled at the table level.
Unable to view the Account table audit logs.

You can use Dataverse tables and APIs to:

* Enable or disable tables and columns for auditing.
* Etc.


Reference:

https://rajeevpentyala.com/tag/audit/



HOTSPOT (Drag and Drop is not supported)

A company is implementing a data model by using Dataverse.

The company requires the following columns in a new custom table:



You need to choose the column type that uses the least amount of database storage for each column.

Which column types should you choose? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: Text Area
Single Line of Text
This field can contain up to 4,000 text characters. You can set the maximum length to be less than this. This field has several format options that will change the presentation of the text. These options are Email, Text, Text Area, URL, Ticker Symbol, and Phone.
* Text
This option simply displays text.
* Text Area
This format option can be used to display multiple lines of text. But with a limit of 4000 characters, the Multiple Lines of Text field is a better choice if large amounts of text are expected.

Box 2: Multiline Text
Multiple Lines of Text
This field can contain up to 1,048,576 text characters. You can set the maximum length to be less than this. When you add this field to a form, you can specify the size of the field.

Box 3: Customer
Customer
A lookup field that you can use to specify a customer, which can be an account or contact.

Customer field
In previous releases of Dynamics 365 Customer Engagement (on-premises), several out-of-the-box entities such as the Case, Lead, and Opportunity entities, included a special kind of lookup field that represented a customer. Using this lookup field you could choose between two entities: Account or Contact. With this new capability, you can add the Customer field to any system or custom entity. You can use the Customer field in more entities to track the customer's information in the same way you've used the Customer field in the Case, Lead, and Opportunity entities.

Box 4: Choice
Dataverse Choice vs Choices
The number of options that can be selected defines a choice from a choices column. A choice column just supports one option, whereas a choice column also supports the addition of numerous values.


Reference:

https://learn.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/types-of-fields https://www.spguides.com/power-apps-dataverse-choices/



Viewing page 9 of 42
Viewing questions 65 - 72 out of 328 questions


PL-200 Exam Discussions & Posts (Share your experience with others)

AI Tutor AI Tutor 👋 I’m here to help!