pl-900

Question 1

A company uses Microsoft Dataverse.

You plan to create a one-to-many relationship between two tables named TableA and TableB in Microsoft Dataverse.

You need to identify the column data type that is created for the relationship in TableB.

What should you identify?

Answer 1

When a one-to-many relationship is created between two tables, a lookup column is created on the related table on the many sides of the relationship. This column links the parent record with the child record. A lookup column is also known as the foreign key.

Question 2

A company has a custom API. The API downloads Microsoft Excel and Microsoft Word files from an internal server.

You need to fetch data inside Power Automate.

Which two connectors can you use? Each correct answer presents a complete solution.

Answer 2

Premium HTTP connector
This answer is correct.

Custom connector

Question 3

You plan to create a Power Apps app.

You need to enable users to read and write data from SharePoint and OneDrive for Business.

Which type of app should you use?

Answer 3

Canvas app

Question 4

A company uses Microsoft Power Platform.

You need to recommend a use case for formulas in canvas apps.

Which two actions should you recommend? Each correct answer presents a complete solution.

Answer 4

Filter a list of rows.
Save data when a user selects a button.

Question 5

You create a canvas app that is connected to a Microsoft Dataverse table.

You need to share the app.

Which two actions should you perform? Each correct answer presents part of the solution.

Answer 5

Publish the app.

Assign a security role.

Question 6

A company has a Power Apps portal that has a list of their retail stores.

You need to add retail store hours to the portal.

Which two Microsoft Power Platform components should you use? Each correct answer presents a complete solution.

Answer 6

Power BI
Power Virtual Agents

Question 7

A company uses Microsoft Power Platform. The company builds Power Apps canvas apps, Power BI dashboards, and Power Virtual Agents chatbots.

You need to identify the Microsoft Power Platform component that can be used directly with these three components.

What should you identify?

Answer 7

Power Automate

Question 8

A company uses Microsoft Power Platform.

You need to prevent external leakage of corporate data.

What should you do?

Answer 8

Create data policies.

Question 9

A coworker requires a personal Microsoft Power Platform environment to test preview features of Power Apps. The coworker wants to use this environment for at least two months.

You need to recommend which type of environment the coworker should create.

Which type of environment should you recommend?

Answer 9

developer

Question 10

A company manufactures car parts. Some parts are defective.

You create a Power BI report to visually represent defect information.

You need to add a single visualization to the report to show the percentage of defects per part.

Which two visualizations should you use? Each answer presents a complete solution.

Answer 10

Donut chart

Column combo chart

Question 11

You need to create a Power BI dashboard for Power BI mobile apps.

What should you do?

Answer 11

Edit the phone view.

Question 12

A company uses Microsoft Power Platform.

You need to describe the features of Power Apps.

What are two features of a canvas app? Each correct answer presents a complete solution.

Answer 12

Include artificial intelligence.
Control functionality with Microsoft Power Fx formulas.

Question 13

A company wants to streamline the new employee onboarding process.

You need to allow new employees to manage their active certifications and work history by using an Excel workbook.

Which Power Apps solution should you use?

Answer 13

Canvas app

Question 14

You plan to create a canvas app that allows users to view a list of current scores for all local professional sporting events.

Each game should display the following:

Name of the game.

Amount of time left in the game.

A link to a map of the game’s location.

You need to add controls to your Power Apps app.

Which two controls should you use? Each correct answer presents part of the solution.

Answer 14

Screen
gallery

Question 15

A company uses Microsoft Power Platform. You model the data in Microsoft Dataverse and create a model-driven app.

You need to create a new model-driven app for a different group of users. The model-driven app must restrict the columns in a table that users can change the values.

Which two actions should you perform? Each correct answer presents part of the solution.

Answer 15

Create a new form for the Microsoft Dataverse table.
Select the form in the app designer.

Question 16

A company uses Microsoft Power Platform.

You need to identify the features of model-driven apps.

What are three features of model-driven apps? Each correct answer presents a complete solution.

Answer 16

They adjust the layout of the UI automatically in response to changes in a device’s orientation or screen resolution.
They embed Power BI dashboards.
They guide users by using business process flows.

Question 17

You need to create a Power Automate flow to allow managers to approve or deny vacation requests.

Which two flow types should you use? Each correct answer presents a complete solution.

Answer 17

Business process flow

Cloud flow

Question 18

A company uses Power Automate to integrate applications.

You have a legacy application that does not have an application programming interface (API).

You need to determine which type of flow you should use to access the data in the legacy application.

What should you use?

Answer 18

Desktop flow

Question 19

A company has an approval process that contains an attachment.

You need to ensure users can access the attachment in the approval notification.

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

Answer 19

email inbox
power automate portal
microsoft teams

Question 20

A company uses Microsoft Power Platform.

You create a custom connector from an OpenAPI file.

You need to allow other makers in your organization to use the connector.

What should you do?

Answer 20

Share the connector.

Question 21

You create a Power Virtual Agents chatbot.

You need to ensure that the chatbot understands natural language phrases.

What should you add to the chatbot?

Select only one answer.

Answer 21

Custom entities

Question 22

A company is considering using Power Pages for its website.

You need to determine whether the use cases for Power Pages meet the company’s requirements.

What is a use case for Power Pages?

Answer 22

Capturing data from customers.

Question 23

A company uses Power Virtual Agents to display information to authenticated users.

You need to retrieve data from a Microsoft Dataverse table.

What should you use?

Select only one answer.

Topics

Answer 23

Actions

Question 24

You create a chatbot in Microsoft Teams by using Power Virtual Agents.

You need to configure the chatbot to identify when an email address is included in a user’s response to the chatbot.

What should you use?

Answer 24

Prebuilt entities

Question 25

You create a Power Virtual Agents chatbot.

You need to ensure that the chatbot understands natural language phrases.

What should you add to the chatbot?

Answer 25

Custom entities

Question 26

A company wants to streamline the new employee onboarding process.

You need to allow new employees to manage their active certifications and work history by using an Excel workbook.

Which Power Apps solution should you use?

Select only one answer.

Model-driven app

Answer 26

Canvas app

Question 27

You build a canvas app. The canvas app is tied to a Microsoft SQL Server database table.

You need to add a control that allows users to modify the values for each column of a row in the table.

Which control should you use?

Answer 27

Edit form

Question 28

A company uses SharePoint and Microsoft Power Platform.

You need to create a canvas app from an existing SharePoint list that can view and edit items in the list.

In which two locations can you create this app? Each correct answer presents a complete solution.

Answer 28

Power Apps maker portal
SharePoint list

Question 29

You plan to create a Power BI report from Microsoft Dataverse.

You need to identify which components are available when you create a report using Power BI Desktop.

Which two components should you identify? Each correct answer presents a complete solution.

Answer 29

Shaping and modeling data

Calculated columns

Question 30

You plan to build a Power Automate flow.

The flow needs to loop through all rows in an Excel spreadsheet and update the first column value for all rows with the current date.

You need to configure the action for the flow.

Which action should you use?

Answer 30

apply to each

Question 31

A company uses Power Automate to integrate applications.

You have a legacy application that does not have an application programming interface (API).

You need to determine which type of flow you should use to access the data in the legacy application.

What should you use?

Answer 31

Desktop flow