PL-900: Microsoft Power Platform Fundamentals Part 2
Question #: 71
Topic #: 1
You create a Power BI dashboard that displays Common Data Model data.
You need to share the Power BI dashboard with coworkers and allow the coworkers to collaborate.
What are two possible ways to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. Create a Power BI workspace and grant coworkers permissions.
B. Publish the dashboard as an app to your coworkers.
C. Export the data to Microsoft Excel. Make required changes and then re-import the data.
D. Create a Power Automate flow to export the data into a SQL Server database.
Selected Answer: AB
Question #: 72
Topic #: 1
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?
A. Use Power Query Editor to merge columns.
B. Import the data.
C. Export data to Microsoft Excel.
D. Create a view.
Selected Answer: A
Question #: 75
Topic #: 1
What is a benefit of deploying Microsoft 365 and Dynamics 365 apps in the same tenant?
A. You do not need to manually back up data.
B. Both will use the same time zone.
C. You can use Power BI to display data that comes from both environments.
D. You can implement Single Sign-On (SSO).
Selected Answer: D
Question #: 76
Topic #: 1
A company runs a call center to handle customer support inquiries.
The company tracks metrics including the number of incoming calls and call resolution rates. The company wants to display the metrics on a shared screen that is visible to all call center staff.
You need to recommend a visualization solution for the company.
Which Power Platform feature should you recommend?
A. AI Builder
B. Power Automate
C. Power Apps
D. Power BI
Selected Answer: D
Question #: 78
Topic #: 1
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.
A. drill-down
B. automatic
C. database
D. manual
E. external
Selected Answer: ABD
Question #: 80
Topic #: 1
A manufacturing company uses Internet of Things (IoT) devices to monitor the temperature in different parts of their warehouse.
You need to view near real-time information from the IoT devices in Power BI Service dashboards.
Which tool should you use?
A. Scheduled refresh dataset
B. Streaming dataset
C. Content Pack dataset
D. Power BI dataflows
E. Quick Insights
Selected Answer: B
Question #: 84
Topic #: 1
A company is using Power BI.
The company wants to see which data connectors are available for building dashboards.
You need to evaluate the available connectors.
What should you use to see all the available connectors?
A. Power BI Workspace
B. Common Data Service
C. Power BI Dataflows
D. Power Platform admin center
E. Power BI Desktop
Selected Answer: D
Question #: 86
Topic #: 1
You create a set of dashboards and reports for a project team that combines data from different sources in Power BI. Some of the data is considered sensitive.
You need to distribute the dashboards and reports securely to the team.
What should you create?
A. a custom data connector
B. a published app
C. a Microsoft flow
D. a Power BI workspace
Selected Answer: D
Question #: 87
Topic #: 1
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.
A. Power BI service
B. Power BI reports
C. Power BI desktop
D. Power BI dashboards
Selected Answer: BD
Question #: 90
Topic #: 1
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. Use Power Query to merge columns.
B. Import the data.
C. Export data to Microsoft Excel.
D. Create a view.
Selected Answer: A
Question #: 91
Topic #: 1
A carpet cleaning company uses Dynamics 365 Sales.
The process for entering customer information during onsite sales calls is very complicated. The company wants a simplified screen that allows salespeople to capture the customer name, phone number, and other information while speaking to the customer.
You need to recommend a solution that works on various types of mobile devices.
What should you recommend?
A. Microsoft Dataverse
B. Power Automate
C. AI Builder
D. Canvas app
E. Power BI
Selected Answer: D
Question #: 92
Topic #: 1
A company using Power Platform is implementing Power BI. The company plans to connect to several data sources and create reports and dashboards.
You need to identify the data sources they can connect to.
Which two data sources should you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. Microsoft Excel
B. Microsoft Dataverse
C. Microsoft OneNote
D. Microsoft Word
Selected Answer: AB
Question #: 93
Topic #: 1
You create a multi-page Power BI report for an organization.
You must enable salespeople in the organization to use the report to view data relevant to their sales region only.
You need to enable security for the report.
What should you use?
A. sensitivity labels
B. Microsoft Azure Active Directory
C. Microsoft Trust Center
D. data loss prevention policies
E. row-level security
Selected Answer: E
Question #: 95
Topic #: 1
User1 creates several Power BI dashboards for a company. User1 shares a dashboard with User2 who works for another company. User2 reports that she is able to view the dashboard. User2 forwards the email containing the dashboard sharing link that she received to User3.
User3 reports that he receives an error message when he selects the link to view the dashboard. User3 can view a dashboard that he has created.
You need to determine why User3 receives an error.
What is the issue?
A. User3 is running an out-of-date version of Power BI and must upgrade to a newer version.
B. User2 is signed in to the dashboard and must sign out before User3 can sign in.
C. Forwarding the email does not share the dashboard with User3.
D. User1 is signed in using the wrong organizational account for Power BI.
Selected Answer: C
Question #: 97
Topic #: 1
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 from Microsoft 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. deployment pipelines
B. tables
C. columns
D. dashboards
Selected Answer: D
Question #: 98
Topic #: 1
You are using the Power BI 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?
A. Export data
B. Pin
C. Copy
D. Spotlight
Selected Answer: B
Question #: 99
Topic #: 1
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. Query Editor
B. Power BI Service
C. Microsoft Excel
D. Data Connector
Selected Answer: A
Question #: 110
Topic #: 1
A company uses Dynamics 365 Supply Chain Management.
The company wants to build customer user interfaces that add additional functionality.
You need to recommend a solution for the company.
What should you recommend?
A. Power BI
B. Power Apps canvas apps
C. AI Builder
D. Microsoft Flow
Selected Answer: B
Question #: 111
Topic #: 1
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.
A. Force a user to update security questions after a specific amount of time.
B. Prompt a user for consent to use their personal data and record the date consented.
C. Block users who are identified as minors.
D. Automatically deactivate a user who has not used the portal in six months.
Selected Answer: BC
Question #: 113
Topic #: 1
A company uses Power Apps canvas apps.
When a user opens Power Apps Studio in a browser and selects Apps I can edit, they do not see an app that they need to modify.
You need to determine why the user cannot see the app.
What are three possible reasons? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. The user selected an incorrect Power Apps environment.
B. The user has not been granted the System Customizer role.
C. The user has not been set as the app co-owner.
D. The app has not been shared with the user.
E. The environment does not have a Microsoft Dataverse database.
Selected Answer: ACD
Question #: 116
Topic #: 1
You create a canvas app that allows contractors to submit time they work against a project.
Contractors must be able to use the canvas app to enter time. Contractors must not be able to perform any other actions in the app.
You need to configure permissions for the contractors.
Which type of permissions should you use?
A. application-level
B. task-level
C. record-level
D. field-level
Selected Answer: D
Question #: 118
Topic #: 1
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. the Generate an app from data feature
B. a custom action in Common Data Service
C. Power Apps Checker
D. the Open entity data in Excel feature
Selected Answer: A
Question #: 121
Topic #: 1
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 app in near real-time.
What should you recommend?
A. Microsoft Azure Synapse Analytics
B. Microsoft Azure Cognitive Services
C. Common Data Service connector
D. Power BI
Selected Answer: B
Question #: 122
Topic #: 1
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. 0
B. 1
C. 2
D. 3
Selected Answer: D
Question #: 126
Topic #: 1
You create a Power Apps canvas app.
You need to ensure that your coworkers can run the app.
What should you do?
A. Share the app.
B. Send the URL for the app to coworkers.
C. Publish the app.
D. Create a Flow for the app.
Selected Answer: C
Question #: 127
Topic #: 1
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. Production
B. Default
C. Sandbox
Selected Answer: B
Question #: 128
Topic #: 1
A company uses a model-driven app for their mobile sales activities.
The company wants to modify the view that is used for sales orders. You must apply a new default filter to the view. You must also modify the default sorting for sales orders.
You need to make the changes to the view.
In which three locations can you make the changes? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. Power Apps site
B. Solution Explorer
C. Microsoft Azure DevOps
D. App Designer
E. Microsoft Visual Studio
Selected Answer: ABD
Question #: 139
Topic #: 1
You complete development and testing of a new canvas app. You add users to a security team and assign the security team permissions to the app.
Users are unable to view the app.
You need to ensure that users can launch and use the app.
What should you do?
A. Add the application to the solution.
B. Publish the application.
C. Share the application.
D. Add a Power Apps Component Framework (PCF) control to the application.
Selected Answer: B
Question #: 140
Topic #: 1
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. formula
B. gallery
C. connector
D. calculated column
Selected Answer: A
Question #: 149
Topic #: 1
You overwrite a Power Automate flow by editing the definition and saving the changes.
You need to be able to 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.
A. Export
B. Rename
C. Save As
D. Share
Selected Answer: AC
Question #: 150
Topic #: 1
You have a Power Automate to create a flow that automatically sends email to a project manager when project team members mark a task as complete.
Project team members are prematurely marking tasks as complete. Project leads must validate that tasks are complete before an email is sent to the project manager to announce task completion.
You need to modify the flow.
Which component should you use?
A. a process argument
B. a condition
C. an expression
D. a trigger
E. a solution
Selected Answer: B
Question #: 151
Topic #: 1
A company uses Power Automate.
Which three items can trigger flows? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. Lifecycle Services
B. Microsoft 365 Admin center
C. Common Data Service
D. Microsoft Outlook 365
E. Microsoft Windows Desktop
Selected Answer: CDE
Question #: 153
Topic #: 1
A company is using Power Automate to automate business processes.
You need to run a flow when a user presses a button in an app.
Which trigger type should you recommend?
A. Power Apps
B. for a selected row
C. manually trigger a flow
Selected Answer: C
Question #: 154
Topic #: 1
A company uses a manual process to manage escalations for customer support calls.
You must use Power Automate to automate the process for routing escalated calls.
You need to create the flow.
Which type of connector should you use?
A. Microsoft Excel
B. Microsoft Dataverse
C. Office 365 Users
Selected Answer: C
Question #: 155
Topic #: 1
You are creating a Power Automate flow.
The flow must read each item in a Microsoft SharePoint list that details sales opportunities and set the value for a field named Status to Overdue if the value of a field named Follow up is less than or equal to the current date.
You need to select the appropriate component to cycle through the entire list.
Which component should you use?
A. Condition
B. Connector
C. Action
D. Trigger
Selected Answer: C
Question #: 157
Topic #: 1
A company uses Power Automate.
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. plug-in
B. approval flow
C. business rule
D. team flow
E. scheduled flow
Selected Answer: B
Question #: 162
Topic #: 1
A company has a website. The website includes a form that allows the company to collect information about leads.
You need to set up an automated workflow to create leads in Dynamics 365 Sales when leads are created on the company’s custom website.
What should you create?
A. Task Flow
B. Power Automate flow
C. Dynamics 365 workflow
D. Business Process Flow
Selected Answer: B
Question #: 163
Topic #: 1
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 recommend the appropriate Microsoft Power Platform components to address the requirements.
Which two components should you recommend to invoke the notification process? Each correct answer presents part of the solution.
NOTE: Each selection is worth one point.
A. AI Builder
B. Power Automate
C. Microsoft Dataverse connector
D. Power BI
Selected Answer: BC
Question #: 164
Topic #: 1
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 daily –
✑ from an external Microsoft SQL Server instance.
✑ Send a 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. Microsoft Excel
B. Microsoft Word
C. Power BI
D. Microsoft Dataverse
E. Power Automate
Selected Answer: CE
Question #: 166
Topic #: 1
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?
A. Modify the flow and ensure that the correct manager’s email is listed in the From field.
B. Modify the flow and ensure that the correct manager’s email is listed in the To field.
C. Grant the new sales manager access to the departed sales manager’s inbox.
D. Modify the flow and ensure that the flow prompts the user to type the correct email for the To field.
E. Create a flow that automatically forwards opportunity emails to the new sales manager.
Selected Answer: B
Question #: 174
Topic #: 1
A company uses Dynamics 365 Supply Chain Management.
You need to use Power Automate to automate the process of receiving and tracking raw materials.
Which type of connector should you use?
A. Common Data Service
B. Dynamics 365
C. Dynamics 365 for Fin & Ops
D. Dynamic Signal
Selected Answer: A
Question #: 175
Topic #: 1
A company performs on-site inspections and services for air industrial equipment.
Field technicians must perform a series of maintenance checks every time they visit a customer site. Every technician performs maintenance steps in a different order. Some technicians miss steps.
You need to ensure that all technicians perform the same steps in the same order.
What should you use?
A. Business process flow
B. AI Builder
C. Business rule
D. Virtual Agent
Selected Answer: A
Question #: 176
Topic #: 1
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. Navigate to the Power Automate admin center and view the projects.
B. Navigate to the Action Items section of the Power Automate portal.
C. Enable Repair Tips for the flow.
D. Navigate to the flow and view the run history.
E. Navigate to the Power Automate web portal and click view notifications.
Selected Answer: CDE
