Microsoft Microsoft Certifications PL-900 Questions & Answers

• Question 201:

  DRAG DROP

  A company is implementing Power BI to track sales.

  Each of the company's regions has specific quarterly and yearly sales goals.

  You need to build a Power BI dashboard for various reporting requirements.

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

  

  Correct Answer:

  

  Box 1: KPIs

  A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a measurable goal.

  Box 2: Line chart

  Line charts emphasize the overall shape of an entire series of values, usually over time.

  Box 3: Donut

  Doughnut charts are similar to pie charts. They show the relationship of parts to a whole. The only difference is that the center is blank and allows space for a label or icon.

  Reference:

  https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a

• Question 202:

  DRAG DROP

  You plan to create a model-driven app for a company that sells plants and garden suppliers.

  The app must meet the following requirements:

  1.

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

  2.

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

  You need to create Power Automate flows for the app.

  Which types of flows should you create? To answer, drag the appropriate flow types to the correct requirements. Each flow 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:

  

  Correct Answer:

  

  Reference: https://docs.microsoft.com/en-us/power-automate/flow-types

• Question 203:

  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:

  

  Correct Answer:

  

  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 204:

  DRAG DROP

  A manufacturing company is evaluating Al Builder.

  You need to select Al Builder models to address specified requirements.

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

  

  Correct Answer:

  

  Reference: https://docs.microsoft.com/en-us/ai-builder/object-detection-model-in-flow https://docs.microsoft.com/en-us/ai-builder/prediction-overview

• Question 205:

  DRAG DROP

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

  You need to recommend Power Automate 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.

  Select and Place:

  

  Correct Answer:

  

  Box 1: Action

  An action is something that occurs as a result of the workflow. For example, send an email or copy a file. In this case, the action is to retrieve the top five posts from a Facebook page.

  Box 2: Action

  An action is something that occurs as a result of the workflow. For example, send an email or copy a file. In this case, the action is to insert records into a database.

  Box 3: Expression

  Sometimes users just need to do basic operations like getting the current time, adding numbers together, or replacing a part of a string of text. That's possible inline in any flow action. Microsoft Flow leverages the same Workflow Definition

  Language used by Azure Logic apps. For new users who are unfamiliar with the expression language, there is an inline help experience that shows how to use each expression as they build out their flow.

  Box 4: Trigger

  A trigger is something that triggers or starts the workflow. It could be a new file uploaded to a document library, a new item created in the list or an email sent to your Inbox – something that will start (kick-off the workflow).

  There are two types of triggers:

  1.

  Automatic trigger is pre-programmed into the workflow based on a certain rule (i.e. new document or item created, email sent, etc.)

  2.

  Manual Trigger is a trigger initiated by a user. Unlike with automatic trigger above, the workflow will only start when initiated manually by the end user (for example, from the Document Library for a selected file). Manual trigger is only supported for certain types of workflows (i.e. Get feedback from your manager for the selected file)

  Reference: https://sharepointmaven.com/3-major-components-microsoft-flow/ https://www.avepoint.com/blog/office-365/office-365-automation/ https://flow.microsoft.com/de-de/blog/use-expressions-in-actions/ https://docs.microsoft.com/en-us/power-automate/getting-started

• Question 206:

  DRAG DROP

  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.

  Select and Place:

  

  Correct Answer:

  

  Reference:

  https://docs.microsoft.com/en-us/dynamics365/customerengagement/on- premises/developer/customize-dev/change-application-navigation-using-sitemap

• Question 207:

  DRAG DROP

  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.

  Select and Place:

  

  Correct Answer:

  

  Reference: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/help-desk-install https://docs.microsoft.com/en-us/power-platform/admin/data-integrator https://docs.microsoft.com/en-us/power-automate/getting-started

• Question 208:

  DRAG DROP

  You are creating a Power Automate flow.

  You need to retrieve data from several sources including Microsoft Excel, Azure Data Lake and GitHub.

  What should you use? To answer, drag the appropriate components to the correct data sources. 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:

  

  Correct Answer:

  

  Box 1: Formula

  Reading an Excel document retrieves the data from the document, allowing it to be processed and modified in flows.

  Read and extract data from an Excel document with the Read from Excel worksheet action.

  Box 2: Connector

  Azure Data Lake Store connector allows you to read and add data to an Azure Data Lake account.

  The Azure Data Lake connector is available for Power Automate.

  Box 3: Expression

  Reference:

  https://docs.microsoft.com/en-us/learn/modules/pad-excel-automation/3-reading-excel-document

  https://docs.microsoft.com/en-us/connectors/azuredatalake/

• Question 209:

  DRAG DROP

  A company is creating a canvas app to manage weekly status reports from users about projects. Status reports must be created weekly. Users can enter project tasks with descriptions. Users can also add escalation requests for tasks that

  are late or at risk. When a status report is submitted with an escalation request the app must automatically send a text message to the submitter's manager. A reminder must be sent at 8 PM on Sunday to everyone who has not yet submitted

  a status report for the previous week.

  You need to identity the appropriate components to use in the solution.

  What should you use? To answer, drag the appropriate implementation mechanisms to the correct requirements. Each implementation mechanism 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:

  

  Correct Answer:

  

• Question 210:

  DRAG DROP

  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:

  1.

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

  2.

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

  3.

  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.

  Select and Place:

  

  Correct Answer: