Microsoft (PL-900) Power Platform Fundamentals Sample Questions

Advanced Sample Questions

What is the Power Platform?

• A. A suite of tools for building low-code applications.
• B. A cloud-based service for managing data.
• C. A set of tools for managing virtual machines.
• D. A set of tools for managing network infrastructure.

Answer: A. The Power Platform is a suite of low-code tools that enable users to build custom applications, automate workflows, and analyze data.

What is a canvas app?

• A. An app that uses pre-built templates.
• B. An app that runs on a mobile device.
• C. An app that is designed to run on a specific operating system.
• D. An app that is built by dragging and dropping user interface elements onto a canvas.

Answer: D. A canvas app is an app that is built by dragging and dropping user interface elements onto a canvas. Canvas apps are highly customizable and can be used to build a wide variety of applications.

Explanation: Canvas apps are a key component of the Power Platform, and are used to build custom applications that can be tailored to meet specific business needs. Canvas apps are designed to be highly flexible, and can be built without writing any code.

What is a model-driven app?

• A. An app that is built using a specific model.
• B. An app that is built using a pre-built template.
• C. An app that is designed to run on a specific operating system.
• D. An app that is built using pre-built components.

Answer: A. A model-driven app is an app that is built using a specific data model. Model-driven apps are designed to be highly structured, and are typically used to manage complex data sets.

Explanation: Model-driven apps are another key component of the Power Platform, and are used to build applications that are highly structured and require a specific data model. Model-driven apps are built using pre-built components, which makes it easy to create complex applications without writing any code.

What is Power Automate?

• A. A tool for automating workflows.
• B. A tool for analyzing data.
• C. A tool for building custom applications.
• D. A tool for managing virtual machines.

Answer: A. Power Automate is a tool for automating workflows. With Power Automate, users can create automated workflows that streamline business processes and save time.

Explanation: Power Automate is a powerful tool that enables users to automate repetitive tasks, streamline business processes, and connect different systems and applications. Power Automate includes a wide range of pre-built templates, connectors, and triggers, which makes it easy to get started with automation.

What is Power BI?

• A. A tool for analyzing data.
• B. A tool for building custom applications.
• C. A tool for managing virtual machines.
• D. A tool for automating workflows.

Answer: A. Power BI is a tool for analyzing data. With Power BI, users can create interactive visualizations and dashboards that make it easy to analyze and share data.

Explanation: Power BI is a key component of the Power Platform, and is used to create powerful data visualizations and dashboards. Power BI includes a wide range of features and tools that enable users to create interactive reports and dashboards, analyze data in real-time, and share insights with others.

What is the Common Data Service?

• A. A cloud-based service for managing data.
• B. A tool for building custom applications.
• C. A set of tools for managing network infrastructure.
• D. A tool for automating workflows.

Answer: A. The Common Data Service (CDS) is a cloud-based service for managing data. With CDS, users can create a common data model that can be used across different applications and services.

Explanation: The Common Data Service is a powerful tool that enables users to create a common data model that can be used across different applications and services. CDS includes a wide range of features and tools that enable users to create, manage, and share data in a highly structured and organized way.

What is a connector in the Power Platform?

• A. A pre-built integration between two systems or applications.
• B. A tool for analyzing data.
• C. A tool for building custom applications.
• D. A tool for automating workflows.

Answer: A. A connector in the Power Platform is a pre-built integration between two systems or applications. Connectors enable different systems and applications to communicate and exchange data.

Explanation: Connectors are a key component of the Power Platform, and enable different systems and applications to communicate and exchange data. Connectors are pre-built, which makes it easy to create integrations between different systems without writing any code.

What is the Power Apps Portal?

• A. A web-based platform for building low-code applications.
• B. A tool for managing data.
• C. A set of tools for managing network infrastructure.
• D. A set of tools for automating workflows.

Answer: A. The Power Apps Portal is a web-based platform for building low-code applications. With the Power Apps Portal, users can create customized websites and portals that provide access to business data and applications.

