PL-900 Microsoft Power Platform Fundamentals Questions and Answers

You are a sales representative. You create a Power BI report to visualize data from a Microsoft Excel

workbook.

Users need to be able to view and share the report.

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

NOTE: Each correct selection is worth one point.

You need to display sales orders greater than a specific threshold in a Power Bl report. What should you use?

A company plans to display support call metrics on a screen that is visible to all call center staff.

You need to recommend solutions to meet the company ' s requirements.

What should you recommend? To answer, drag the appropriate components to the correct requirements. Each component 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.

You are using Dynamics 365 Sales.

You need to create a Power BI report that includes customer office locations. The City and State columns

must be combined to form one column on the report.

What should you do?

NO:32 HOTSPOT

A user is creating their first canvas app in Power Apps.

The user does not know what types of controls they can include.

You need to recommend solutions for the user.

Which types of controls would you recommend using in Power Apps? To answer, select the appropriate control in the dialog box in the answer area.

NOTE: Each correct selection is worth one point.

A company plans to build new apps for the business to allow employees to work more efficiently.

You need to recommend the appropriate types of Power Apps to meet the company’s requirements.

To answer, drag the appropriate app types to the correct requirements. Each app 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.

What is a benefit of deploying Microsoft 365 and Dynamics 365 apps in the same tenant?

A company plans to implement Power BI to analyze retail operations data.

You need to recommend solutions for the company.

Which Power BI components should the company use? To answer, drag the appropriate Power BI components to the correct requirements. Each Power BI component 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.

You have a Power BI report.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

You have a Microsoft Excel workbook that contains a list of tasks for a project. You store the file in OneDrive for Business.

You need to create a canvas app that allows team members to update the status of their tasks.

What should you use?

A company publishes e-books for independent authors.

The company wants to implement a Power Apps portal solution to make announcements about upcoming books to the general public.

You need to recommend features for the company.

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

NOTE: Each correct selection is worth one point.

A company is using Power BI to build visualizations.

The company ' s IT support team needs to know when to install Power BI Desktop on users ' computers and where the Power BI Service will suffice to perform tasks.

You need to recommend solutions for the company.

What should you recommend? To answer, drag the appropriate components to the correct requirements. Each component 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.

You are creating a canvas app.

You need to configure the app.

Which two objects are provided by the connector? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

You create a Power BI dashboard.

Match each option to its function. To answer, drag the appropriate option from the column on the left to its function on the right. Each option may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

A company plans to build Power Apps portals.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

A company is building a Power Apps Portals.

You need to select page components.

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

You create a Power Virtual Agents chatbot.

You need to share the bot with other team members so that they can try out the bot before you share the bot with customers.

What should you use?

You are creating visuals in Power BI.

You create area charts, pie charts, and donut charts that use your company’s data.

You need to display the charts to others at the company.

Which two objects can you add the charts to? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

You are a district manager for a large retail organization. You train each store manager to use Power BI to track sales and daily sales targets.

A store manager remembers learning about the Analyze in Excel option but cannot find the option in their Power BI dashboard.

You need to help the user resolve the issue.

How should you advise the user?

A recent update has been made to a canvas app.

The update has caused a negative impact to users.

You need to roll back the app to a previous version.

What should you do?

A travel company plans to use the Power Platform to create tools that help travel agents book customer travel.

You need to recommend solutions for the company.

What should you recommend? To answer, drag the appropriate tools to the correct requirements. Each tool 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.

You are using Dynamics 365 Sales.

You need to pull data into a Power BI report for your team. The City and State columns must be combined to form one column on the report.

Which function would you use? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

A company plans to create an information portal that managers can use to view critical information about their teams.

You need to recommend the type of Power BI components that the company should use.

What should you recommend? To answer, drag the appropriate components to the correct requirements. Each component 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.

Your company wants to create a help desk system and implement Dynamics 365 Customer Service.

The company has the following requirements:

Provide an application to allow support team staff to chat live with a customer.

Automatically import data from a Microsoft Excel spreadsheet once a day.

Provide a chatbot that can assist customers who need support.

You need to determine which applications to use to meet the requirements.

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

NOTE: Each correct selection is worth one point.

This question requires that you evaluate the BOLD text to determine if it is correct.

You have a Power BI report with a page named RevReceived. The page shows revenue received by your

company. You want to create an almost identical page that shows net revenue instead of gross revenue. To accomplish this task, you modify the RevReceived page.

Review the underlined text. If it makes the statement correct, “No change is needed”. If the statement is

incorrect, select the answer choice that makes the statement correct.

A company plans to use AI Builder to help improve business performance.

You need to determine which AI Models are available for use.

Which three types of models can you use? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

A company is evaluating Power Platform and has questions about the role that Common Data Service plays in using Power Apps and Power Automate.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

