Microsoft PL-900 Practice Test - Questions Answers, Page 28

You are developing reports for a company.

You must create visualizations that include the following data:

Invoices due from a third-party enterprise resource planning (ERP) system

Number of calls made to the client fromMicrosoft Dataverse

Microsoft Excel file data

The reports must be displayed in a single page.

You need to create the visualizations.

What should you use?

A company is implementing Power Automate to streamline operations.

The head of customer support relations needs a Power Automate flow that texts a manager when an email meets the following criteria:

• The email is sent as high priority.

• The email is from a customer.

You need to identify how the flow's decision point will know whether the criteria are met. What should you use?

You are using the Power B1 service to view a visual on a report that has been shared with you. You need to add the visual to a dashboard as a tile. Which action should you perform?

You test a business process flow in a sandbox environment.

When you complete testing, you must copy the business process flow to a production environment without bringing any data or other modifications with it. You must meet the requirements.

What should you do?

You are creating a canvas app to enable users to order tickets. You create an input field for users to input the number of tickets to order. Users must order a maximum of four tickets and a minimum of two tickets. If a user enters a number except 2, 3, or 4, the input field must display in red. If a user enters the numbers 2, 3, or 4, the input field must display in green. You need to color the input field based on the user input.

What should you use?

A company plans to move an on-premises customer service data management system to a cloudmanaged solution. The customer service application must be replaced by a model-driven application. The company uses Microsoft SQL Server Integration Services (SSIS) packages to move data from the on-premises database system to a third-party enterprise resource planning (ERP) system.

You need to replace the SSIS packages for data transfer.

What should the company use in place of the packages to move the data?

You create a canvas app that uses a Microsoft Excel spreadsheet as a data source.

The spreadsheet contains a list of pets. Each column in the spreadsheet is a different attribute about a pet. You need to create an interface to allow users to save a new pet record to the spreadsheet.

What is the minimum number of controls you need to implement to create the interface?

You create a Power Apps app and Power Automate flow.

You need to combine multiple types of field values into a single string value and format the string. What should you use?

A company creates canvas apps for its sales team.

A user creates a canvas app from a data source.

You need to determine the screens created.

Which three screens should you identify? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.