PL-900 Microsoft Power Platform Fundamentals Questions and Answers

A company uses Microsoft Dataverse to manage business data.

You need to import data into Dataverse from other data sources by using dataflows.

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

NOTE: Each correct selection is worth one point.

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 uses Microsoft Excel workbooks to store consolidated sales data. Workbooks are stored on OneDrive for Business.

Match each Power Bl feature to its requirement. To answer, drag the appropriate features from the column on the left to its requirement 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 implement Power BI.

The company wants to implement some specific features that Power BI does not include.

You need to recommend solutions for the company.

What should you recommend? To answer, drag the appropriate solutions to the correct requirement. Each solution 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 medical office has a model -driven app that uses Common Data Service.

You plan to create a screen that allows users to capture information about doctors. The screen must provide users the ability to enter or select the following information;

a place to enter doctor- profile data that is not pan of the account table or the contact table.

a place to enter the doctor's specialty in the profile form.

a column for insurance with the ability to pick one of 10 different insurance companies.

You need to store the captured data in Common Data Service.

What should you use to store the data? 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 Power Automate solution.

You need to select a Power Automate control action for each function in the flow.

Which control action should you use? To answer, drag the appropriate control actions to the correct functions. Each control action 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 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 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.

You are authoring a Copilot Studio copilot 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 added to a dashboard within a workspace.

You need to identify where you can view the dashboard.

In which two places can you view the dashboard? Each correct answer presents a complete solution.

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.

A company creates canvas apps that us a data source from its sales team.

To meet company device policies, you must determine the available app formats the sales team can select when the sales team creates the canvas.

You need to determine the available app formats.

Which two app formats should you select? Each correct answer presents a complete solution.

NOTE Each correct selection is worth one point.

You are creating a Power Apps app. You want to ensure that the app can be used by individuals who have a vision impairment. 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 implements Microsoft Power Platform.

Sales team members must take photos for their travel expense receipts and enter basic information about purchases.

The accounting team must be able to view and update records in a shared Microsoft Excel document on mobile devices.

You need to select the type of Power Apps app for each scenario.

Which type of app should you use? To answer, drag the appropriate apps to the correct scenarios- Each app 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

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?

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?

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

You are a district manager for a large retail company. You want to provide sales managers with deeper sales insights to ensure that they can make more informed decisions for their stores.

Store managers must be able to view data in near real-time.

You need to create and share a Power Bl dashboard that can be used by the store managers.

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

You are creating Power BI reports.

You need to choose which filters you can use for reports.

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

NOTE: Each correct selection is worth one point.

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.

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 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.

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?

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 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.

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.

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.

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.

A company needs to create a series of mobile applications to empower their field engineers to accomplish several tasks with varying degrees of complexity.

Match each option to its answer.

Instructions: To answer, drag the appropriate app type from the column on the left to its definition on the right. Each app type may be used once, more than once, or not at all.

NOTE: Each correct match 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.

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.

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.

A company plans to create a workflow that periodically runs a Dynamics 365 action based on data in third-party cloud-based solutions.

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

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?

A user is starting to learn about Power Apps.

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

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.

You need to build a Power Virtual Agents chatbot for a company.

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.

A company plans to use Power Apps to connect to a series of custom services. There are no connectors available for the custom services.

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 Dynamics 365 Sales. Every time an opportunity is created, a Power Automate flow runs to email the opportunity to the sales manager.

The sales manager leaves the company. You disable all accounts for the sales manager.

You need to ensure that the new sales manager automatically receives email about opportunities when they are created.

What should you do?

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?

You are editing an existing Power Automate cloud flow. Every day. the flow adds a list of tasks to Microsoft Planner for each email received in a complaints mailbox. The flow then sends a message to you in a Microsoft Teams chat when it completes.

You add an action to the end of the flow to post a Teams message to the central office channel.

You need to update the flow so that tomorrow it will post the message in the central office channel and in the direct chat to yourself.

Which action should you perform next?

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 have a Power Automate flow that saves attachments from emails into OneDrive for Business. You need to determine why the flow is not working.

What are three possible ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

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 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 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.

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.

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.

For which scenarios can you 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.

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 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.

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 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.

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?

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.

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 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.

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?

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 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 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 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.

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 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?

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.

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.

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 have version 1.0.0.0 of a published Power Apps app. You create and publish version 2.0.0.0 of the app. A customer goes through the process of restoring the previous version of the app.

How many versions of the app are displayed in the Version tab for the app? To answer, select the appropriate option in the answer area.

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.

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.

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 need to explain the major components of the Common Data Model (CDM) and their functions.

Match each term to its definition.

Instructions: To answer, drag the appropriate term from the column on the left to its definition on the right. Each term may be used once, more than once, or not at all. Each correct match is worth one point.

NOTE: Each correct selection is worth one point.

You are building Power Bl visualizations for a team.

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?

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 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.

An organization plans to create Power Platform solutions and is evaluating Microsoft Dataverse.

Instructions: 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's customer-facing applications must comply with Global Data Protection Regulations (GDPR) regulations.

You need to recommend actions to help ensure GDPR compliance.

Which two features should the company use? Each correct answer presents part of the 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 Microsoft 365, Power Platform, and Dynamics 365. You do not assign permissions to any licensed users.

Users are able to create and edit Power Apps canvas apps.

In which environment are users creating and editing the apps?

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 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.

O: 63

A company is considering implementing Power Platform.

For which three scenarios should you consider implementing Power Apps portals? Each correct answer

presents a complete solution.

NOTE: Each correct selection is worth one point.

A company is building a Power Apps portal.

You need to select out-of-the-box portal types to meet the company's requirements.

Which portal types should you use? To answer, drag the appropriate portal types to the correct requirements. Each portal 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 is creating a canvas app to display data from a legacy system that is located on the company’s internal network.

You need to connect to the data.

What should you use?

A company uses Dynamics 365 Supply Chain Management.

The company wants to build custom user interfaces that add additional functionality.

You need to recommend a solution for the company.

What should you recommend?

A company has a Power Apps app that is used by most employees. The company is expanding to other

countries/regions.

You need to recommend a solution to translate text generated within the Power Apps in near real-time.

What should you recommend?

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 user is trying to understand the differences between the various ways apps can be built by using Power Apps.

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 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.

You are designing a Power Apps solution that allows users to upload a status report directly to the company Microsoft SharePoint project management site from their mobile device.

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

NOTE: Each correct selection is worth one point.