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

Updated On: 13-Jun-2026

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

On a Contact record, a user creates a Note record that contains the word running.

One week later, the user reports that they cannot find the Contact record associated with the Note record.

You need to find the Note record.

Solution: Use Dataverse Search to search for the word run.

Does the solution meet the goal?

  1. Yes
  2. No

Answer(s): B

Explanation:

Instead use Relevance Search.
Note: Relevance Search finds matches to any word in the search term in any field in the entity. Matches may include inflectional words, like "stream," "streaming," or "streamed." Reference:
https://docs.microsoft.com/en-us/power-platform/admin/configure-relevance-search- organization#what-is-relevance-search



You are using the Data import wizard to import records into the account table from a CSV file.

The CSV-to-table mapping is as follows:

The Name column represents the account name and maps to the Account Name column.

The Parent Name column represents the holding company of the account with subsidiaries underneath.

Records that are imported into the table are only related to other records in the file.

You need to configure the import to create the relationship between records.

What should you do?

  1. Map Parent Name in the CSV file to the Parent Account column. Select Account Name as the lookup criteria.
  2. Map Parent Name in the file to the Parent Account column. Select Parent Account as the lookup criteria.
  3. Create an alternate key on the account table by using the Account Name column. Do not map Parent Name in the file.
  4. Look up the record IDs of the records in the Parent Account column. Add the record IDs as a new column in the file. Map the new column to the Parent Account column.

Answer(s): A



HOTSPOT (Drag and Drop is not supported)

A company has a sales application that is supported by an Azure SQL database. You are developing a Power Apps app for use by customer service agents.

The app must reference customer data from the sales application. Data in the sales application is constantly changing and must not be replicated in Microsoft Dataverse.

Some customer data is considered sensitive. You must protect data for specific fields when users view data in the app.

You need to configure table creation for the app.

How should you configure the app? 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: Create a virtual table
A virtual table is a custom table in Microsoft 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, 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.

Box 2: Create a secured column
Add a secured column to a Data Source

You create columns for a Data Source in the same way as any other table. For data that is encrypted or sensitive, enable the Data Source Secret attribute on the custom column of the Data Source.


Reference:

https://docs.microsoft.com/en-us/power-apps/maker/data-platform/create-edit-virtual-entities



HOTSPOT (Drag and Drop is not supported)

A customer uses Power Apps to view and maintain their contacts that are stored in Microsoft Dataverse.

Several columns must be configured to ensure the security settings for sales associates are view only.

You need to configure the access restrictions.

Which component for field-level security should you use? 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: Power Apps app designer
Secure the column. Example