A company plans to use Power BI to visualize data from business systems.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

A company is considering implementing PowerApps to help manage business processes. Users are trying to understand the purposes and benefits of PowerApps components.

Match each benefit to its tool. To answer, drag the appropriate benefit from the column on the left to its tool on the right. Each benefit may be used once, more than once, or not at all.

NOTE: Each correct selection is worth one point.

A company is building a model-driven app.

You need to create and configure the objects needed for the app.

Which component categories should you use? To answer, drag the appropriate component categories to the correct objects. Each component category 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.

A company needs to create several workflows and applications to help streamline their sales operations.

You need to determine which applications are appropriate for given scenarios.

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

NOTE: Each correct selection is worth one point.

You are creating a number of Power Automate flows.

You need to select the triggers for the flows.

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

NOTE: Each correct selection is worth one point.

What is a benefit of deploying Microsoft 365 and Dynamics 365 apps in the same tenant?

A toy company creates a text classification model in AI Builder to monitor customer feedback for specific key words.

When negative feedback is received for a toy, the company wants to proactively perform engineering reviews for the toy and schedule additional training sessions for workers who produce the toy.

What are two possible ways to achieve the goal? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

You are planning to use the Business Card Reader and Sentiment Analysis prebuilt AI models to build solutions.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

A company plans to create a Common Data Service environment.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

A coworker is creating an app in Power Apps and needs to automatically synchronize data from an external source. The coworker is unable to locate a suitable Microsoft approved connector template in AppSource.

You need to recommend a solution for the coworker.

What should you recommend?

A company plans to create canvas apps.

What is the minimum number of connectors required? To answer, drag the appropriate number of connectors to the correct drop scenarios. Each number of connectors 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.

A distribution company has multiple warehouses.

Tax rates charged on sales orders need to be calculated based on locality and region.

You need to recommend a cost-effective solution that can be implemented quickly.

What should you recommend?

A company uses Microsoft 365 and Dynamics 365 Sales. The company does not have any developers on its staff.

You need to explain to the executives the benefits of using Power Platform apps.

What are two benefits? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

You manage the support team at a rapidly growing company.

Support technicians need a better experience when logging and responding to support requests.

You need to recommend tools to help the company ' s needs.

Which tools should you recommend? To answer, drag the appropriate tools to the correct requirements. Each tool 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.

You create a business rule on contact entity to enforce the requirement that users must enter either a

telephone number, fax number, or an email when creating a new record.

The company decides to remove fax number from the condition.

You need to update the business rule.

What are two ways of achieving the goal? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

A company plans to implement solutions that use Common Data Service as a data storage.

You need to recommend features to meet the company ' s needs.

Which features should you recommend? 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.

NOTE: Each correct selection is worth one point.

This question requires that you evaluate the BOLD text to determine if it is correct.

You have a Power Apps app. You create a new version of the app and then publish the new version. A customer goes through the process of restoring the previous version of the app. In the Version tab for the app, you will see two versions of the app.

Review the underlined text. If it makes the statement correct, select “No change is needed.” If the statement is incorrect, select the answer choice that makes the statement correct.

A company manages a chain of retail stores. The company stores a list of retail store names and numbers in one Power BI table. The company stores sales transaction data including a transaction ID in another table.

The transaction ID includes the store number.

You need to show the store name for all retail transactions in all Power BI reports.

Which tool should you use?

A company plans to create a canvas app that connects to three databases with different proprietary database formats. What is the minimum number of connectors required?

A large retail company implements Power Apps, Microsoft Flow, and the Common Data Service.

The board of directors is asking whether users are finding value in the technology. The company would like to measure and report usage of the software.

You need to recommend a tool to determine software usage.

What should you recommend?

NO: 14 HOTSPOT

A company plans to use Power Platform to build apps which address specific business challenges.

You need to recommend the appropriate types of Power Apps to use.

What should you recommend? To answer, select the appropriate option in the answer area.

NOTE: Each correct selection is worth one point.

A company has locations in multiple regions. The company develops solutions based on Power Apps and Power Automate.

You need to recommend features to support the implementation.

Which Power Platform features should you recommend? 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.

NOTE: Each correct selection is worth one point.

A rapidly growing company wants to empower users to build apps, automate business processes, and analyze data without requiring IТ expertise or development skills and without increasing IT expenses and dependencies.

You need to recommend tools so that users can accomplish specific tasks.

Which tools should you recommend? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

A company uses Dynamics 365 Sales. The company uses a browser-based app named Sales Hub.

You need ensure that users can access data from mobile devices.

Which app should users install?

A company uses Power Platform.

You must ensure that users cannot share customer data with other users. You must also ensure that uses cannot connect to data sources unless you grant the user explicit permissions to access a data source.

You need to recommend solutions to meet the company’s security requirements.