Explanation: The Power Apps Portal is a powerful tool that enables users to create customized websites and portals that provide access to business data and applications. The Power Apps Portal includes a wide range of features and tools that make it easy to create highly customized and branded websites and portals.

What is the Power Platform Admin Center?

• A. A centralized location for managing Power Platform environments and resources.
• B. A tool for analyzing data.
• C. A tool for building custom applications.
• D. A tool for automating workflows.

Answer: A. The Power Platform Admin Center is a centralized location for managing Power Platform environments and resources. With the Power Platform Admin Center, users can manage environments, users, security, and other resources.

Explanation: The Power Platform Admin Center is a powerful tool that enables users to manage all aspects of their Power Platform environments and resources. With the Power Platform Admin Center, users can manage security, user access, data retention policies, and other resources.

What is the Power Platform Integration Service?

• A. A tool for integrating data between different systems and applications.
• B. A tool for analyzing data.
• C. A tool for building custom applications.
• D. A tool for automating workflows.

Answer: A. The Power Platform Integration Service is a tool for integrating data between different systems and applications. With the Integration Service, users can create powerful integrations that connect different systems and applications.

Explanation: The Power Platform Integration Service is a powerful tool that enables users to create integrations that connect different systems and applications. The Integration Service includes a wide range of features and tools that make it easy to create highly customized and complex integrations.

Basic Sample Questions

Question 1. An organization uses Dynamics 365 Sales and a browser-based application named Sales Hub. This information needs to be accessible from mobile devices. Which app do users need to install?

• A. Dynamics 365 Remote Assist
• B. Dynamics 365 Finance
• C. Dynamics 365 Business Central
• D. Dynamics 365 for Phones

Correct Answer: D 

Explanation: You can do sales, customer service, field service, and other tasks when you’re on the go by making use of Dynamics 365 for phones and tablets. Your app store will automatically give you access to all the apps you need for your job with just one download. With the new Unified Interface, you can download apps for all your mobile devices.

Reference: https://docs.microsoft.com/en-us/dynamics365/mobile-app/dynamics-365-phones-tablets-users-guide

Question 2. You must implement Microsoft Business Applications in conjunction with the Microsoft Power platform. What three Microsoft products comprise the Power platform? 

• A. Microsoft Power Apps
• B. Azure Active Directory
• C. Power Automate
• D. Azure Machine Learning
• E. Microsoft Power BI

Correct Answer: ACE 

Explanation: The Power Platform uses PowerApps, Power BI, and Power Automate (previously named Flow) to customize, extend, and build all the apps you need for your business and unlock the potential of Office 365 and Dynamics 365.

Reference: https://docs.microsoft.com/en-us/learn/powerplatform/

Question 3. A large retail company implements Power Apps, Microsoft Flow, and the Common Data Service. Members of the board are wondering whether users are looking for value in these technologies. It would be beneficial for the corporation to measure and report the use of the software. Which tool would you recommend for determining software usage?

• A. Microsoft Intune
• B. Azure Stream Analytics
• C. Power Platform Analytics
• D. Dynamics 365 Product Insights

Correct Answer: C 

Explanation: Power Platform Analytics Usage is the default report available to the logged-in environment administrator. It provides statistics on the number of app launches as well as daily active users for all apps in the environment. Filtering can be done based on the device platform, player version, country, state, and city.

Reference: https://docs.microsoft.com/en-us/power-platform/admin/analytics-powerapps

Question 4. Your company is working on the evaluation of the ways that they can implement AI Builder. For which two scenarios can you use AI Builder? 

• A. Sending emails to all users who subscribe to a service.
• B. Synchronizing data from an external database.
• C. Collecting data from several data sources and displaying a dashboard that shows trending data.
• D. Interpreting images and performing an action based on the image.
• E. Detecting patterns in data and predicting outcomes.

Correct Answer: DE 

Reference: https://powerapps.microsoft.com/en-us/blog/introducing-ai-builder-for-powerplatform/

