PL-900 Sample Questions
Select the appropriate Power BI component for the task at hand: Configure Security - Power BI Desktop - Power BI Service - Both
- Both
A. Portal B. Canvas C. Model-driven 1. Allow anonymous users to interact with data stored in Microsoft Dataverse. 2. Connect to multiple data sources. 3. Use business process flows to guide the user
1 - A 2 - B 3 - C
You create an instant flow by using a Power Apps trigger. The flow sends an email to your team members once you have completed a task. How can you trigger the flow to run? A. Attach the flow to a button in a canvas app and then select the button. B. Select the button from the Buttons tab of the Power Automate mobile app. C. Update the status of a task in the app.
A. Attach the flow to a button in a canvas app and then select the button.
You are creating a Power Automate flow by using a template. Which symbol indicates that you have a valid connection that is ready for use? A. Green check mark B. Sign-in link C. Red check mark D. Yellow timer symbol
A. Green check mark
For which three items must you specify a value when you create a new chatbot? Each correct answer presents part of the solution. A. Name B. Language C. Region D. Environment E. Topic
A. Name B. Language D. Environment
Choose the correct tool for the job: Create a model-driven app Power Apps Studio App Designer Visual Studio Power Apps Desktop Power Apps admin center
App Designer
Choose the correct tool for the job: Create user accounts for Power Apps Azure Active Directory Dynamics 365 Admin Center Power Apps Admin Center Power BI Admin portal
Azure Active Directory
T/F: Power apps can be used without the use of a mouse or touch interface TRUE FALSE
TRUE
T/F: You need a Power BI Pro license to consume a Power BI report a colleague shared with you TRUE FALSE
TRUE
Leverage existing Azure cognitive services or user the built-in AI builder to enable textual sentiment analysis capabilities for apps. - Yes - No
Yes
Test executes your flow. - Yes - No
Yes
The ability to create applications and flows is controlled by security roles in the context of environments. - Yes - No
Yes
What is the purpose of a Common Data Model entity? - Set of entities, relationships and business rules that provides a common structured data store for business applications - Automated set of actions activated by a trigger that might include complex branching logic - Helps jumpstart application development by leveraging business logic, security and integrations - Set of services that exposes the data entities - A mechanism to connect to a data source - A set of records used to store data
- A set of records used to store data
What is the purpose of workflows? - Set of entities, relationships and business rules that provides a common structured data store for business applications - Automated set of actions activated by a trigger that might include complex branching logic - Helps jumpstart application development by leveraging business logic, security and integrations - Set of services that exposes the data entities - A mechanism to connect to a data source - A set of records used to store data
- Automated set of actions activated by a trigger that might include complex branching logic
Select all the options that is true for the Common Data Model (CDM). - Common Data Model is a logical database design or schema - Common Data Model is a database based on the open data model standard - Common Data Model describes relationships between data tables - Common Data Service is an instance of a database created using the Common Data Model schema - Common Data Service describes relationships between data tables - Common Data Model is an instance of a database created using the Common Data Service schema
- Common Data Model is a logical database design or schema - Common Data Model describes relationships between data tables - Common Data Service is an instance of a database created using the Common Data Model schema
Display top departmental goal metrics and alert users when certain thresholds are crossed - Report - Dashboard - Custom visual - Data story
- Dashboard
Using the prediction model of AI builder, which of the following results are possible? - Determining the likelihood that an event will occur based on data in a relational database - Determining whether or not an event will occur based in historical instances of the outcome - Determining the speed of an object given its current speed, acceleration and time
- Determining whether or not an event will occur based in historical instances of the outcome
What is the purpose of the Microsoft Power Platform? - Set of entities, relationships and business rules that provides a common structured data store for business applications - Automated set of actions activated by a trigger that might include complex branching logic - Helps jumpstart application development by leveraging business logic, security and integrations - Set of services that exposes the data entities - A mechanism to connect to a data source - A set of records used to store data
- Helps jumpstart application development by leveraging business logic, security and integrations
What are the built-in portal types? - Portal from blank - Community portal - Employee self-service portal - Partner portal - Customer self-service portal - Portal from template
- Portal from blank - Community portal - Employee self-service portal - Partner portal - Customer self-service portal
Select the correct tool for the job: Users must enter an assessment report for a site inspection using a mobile app - Power Virtual Agents - Power BI - Power Automate - Portals - AI Builder - Power Apps
- Power Apps
Select the correct tool for the job: Users must develop their own automatic workflows for common business processes - Power Virtual Agents - Power BI - Power Automate - Portals - AI Builder - Power Apps
- Power Automate
Select the correct tool for the job: Design insightful data visualizations - AI Builder - Power BI - Power Apps - Power Automate - Power Virtual Agents
- Power BI
Select the components of Power BI. - Power BI Desktop - Power BI Automation - Power BI Service - Power BI Premium Connectors - Power BI App - Power BI Mobile
- Power BI Desktop - Power BI Service - Power BI Mobile
Select the appropriate Power BI component for the task at hand: Configure sharing - Power BI Desktop - Power BI Service - Both
- Power BI Service
Display and filter sales charts by region - Report - Dashboard - Custom visual - Data story
- Report
Display data from an Excel workbook with multiple worksheets - Report - Dashboard - Custom visual - Data story
- Report
What is the purpose of the Common Data Model / Common Data Service? - Set of entities, relationships and business rules that provides a common structured data store for business applications - Automated set of actions activated by a trigger that might include complex branching logic - Helps jumpstart application development by leveraging business logic, security and integrations - Set of services that exposes the data entities - A mechanism to connect to a data source - A set of records used to store data
- Set of services that exposes the data entities
Select all correct options regarding accessibility in Power Apps - There is an accessibility checker for power apps - Power apps can use keyboard shortcuts - Power apps can use screen reader in Windows, MacOS, Android and IOS
- There is an accessibility checker for power apps - Power apps can use keyboard shortcuts - Power apps can use screen reader in Windows, MacOS, Android and IOS
You are creating a Power Platform solution as follows: 1. When I create an appointment in Office 365 Outlook 2. If the subject of the appointment starts with "Flight" 3. Block out my calendar for two and a half hours before the flight - You add ""When an event is created"" trigger"" - You add ""When an event is created"" action"" - You add ""When an event is created"" process"" - You add ""When an event is created"" gallery"" - You add ""When an event is created"" model"" - You add ""When an event is created"" business rule""
- You add ""When an event is created"" trigger""
You are creating a Power Platform solution as follows: 1. When I create an appointment in Office 365 Outlook 2. If the subject of the appointment starts with "Flight" 3. Block out my calendar for two and a half hours before the flight - You add a condition for 'subject starts with ""Flight""'"" - You add a parameter for 'subject starts with ""Flight""'"" - You add a filter 'subject starts with ""Flight""'"" - You add a template for 'subject starts with ""Flight""'"" - You add a page for 'subject starts with ""Flight""'"" - You add a rule for 'subject starts with ""Flight""'""
- You add a condition for 'subject starts with ""Flight""'""
You are creating a Power Platform solution as follows: 1. When I create an appointment in Office 365 Outlook 2. If the subject of the appointment starts with "Flight" 3. Block out my calendar for two and a half hours before the flight - You create an automated flow - You create an instant flow - You create a scheduled flow - You create a canvas app - You create a model-driven app - You create a portal app
- You create an automated flow
You are creating a Power Platform solution as follows: 1. When I create an appointment in Office 365 Outlook 2. If the subject of the appointment starts with "Flight" 3. Block out my calendar for two and a half hours before the flight - You use the addminutes() function in the 'create event' action - You use the addhours() function in the 'create event' action - You use the subtractminutes() function in the 'create event' action
- You use the addminutes() function in the 'create event' action
You have been asked by the environmental protection department in your company to help them to automate one of their business processes. Currently they send an agent out on location who takes some photos and writes some notes about the site on his/her mobile device and emails the data back to the office. The agents have different ways of completing the task and there is no official standardization of the process. Data processing clerks at the office processes the emails form agents in to a database that is part of the organization's Customer Relationship Management (CRM) solution. - You will use Power Apps - You will use Power Automate - You will use Power BI
- You will use Power Apps
Match the technologies on the left to the correct benefits on the right. Technologies Descriptions A. Power BI B. Power Apps C. Power Automate 1. Ask questions about your data using natural language. 2. Create easy-to-use apps that match your company branding. 3. Remove the administrative burden of repetitive tasks.
1 - A 2 - B 3 - C
Match the Power Automate flow types on the left to the correct use cases on the right. Flow types Use cases A. Button B. Desktop C. Scheduled D. Business process 1. Send an email to your boss when you are going to be late to the office with one click. 2. Create a guided experience to train new model-driven app users. 3. Automate entering data into a legacy system that does not provide an API. 4. Check the weather forecast every night for rain the next day and notify users attending outdoor events by using email. Answer: Button (A) matches description 1: Send an email t
1 - A 2 - D 3 - B 4 - C
A. Partner B. Community C. Employee self-service 1. Enable peer-to-peer collaboration including forums and blogs. 2. Allow external companies to collaborate on sales opportunities. 3. Allow internal users to submit cases and access knowledge articles.
1 - B 2 - A 3 - C
You are creating Power Automate cloud flows to manage expense handling for a company. Match the connectors to the descriptions. A. Control B. Approvals C. Schedule D. Data operation 1. Wait three days after requesting expense approval. 2. Total all expenses for the current month. 3. Send an email to expense approvers to review total expenses. 4. Create a list of expense approvers
1 - C 2 - A 3 - B 4 - D
A. Power Apps maker portal B. Microsoft 365 admin center C. Microsoft Power Platform admin center D. Trust center 1. Configure data policies. 2. Assign Power Apps licenses to users. 3. Find resources to manage compliance with data privacy regulations. 4. Create a canvas app
1 - C 2 - B 3 - D 4 - A
Choose the correct order of operations that a Power BI user will take to use the service effectively 1. Get data 2. Create app 3. Create dashboard 4. Share 1. Get data 2. Create report 3. Create dashboard 4. Create app 5. Share 1. Create app 2. Get data 3. Create report 4. Create dashboard 5. Share 1. Create app 2. Create dashboard 3. Share
1. Get data 2. Create report 3. Create dashboard 4. Create app 5. Share
What is the purpose of a Common Data Model data connector? - Set of entities, relationships and business rules that provides a common structured data store for business applications - Automated set of actions activated by a trigger that might include complex branching logic - Helps jumpstart application development by leveraging business logic, security and integrations - Set of services that exposes the data entities - A mechanism to connect to a data source - A set of records used to store data
A mechanism to connect to a data source
What is the purpose of a Common Data Model entity? - Set of entities, relationships and business rules that provides a common structured data store for business applications - Automated set of actions activated by a trigger that might include complex branching logic - Helps jumpstart application development by leveraging business logic, security and integrations - Set of services that exposes the data entities - A mechanism to connect to a data source - A set of records used to store data
A set of records used to store data
Which two Microsoft Power Platform components can use AI Builder models? Each correct answer presents a complete solution. A. Canvas apps B. Model-driven apps C. Portal apps D. Power Automate cloud flows
A. Canvas apps D. Power Automate cloud flows
To create a dashboard, you need to use ______________. A. Power BI Service B. Power BI Desktop C. Power BI Mobile
A. Power BI Service
In which of the following typical business processes would you use Power BI? Sending an email when a SharePoint list has changed Generating an approval Analyzing and displaying data Gathering data using a mobile device
Analyzing and displaying data
You create a canvas app. To allow users to share the app with others, you should grant the _________________ permission to the users. A. User B. Co-owner C. Contributor D. Environment maker
B. Co-owner
You are building a Power Automate cloud flow. You need to access data in a third-party application that has a REST API. There is no connector available. What are two possible ways to achieve this goal? Each correct answer presents a complete solution. A. Apply a data policy. B. Create a custom connector. C. Run Postman. D. Use the HTTP connector
B. Create a custom connector. D. Use the HTTP connector
Which Power Query transformation function allows you to unpivot rows from a Microsoft Excel data source? A. Reverse rows B. Transpose C. Count rows
B. Transpose
You need to create an object that only contains data from a single table. You should create a _____________________. A. personal chart B. main form C. classic workflow D. public view
B. main form
You need to create an app that can hide columns on forms that use business rules. You should create a ________________. A. canvas app B. model-driven app C. portal app D. power Automate cloud flow E. power BI report
B. model-driven app
Select the appropriate Power BI component for the task at hand: Create a report - Power BI Desktop - Power BI Service - Both
Both
How can you access Power Apps Studio? Download and install from powerapps.microsoft.com Browse to powerplatform.microsoft.com Browse to make.powerapps.com Browse to admin.powerplatform.microsoft.com Browse to make.powerplatform.com
Browse to make.powerapps.com
Choose the correct tool for the job: Create visual playbooks for users that assist them to enter data and perform tasks consistently Business rules Business Process Flows Common Data Service Common Data Model Power Virtual Agents Power Apps Portals
Business Process Flows
Microsoft Power Platform solutions can detect faces in images by using __________________. A. Power BI B. Azure Bot Service C. Azure Cognitive Services D. Azure Active Directory
C. Azure Cognitive Services
Which control should you use to display multiple rows from a SharePoint list in a canvas app? A. Data card B. Form C. Gallery D. Label
C. Gallery
Multiple entities in the Common Data Service can be used in the same Power App through the use of what element? Foreign key principles Primary keys Cardinal entity relationships None of the options
Cardinal entity relationships
How can you create additional Common Data Service instances? Create an additional Power Apps environment from the Power Apps admin console You can only have a single instance of the Common Data Service per tenant Create an additional CDS instance from the Office 365 admin console Create an additional CDS instance from the Dynamics 365 admin console
Create an additional Power Apps environment from the Power Apps admin console
How can you create a flow in Power Automate that recurs daily? Create the flow, edit the calendar property, set the start and end dates, set the frequency to 1 Create the flow, set the recurrence property to TRUE, the frequency property to 1 Create the flow, open the recurrence trigger, set the frequency to daily and the interval to 1 Create the flow, set the recurrence property to TRUE, the frequency to daily and the interval to 1
Create the flow, open the recurrence trigger, set the frequency to daily and the interval to 1
You are creating a Power Virtual Agents chatbot. You need to add trigger phrases to the chatbot. Where can you configure the trigger phrases? A. Authoring canvas B. Entities C. Message node D. Topic
D. Topic
To collaborate with colleagues to build Power BI reports and dashboards you should __________. A. create a template app B. share a dashboard C. share a dataset D. share a workspace
D. share a workspace
T/F: Business rules can be defined at the Power App or Power Automate level TRUE FALSE
FALSE
T/F: Common Data Service supports transactional multi-user applications, where quick response to user demand is the priority and long running or batch processing. TRUE FALSE
FALSE
T/F: Connectors in the Power Platform can read but not change data in a database. TRUE FALSE
FALSE
T/F: You must have a Power BI Pro license to use premium data connectors in the Power BI Service. TRUE FALSE
FALSE
T/F: You need a Power BI Pro license to use premium connectors in Power BI Desktop TRUE FALSE
FALSE
Authentication for users accessing the Power Platform is provided by the organization's on-premises Active Directory. - Yes - No
No
Can you change the ownership of an entity in CDS? Yes No
No
Flow Checker physically executes your flow. - Yes - No
No
You can create your own data connectors and immediately share them publicly for use by other organizations. - Yes - No
No
You use Flow Checker to verify that your flow operates correctly using historical data. - Yes - No
No
You use test when building a flow to verify the syntax and performance of your flow. - Yes - No
No
O365 groups act as security boundaries allowing different security needs to be implemented for Power Apps and flows. - Yes - No
No Environments act as security boundaries.
Sharing of model-driven apps is done directly with the user or Azure AD group. - Yes - No
No Sharing of model-driven apps is done via Common Data Service security roles.
Select the correct tool for the job: Users must develop their own apps to address business needs - Power Virtual Agents - Power BI - Power Automate - Portals - AI Builder - Power Apps
Power Apps
Choose the correct tool for the job: Connect to multiple data sources, analyse and visualise data, update source data and notify users when data measures cross thresholds. Each answer represents part of the solution. Power Apps Power Automate Power BI AI Builder PowerPoint Portals
Power Apps Power BI
Choose the correct tool for the job: Assign the environment maker role to a user Azure Active Directory Dynamics 365 Admin Center Power Apps Admin Center Power BI Admin portal
Power Apps Admin Center
Power Automate allows you to create a workflow in a simple if-this-then-that scenario. Which option would you choose if you needed to create an advanced workflow with a multiple branching logic scenario and that requires user intervention at several stages? Custom sulution developed using Visual Studio 3rd party custom workflow solution Power Automate Power Apps Power Virtual Agents Custom Connector
Power Automate
Select the correct tool for the job: Build automatic workflows that can access multiple data sources. - Power Apps - Power Automate - Power BI - Power Virtual Agents - AI Builder
Power Automate
Select the correct tool for the job: Users must be notified when a new item is added to a SharePoint list - Power Apps - Power Automate - Power Virtual Agents - Power Apps Portals - Power BI - Common Data Service
Power Automate
Choose the correct tool for the job: Notify a user on his mobile device when a new message from his manager is received and the message is marked as important. Note: the solution must be shared across the organization and must retrieve the user's manager from Azure Active Directory. Select all the correct answers. Each answer represents part of the solution. Power Automate Flow Power Apps mobile button Power Apps app Common Data Service O365 Users Connection Office 365 Outlook Connection
Power Automate Flow O365 Users Connection Office 365 Outlook Connection
What are the core components of the Power Platform? Power BI Power Apps Power Automate Power Forms PowerPoint Bower Builder
Power BI Power Apps Power Automate
Select the appropriate Power BI component for the task at hand: Create calculated columns - Power BI Desktop - Power BI Service - Both
Power BI Desktop
Select the appropriate Power BI component for the task at hand: Create a dashboard - Power BI Desktop - Power BI Service - Both
Power BI Service
What are the models in AI builder and what can they do? Prediction - yes/no Form Processing - OCR Object Detection - Vision Text Classification - Sentiment analysis
Prediction - yes/no Form Processing - OCR Object Detection - Vision Text Classification - Sentiment analysis
T/F: A Power App can be embedded into a Power BI report - TRUE - FALSE
TRUE
T/F: A Power BI connector can read but not change data in a database. - TRUE - FALSE
TRUE
T/F: A Power BI report can be embedded into a Power App TRUE FALSE
TRUE
T/F: Buttons can accept user input as part of the flow TRUE FALSE
TRUE
T/F: The Common Data Service is based on the Common Data Model standard. TRUE FALSE
TRUE
T/F: You can use AI builder to collect ServiceNow tickets and perform sentiment analysis on the text. TRUE FALSE
TRUE
T/F: You must have a Power Apps P2 license to use premium data connectors in your Power Apps. TRUE FALSE
TRUE
As part of your organization's M365 adoption, you have created a Power Automate flow for a colleague that sends him a push notification whenever he receives an email from his manager. However, the user complains that he is no longer getting his push notifications. What is the most likely cause of the problem? The user's Power Automate trial license has expired The user has a new phone and the Power Automate mobile app is not installed The user's mobile device is not registered with Intune The user's mobile device is not registered with Azure Active Directory All of the options are possible causes None of the options are possible causes
The user has a new phone and the Power Automate mobile app is not installed
Someone has sent an email to a mailing list which starts a Power Automate workflow. What type of operation occurred here? - Action - Trigger - Subroutine - Function - Procedure - Process
Trigger
A large services company has launched a project to create a citizen developer / citizen business intelligence / citizen automation revolution in the organization. The IT steering committee wants to review the success of the project. What would you recommend? Create a Power BI report Use Power Platform Analytics Use Dynamics 365 Product Insights Use Microsoft 365 Admin dashboard
Use Power Platform Analytics
A user's ability to see and use apps is controlled by sharing the application with the user. - Yes - No
Yes
Can custom entities use business rules? Yes No
Yes
Flow Checker reports errors and warnings about your flow. - Yes - No
Yes
You can connect to multiple internal (M365), external (3rd party web services like Dropbox), cloud and on-premises data sources from a canvas app simultaneously. - Yes - No
Yes
You can embed a Power BI visual in a model-driven app. - Yes - No
Yes
Can a previous version of an app be restored from backup? Yes. You have to import a previously exported version of the app Yes. You have to restore the desired version of the app from the Versions screen of the app info Yes. You have to restore the app from the Power Apps admin portal No. However, you can save-as multiple versions of an app and publish only the production-ready version of the app
Yes. You have to restore the desired version of the app from the Versions screen of the app info
You have been asked by the environmental protection department in your company to help them to automate one of their business processes. Currently they send an agent out on location who takes some photos and writes some notes about the site on his/her mobile device and emails the data back to the office. The agents have different ways of completing the task and there is no official standardization of the process. Data processing clerks at the office processes the emails form agents in to a database that is part of the organization's Customer Relationship Management (CRM) solution. You will choose new Canvas app from blank You will choose new Model-driven app from blank You will choose new Portal from blank You will choose Start from data You will define triggers (on email) You will define actions
You will choose new Model-driven app from blank. Since there is an existing structured (presumably relational) database, the best option is to create a model-driven app.
