microsoft pl-200 practice test

Question 1

HOTSPOT The owner of a company needs to know who signs into the system.
You need to ensure that the owner can view the user audit logs.
Where does each action need to be performed? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Question 2

HOTSPOT

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.

Question 3

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?

• A. Delete the other address columns from the table.
• B. Disable the Search option for the columns.
• C. Use column-level security to remove read access to all users.
• D. Create business rules to hide the other address columns.

Question 4

HOTSPOT You create a desktop flow to interact with a certification authority's website.
You need to get data in and out of the desktop flow.
How should you set up the input and output parameters? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Question 5

You create a new independent software vendor (ISV) solution for a Power Apps app.
The Power Apps solution will be imported into multiple customer environments. The environments will have a large variety of solutions and publishers.
You need to avoid naming conflicts during solution import.
Which element should you configure?

• A. Package type
• B. Configuration page
• C. Marketplace
• D. Prefix
• E. Version

Question 6

DRAG DROP

A company that manufactures medical devices uses Power Apps to manage their sales and device maintenance.

A table named Devices in Microsoft Dataverse has a column named Status. The Status column must have a new status value of Review added to the existing Choice values of Active and Inactive.

The table must be added to a solution to be promoted once the change is made.

Only this change must be promoted to the test environment. The changes must not be able to be changed once promoted.

You need to add the change to a solution for promotion.

Question 7

HOTSPOT

You plan to create a dataflow to import data into Microsoft Dataverse by using Power Query.

The dataflow has the following requirements:

A table of aggregated data must be created in dataflow storage.
A unique identifier must be created for the table.

You need to configure the dataflow.

Which solutions should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Question 8

HOTSPOT You create a Power Platform help Desk solution.
You need to create a dashboard that displays information on help desk cases that are handled each week.
Which dashboard components should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Question 9

A company creates a canvas app.

The app requires users to enter their social security number. The app should only display the last four digits when the user tabs to a different column.

You need to configure the app.

Which option should you use?

• A. Business rule
• B. Business process flow
• C. Power BI DAX
• D. Power Fx

Question 10

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?

• A. Map Parent Name in the CSV file to the Parent Account column. Select Account Name as the lookup criteria.
• B. Map Parent Name in the file to the Parent Account column. Select Parent Account as the lookup criteria.
• C. Create an alternate key on the account table by using the Account Name column. Do not map Parent Name in the file.
• D. 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.