Question 5. A company uses Microsoft 365 and Dynamics 365 Sales and has no developers on its staff. How would you explain the benefits of using Power Platform apps to the executives? 

• A. Sending emails from Dynamics 365 Sales to their personal email addresses.
• B. Creating Power Apps for creating apps for different departments.
• C. Using Power Automate for sharing information between Microsoft 365 and Dynamics 365 Sales.
• D. Company can unify all the mobile devices to a single vendor.

Correct Answer: BC

Question 6. A company uses Dynamics 365 Supply Chain Management and Dynamics 365 Finance. There needs to be synchronization of user account information between these two systems. You must ensure that all the synchronized data is in one place.

How would you proceed?

• A. Azure IoT Central
• B. Azure Active Directory
• C. SQL Server
• D. Common Data Service

Correct Answer: D 

Reference: https://docs.microsoft.com/en-us/power-platform/admin/data-integrator

Question 7. Suppose you are the sales manager for a large retail firm. As part of the development of your Power Apps app, you need to use your old point-of-sale (POS) system to display custom product purchase information and link those sales with the customer accounts and product sales in Dynamics 365 Commerce. What appropriate component would you use?

• A. Microsoft Dataverse
• B. business process flow
• C. entity metadata
• D. business rule

Correct Answer: A

Question 8. You are using Dynamics 365 Sales, and need to pull data into a Power BI report for your team. It is necessary to combine the columns for City and State on the report. Which function would you use? 

• A. Using Power Query to merge columns.
• B. Importing the data.
• C. Exporting data to Microsoft Excel.
• D. Creating a view.

Correct Answer: A 

Reference: https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data

Question 9. There is a company that runs a chain of retail stores. A list of store names and numbers is stored in a Power BI table. In another table, which also contains the store number, the company stores sale transaction data, with a transaction ID. What is the best way to show the name of the retail store in all PowerBI reports?

• A. Query Editor
• B. Power BI Service
• C. Microsoft Excel
• D. Data Connector

Correct Answer: A 

Explanation: A Query Editor is included in Power BI Desktop, where you can connect to one or more data sources and shape and transform the data to meet your requirements before loading the model into Power BI Desktop.

Reference: https://docs.microsoft.com/en-us/power-bi/desktop-query-overview

Question 10. What would you use for displaying the sales orders greater than a specific threshold in a Power BI report?

• A. filter
• B. Power Query
• C. Common Data Service
• D. connector

Correct Answer: A 

Question 11. If you are a sales representative, you would like to create a Power BI report that visualizes data from an Excel workbook. Reports must be able to be viewed and shared by users. Which two actions would you perform? 

• A. Pinning the report to a dashboard.
• B. Exporting the data.
• C. Publishing the dashboard.
• D. Sharing the dashboard.

Correct Answer: AD 

Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-pin-live-tile-from-report

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-share-dashboards#limitations-and-considerations

Question 12. As part of Dynamics 365 Customer Engagement, you create a Power BI dashboard that displays data, and you need to share it with colleagues.

What are three possible ways to reach the target?

• A. Creating a Power BI workspace and granting coworkers permissions.
• B. Publishing the dashboard as an app to your coworkers.
• C. Exporting the data into Common Data Service for others for manipulating in Power BI.
• D. Exporting the data to Microsoft Excel for coworkers for importing and viewing in Power BI.
• E. Embedding reports in your company’s internal web portal.

Correct Answer: ABE 

Explanation: A: In most cases, the most common method for sharing Power BI content is Basic Sharing for Dashboards and Reports through a workspace. The dashboard or report can be shared with other users by clicking the Share button in the dashboard or report.

B: Your development environment (workspace), and user environment (App) remain isolated from one another with Power BI App, 

E: It may not always be necessary to share securely, you may simply look for an easy, free way to share, and your content may not be extremely confidential or sensitive. You can embed the Power BI report in any web page by using an embed code generated from the Publish to a Web method.

Reference: https://radacad.com/power-bi-sharing-methods-comparison-all-in-one-review

