Microsoft PL-900 Online Practice Questions and Exam Preparation

Microsoft PL-900 Online Questions & Answers

• Question 21:

  HOTSPOT

  A company plans to use Power BI to visualize data.

  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.

  

  

  Explanation

• Question 22:

  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. Check AppSource for a tax add-on.
  B. Create alerts in Dynamics 365 Finance for tax table changes.
  C. Implement the Common Data Model.
  D. Run a Power BI report.
  E. Write scripts and code tax updates.
  A. Check AppSource for a tax add-on.

  ---

  Explanation

• Question 23:

  A company is creating a canvas app to track and analyze customer visits to their retail stores. Data about customer visits is stored on-premises at each retail store location.

  The app must display data about customer visits when users launch the app.

  You need to ensure that the data is available for consumption by the app.

  Which tool should you use?

  A. Connector
  B. Microsoft Dataverse
  C. Data source
  D. Power Automate
  E. Data gateway
  A. Connector

  ---

  Explanation

• Question 24:

  DRAG DROP

  A company uses Microsoft Power Platform to manage support tickets.

  Customers submit support requests by sending an email to a support email address.

  All high-priority emails must be logged into a Microsoft Excel sheet for historical purposes.

  You need to identify the components that are required for logging the emails in Excel.

  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.

  Select and Place:

  

  

  Explanation

• Question 25:

  DRAG DROP

  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.

  Select and Place:

  

  

  Explanation

  In a Venn diagram comparing Power BI Desktop and the Power BI service, the area in the middle shows how the two overlap. Some tasks you can do in either Power BI Desktop or the service. The two sides of the Venn diagram show the features that are unique to the application and the service.

  

  Reference: https://docs.microsoft.com/en-us/power-bi/designer/service-service-vs-desktop

• Question 26:

  You are creating a report in a Power Bl service by using a dataset.

  You need to add a visual.

  In which two ways can you add the visual? Each correct answer presents a complete solution.

  NOTE: Each correct selection is worth one point.

  A. Drag a field onto the canvas.
  B. Use Power Bl QandA.
  C. Pin a visual from another report.
  D. Pin a page from another report.
  E. Select a visual.
  D. Pin a page from another report.
  E. Select a visual.

  ---

  Explanation

• Question 27:

  HOTSPOT

  A user is creating their first Power Apps canvas app.

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

  NOTE: Each correct selection is worth one point.

  

  

  Explanation

• Question 28:

  DRAG DROP

  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 component types to the correct requirements. 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.

  Select and Place:

  

  

  Explanation

  Box 1: Report

  Reports are more detailed data displayed in many formats like chart, graphs list and in tabular, etc.

  Box 2: Dashboard

  Dashboards are a business key performance indicator view where it displays key values that can change business profits and can be glanced at one screen.

  Box 3: Report

  Power BI dashboards cannot slice and dice, but reports have many ways to filter and slice.

  Note: Power BI dashboards are one placeholder to display the most important decision-making facts to run a business. But reports are more detailed data displayed in many formats like chart, graphs list and in tabular, etc. Reports are based on one dataset or one business unit data for example reports of a store belonging to California.

  Reference:

  https://www.educba.com/power-bi-dashboard-vs-report/

• Question 29:

  DRAG DROP

  A company plans to use Power Automate to automate tasks.

  Match each flow type to its description. 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.

  Select and Place:

  

  

  Explanation

  Box 1: automated

  Automated flows start with an event or trigger, such as an email being received. These also support a multitude of actions in the 200+ Flow connectors.

  Box 2: business process

  The business process flow that creates stages or screens that enforce a certain sequence of steps. It collects data from users for each step in the stage and can kick off automated workflows.

  Box 3: scheduled

  Scheduled flows run regular reports that are sent out to a team and summarize everything that’s happened in the past week. This includes everything from simple daily scheduling to more complex scheduling like “every 3rd Monday.”

  Box 4: instant

  An instant flow is triggered when you click a button inside of the Flow mobile app, SharePoint, Dynamics, PowerApps, or Excel that passes context directly into your flow.

  Note: There are four different Flow types that you can choose from when starting out. You can create a scheduled flow, automated flow, instant flow, or a business process flow.

  Reference:

  https://www.avepoint.com/blog/office-365/office-365-automation/

• Question 30:

  DRAG DROP

  A company plans to implement Power Apps in a Power Platform environment.

  You need to implement other required components.

  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.

  Select and Place:

  

  

  Explanation

  Reference: https://powerapps.microsoft.com/en-us/blog/implementing-role-based-permission/

  https://www.encorebusiness.com/blog/powerapps-flow-can/