1. Sign in to Power Apps (The Power Apps website https//make.powersapp.com)
2. Select Dataverse > Tables.
3. Select the Contact table.



4. Under Schema, select Columns.
5. Expand Advanced options, and then under General, enable Enable column security.



6. Select Save.

Box 2: Field Security Profiles

Configure the security profiles. Example

1. From the Power Platform admin center, select the environment to configure security profiles for.
2. Select Settings > Users + permissions > Column security profiles.
3. Select New Profile, enter a name, such as Sales Manager, enter a description, and then select Save.
4. Select Sales Manager, select the Users tab, select + Add Users, select the users that you want to grant access to the mobile phone number on the contact form, and then select Add.


Reference:

https://docs.microsoft.com/en-us/power-apps/maker/model-driven-apps/app-designer-overview https://docs.microsoft.com/en-us/power-platform/admin/field-level-security



DRAG DROP (Drag and Drop is not supported)

You modify a model-driven app for a bicycle repair help desk. The model-driven app is for help desk users when customers have an issue with their bicycle.

After you add a custom table named bicycle, you configure the table for Microsoft Dataverse search. The table will contain information from callers about their bicycles. The account table is related to the custom table.
Contact information is brought over to the custom table.

You add the following columns to the table:

Bicycle type

Tire brand

Special equipment

Users must be able to perform the following types of searches:

Search for all customers who have a bicycle type of Contoso and live in Florida.

Search all tables for any record that contains the word broken.

You need to decide which type of search will give you the results desired.

Which search should you configure? To answer, drag the appropriate search types to the correct requirements. Each search 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:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: Advanced find
Operators for advanced search: Lets you use simple Boolean operators in your search term and craft the query to get the results you want.

Box 2: Dataverse search
Dataverse search helps you quickly find what you're looking for. It delivers fast and comprehensive results across multiple tables in a single list, sorted by relevance.


Reference:

https://docs.microsoft.com/en-us/power-apps/user/quick-find https://docs.microsoft.com/en-us/power-platform/admin/configure-relevance-search-organization



DRAG DROP (Drag and Drop is not supported)

You make the following customizations to a Microsoft Dataverse environment:

Create a new table.

Add data to the new table.

Delete an unused area from the site map.

The components must be transported to a different environment.

You need to determine the method required to transport each component.

Which method should you use? To answer, drag the appropriate methods to the correct components. Each method 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: Solution
Create a new table.

View and edit tables representing solution objects
Some standard tables in Dataverse represent the structure and instances of solution objects.

Power Apps offers standard "out-of-the-box" tables to cover typical scenarios within an organization (such as tracking appointments), but there may be times when you need to create custom tables to store data that's specific to your organization.

Note: Create a table.
Sign in to Power Apps at https://make.powerapps.com.

Create a table
1. In the navigation pane, expand Data, and then select Tables.
2. On the command bar, select New table.
3. Etc.

Box 2: Configuration Migration tool
Add data to the new table.

The Configuration Migration tool is used to transport configuration and test data from one environment to another. It provides the means to capture such data, use that data in source control, and use that data to automate testing.

Box 3: SolutionPackager
Delete an unused area from the site map.

SolutionPackager is a tool that can reversibly decompose a Microsoft Dataverse compressed solution file into multiple XML files and other files so that these files can be easily managed by a source control system.


Reference:

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-create-entity https://learn.microsoft.com/en-us/power-platform/alm/configure-and-deploy-tools



DRAG DROP (Drag and Drop is not supported)

A company plans to add another language to a Microsoft Dataverse environment.

Several components were added or modified in the environment.

You need to ensure that these components get translated.

Which method should you use? To answer, drag the appropriate methods to the correct component types. Each method 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: Export and re-import translated text
Microsoft Dataverse supports multiple languages. If you want your solution to be installed for organizations that include different base languages or that have multiple languages provisioned, take this into account when planning your solution. The following table lists tactics to use along with solution components to include in a solution that supports multiple languages.
* Export and import translations
Solution component type:
Attributes
Charts
Dashboards
Entity
Entity Relationships
Forms
Messages
Option Sets
Views

Note:
The standard tables include default text for labels that are available in many different languages. However, when you customize a form, such as adding or changing columns, or create custom tables, you may need the labels for those components to appear in different languages. You can import translated label text for customized tables for your apps so that the label text displays in languages other than the base language.

High-level process
1. Export the translations from the solution that contains the tables that you want to translate label text. Then, open the translations XML file and add the translated text.
2. Import the translations.

Box 2: Create a separate version for each language
* Separate component for each language
Solution component type:
Article Templates
Email Templates
Mail Merge Templates
Reports
Dialogs

Box 3: Use embedded labels.
* Embedded labels
Application Navigation (SiteMap)
Ribbons


Reference:

https://learn.microsoft.com/en-us/power-platform/alm/create-solutions-support-multiple-languages https://learn.microsoft.com/en-us/power-apps/maker/data-platform/translate-entity-label-text



A company uses Power Apps.

Users must be able to view only the address1 columns in the Account table.

You need to ensure other address columns are not visible to users when creating views and filters.

What should you do?

  1. Delete the other address columns from the table.
  2. Disable the Search option for the columns.
  3. Use column-level security to remove read access to all users.
  4. Create business rules to hide the other address columns.

Answer(s): B



Viewing page 7 of 42
Viewing questions 49 - 56 out of 328 questions


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

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