Question 13. There has been a recent update to an app for canvas. There are usability issues caused by the update. What should you do to roll back the app to a previous version? 

• A. Restoring the previous version of the app.
• B. Uninstalling the app for all users and reinstalling by using the package from a previous version.
• C. Deactivating the live app, importing the previous version of the app, and then activating the app.
• D. Deleting the app and creating a new app based on the previous version.

Correct Answer: A 

Explanation: Restoring a canvas app to a previous version in PowerApps.

Restoring an app from your account

1. First, open powerapps.com. Click the Apps in the left navigation bar.
2. Second, tap the info icon of the app that needs to be restored, near the right edge, 
3. Then, in the Versions tab, select the version you wish to restore and click or tap Restore.
4. Select Restore from the confirmation dialog box.

A newer version will now be added to your list.

Reference: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/restore-an-app

Question 14. Having become the district manager of a large retail company, you need to train each store manager on the use of Power BI to track sales and daily sales targets. An employee at a store remembers seeing a Power BI dashboard option to Analyse in Excel, but can’t find it.

How should you advise the user to help resolve the issue?

• A. Installing the Power BI Desktop app.
• B. Selecting the Spotlight button on the dashboard tile.
• C. Subscribing to the dashboard and following the email link.
• D. Navigating to the report used by the dashboard.

Correct Answer: D 

Reference: https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel

Question 15. Using Power BI, you create a dashboard that displays data from the Common Data Model. Coworkers should have access to the Power BI dashboard and be able to collaborate with each other. What are two possible ways to reach the target?

• A. Creating a Power BI workspace and granting coworkers permissions.
• B. Publishing the dashboard as an app to your coworkers.
• C. Exporting the data to Microsoft Excel. Making the required changes and then re-importing the data.
• D. Creating a Power Automate flow for exporting the data into a SQL Server database.

Correct Answer: AB 

Reference: https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-create-the-new-workspaces

Question 16. Your company uses Dynamics 365 Sales, and you need to create a Power BI report that includes the location of the customer’s office. You must combine the City and State columns into one column on the report. How would you proceed?

• A. Using Power Query Editor for merging columns.
• B. Importing the data.
• C. Exporting data to Microsoft Excel.
• D. Creating a view.

Correct Answer: A 

Reference: https://support.microsoft.com/en-us/office/merge-columns-power-query-80ec9e1e-1eb6-4048-b500-d5d42d9f0a8d

Question 17. When Microsoft 365 and Dynamics 365 apps are deployed in the same tenant, what are the benefits?

• A. No need for manually backing up data.
• B. Both will be using the same time zone.
• C. Using Power BI for displaying data that comes from both environments.
• D. Implementing Single Sign-On (SSO)

Correct Answer: C 

Reference: https://docs.microsoft.com/en-us/power-platform/admin/use-power-bi

Question 18. Power BI reports can be filtered using filters, and you need to decide which filters to use. Do you have the option of using any of the three types of filters? 

• A. drill-down
• B. automatic
• C. database
• D. manual
• E. external

Correct Answer: ABD 

Reference: https://docs.microsoft.com/en-us/power-bi/power-bi-report-filter-types

Question 19. With Power BI, you are building charts with your company’s data. For example, you create area charts, pie charts, and donut charts. It is necessary for you to display the charts to others in the company. To which two objects can you add the charts?

• A. Power BI service
• B. Power BI reports
• C. Power BI desktop
• D. Power BI dashboards

Correct Answer: BD 

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

Question 20. It is your responsibility to create a Power App portal. In the portal, when a user attempts to sign in, an error message appears: User not found. The sign-in information of the user is correct, and you confirm it. How will you determine the cause of the error?

• A. Disabling custom error messages
• B. Creating a custom error message.
• C. Enabling diagnostic tools in Lifecycle Services.
• D. Enabling Maintenance mode.

Correct Answer: C 

Reference: https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/lifecycle-services/monitoring-diagnostics

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/lifecycle-services/user-logins