Which two types of policies should you recommend? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

You are building Power Apps apps that use both Dynamics 365 Sales and Microsoft 365.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

A company plans to implement Power Platform apps. The company does not plan to use any development tools or plug-ins.

Which actions can you perform?

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

A company uses Microsoft 365, SharePoint Online, and Dynamics 365 Sales.

You need to recommend tools to build a solution that meets the following requirements:

* Synchronize data from an external Microsoft SQL Server instance.

* Send out of the box report automatically to specific company executives.

* Ensure that opportunities over a specified amount are approved by a sales manager.

Which two tools or components should you recommend? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

You create a user-owned custom entity by using Common Data Service.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

You need to implement Microsoft Business Applications along with the Microsoft Power platform.

Which three Microsoft products are part of the Power platform? Each correct answer presents a complete

solution.

NOTE: Each correct selection is worth one point.

You are a customer service manager.

You need to implement a Power Apps portal that allows customers to submit cases.

Which type of data source is used?

You manage the support team at a rapidly growing company.

Customers and support technicians need a better experience when logging and responding to support requests. You need more visibility into what the support technicians are doing every week.

You need to recommend tools to help the company ' s needs.

Which tools should you recommend? To answer, drag the appropriate tools to the correct requirements. Each tool 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.

A company uses Power Apps.

You need to perform administrative tasks for the company.

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

A company plans to implement Power Apps.

following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

You are learning about Power Apps and how to use triggers.

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

NOTE: Each correct selection is worth one point.

You are new to working with Microsoft Flow. You create a flow that extracts birth dates for users and then

sends a birthday greeting email to users on their birthday.

The flow does not properly extract birth dates.

Where should you make changes?

A company builds and sells residential apartments. The company uses Dynamics 365 Sales to manage sales opportunities.

Management must receive notifications on their mobile devices when sales opportunities are created.

You need to select recommend Power Platform components to address the requirements.

Which two components should you recommend? Each correct answer presents part of the solution.

NOTE: Each selection is worth one point.

A company plans to use Microsoft Flow to automate tasks.

Match each flow type to its function. To answer, drag the appropriate flow type from the column on the left to its description on the right. Each option may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

You plan to use Microsoft Flow to monitor what people are saying about your company ' s products. You store the feedback for research and development purposes.

You need to recommend Flow components to use for the solution.

To answer, drag the appropriate components to the correct requirements. Each component 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.

A company uses Microsoft Flow.

Each time a work order is created, a service manager must review and approve the work order before a

worker is dispatched.

You need to create a flow to enforce the process.

What should you create?

ESTION NO: 89 HOTSPOT

A company is using Power Automation to automate business processes.

You need to recommend triggers for Instant flows.

What trigger types should you recommend? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

A company uses Dynamics 365 Supply Chain Management.

You need to use Microsoft Flow to automate the process of receiving and tracking raw materials.

Which type of connector should you use?

Users within a company use Flow for personal productivity.

Users often overwrite their working flows by editing the definitions and are unable to undo changes after saving a flow.

You need to ensure that users can revert a flow to the current state.

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

NOTE: Each correct selection is worth one point.

You are creating a model-driven app to track requests for quotes.

The app must use the following navigation structure:

Sales

Sales Log

Request for Quotes

Projects

Settings

Customers

Product Lines

Sales Territories

Administration

User Admin

Users

Roles

You need to create the app navigation.

Which sitemap component types should you use? To answer, drag the appropriate component types to the correct navigation elements. Each component 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.

A company uses Dynamics 365 Supply Chain Management.

When a sales order is created for one of the customers that a specific user manages, a Microsoft Outlook task must be created to remind the user to perform any follow up activities that are required.

You need to implement the functionality to create Outlook tasks.

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

NOTE: Each correct selection is worth one point.

NO: 119 HOTSPOT

A software company plans to use Power Automate.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

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 business plans to including AI Builder.

Which actions can you perform?

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

NO:40 HOTSPOT

A company uses a third party application and an approval process via email. At the end of the month, the IT department enters the data into Microsoft Excel to create pivot charts.

The Excel pivot charts must use the same data source as Dynamics 365 Field Service to generate charts and reports.

You need to recommend a solution.

What should you recommend? To answer, select the appropriate configuration in the answer area.

NOTE: Each correct selection is worth one point.

A company is considering using Power Pages for its website.

You need to identify the capabilities of Power Pages.

What are two capabilities of Power Pages? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

A Power Apps developer has sufficient permissions to create apps, connections, and flows.

The developer does not have permissions needed to access company data.

You need to grant the developer access to company data for an app.

Which predefined security role should you assign to the developer?

A company uses Dynamics 365 Sales.

The company requires an interface for back-office staff. The solution must meet the following requirements:

• Existing custom tables must be visible in the interface.

• The user experience must resemble that of the existing Dynamics 365 Sales app.

• Users must have the ability to edit or create new data.

You need to recommend a Power Platform capability that can achieve these requirements with the least configuration effort. Which capability should you recommend?

A company requires a Power Pages site that uses one of the site design templates provided with Power Pages to build its website on.

You need to deploy the site.

Which three pages will be included in the site? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

A company uses a custom-built system to record financial data that runs on a manager’s machine.

The system does not have an API. New customer details must be manually entered into the system by the manager from a central spreadsheet. The user interface of the system contains the complex business logic that is needed for the manual customer data entry process.

You need to ensure that new customer details can be entered into the system automatically by using Power Automate.

Which type of flow should you create?

A company uses a Power Pages site for customers to track orders.

You plan to add a new field to the existing order form.

You need to determine where you can complete this action in Power Pages design studio.

Which two design workspaces can you use? Each correct answer presents a complete solution. Choose two.

NOTE: Each correct selection is worth one point.

You are managing several Power Automate cloud flows for a company.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

An enterprise company is evaluating the Microsoft Power Platform security model. You need to identify the lowest possible level that the authorization can be applied against. Which level should you identify?

You plan to create a model-driven app for a company that sells plants and garden supplies. The app must meet the following requirements:

• Automatically send email to a customer when a record is modified.

• Ensure that all sales people follow the same steps when processing sales.

You need to create Power Automate flows for the app.

You are assigning record level privileges for Power Apps and Model-Driven Apps.

Which privilege should you use to ensure access for each scenario? To answer, drag the appropriate privileges to the correct requirements. Each privilege 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.

You are authoring a Power Virtual Agents chatbot for a company for each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

A company uses a model-driven app.

You add several columns to a form.

Users state the new columns do not appear on the form.

You need to fix the issue.

What should you do?

A company uses Dataverse to store information about its products and stock levels.

The company requires a solution that allows existing customers and potential new customers to perform the following self-service actions:

• Locate information about available products.

• Register their information for marketing materials.

• Create their own orders.

You need to recommend a Microsoft Power Platform component that meets the requirements.

Which component should you recommend?

You are creating a dashboard in the Power Bl service.

You need to identify where you can find visuals to pin to your dashboard.

From which two components can you pin visuals? Each correct answer presents a complete solution. Choose two.

NOTE: Each correct selection is worth one point.

You are creating a Power Apps solution for a company that manufactures bicycles. The company has The following requirements:

• A vendor uploads a Microsoft Excel workbook to the company each week. The workbook contains lists of parts and their current prices. You must automatically Import the data into Microsoft Dataverse as soon as the workbook is uploaded. You must send specific users an alert when new files are uploaded.

• Synchronize customer data with a proprietary accounting database when a user selects a button on the Account form.

You need to recommend the trigger types to use to meet the requirements.

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

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

You create a Power Apps canvas app.

You need to ensure that your coworkers can run the app.

What should you do?

You are developing a Power Virtual Agents chatbot for a company.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

You are creating a Power Virtual Agents chatbot for a company.

Which component types should you use for each scenario? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You create a Power Virtual Agents chatbot for a company. The chatbot will use common channels and services by which the company communicates with customers.

You need to determine which services the chatbot can be used with or added to.

Which two services can the chatbot be used with? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

You are planning to allow members of your team to test your chatbot. You must ensure this is done in a secure way.

A team member named User1 must test the chatbot.

You need to ensure that User1 can complete testing.

What should you do?

You are creating a Power Virtual Agents chatbot to help users search for available meeting rooms within a building.

The chatbot must meet the following requirements:

Allow users to initiate the chatbot by typing the phrase Help me Meeting Guru.

Provide meeting room capacity options of 1-4 people and 5-10 people.

End the chatbot session if the user attempts to schedule a meeting room for more than 10 people.

You need to identify the actions to use.

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

NOTE: Each correct selection is worth one point.

You create a Power Virtual Agents chatbot for a company.

The management wants to learn about the effectiveness of the chatbot.

You need to identity the percentage of customers who stop responding to prompts from the chatbot.

Which report should you view?

You are authoring a Power Virtual Agents chatbot for a company.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

You are building a Power Virtual Agents chatbot for a company.

You are working with an existing topic and would like to call an action.

Which technology is available to perform the action?

A company is building an interactive chatbot to answer questions about product and product warranties.

You need to create conversation paths for questions about product warranties.

Which tool should you use?

You create a Power Virtual Agents chatbot for use with Microsoft Teams. You are testing the chatbot.

Testers report the following issues:

Changes that you make to the chatbot are not seen by testers.

When users enter the word refund the chatbot must ask the user the product for which they would like a refund. The chatbot does not ask the user for product information.

You need to determine what needs to be done to fix the issues.

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

NOTE: Each correct selection is worth one point.