Introduction
Welcome to Part 3 of the PL-900 Practice Questions series!
In Part 1 and Part 2, we explored Microsoft Power Platform fundamentals, including Power Apps, Power Automate, Power BI, Power Pages, Microsoft Dataverse, and AI Builder.
In this article, we’ll continue with 25 Microsoft Power Platform Fundamentals (PL-900) practice questions, focusing on practical business scenarios and selecting the right Power Platform capabilities.
Topics Covered
- Power BI Desktop and Power BI Service
- Power BI Reports and Dashboards
- Power Query and Data Transformation
- Power Apps Canvas Apps
- Microsoft Dataverse
- Power Automate Cloud Flows
- On-Premises Data Gateway
- AI Builder
- Power Platform Connectors
- Business Process Flows
- Data Integration
- Microsoft Azure AI Services
Each question includes four answer options, the correct answer, and a short explanation to help you understand the concept.
Question 51
A company wants to create complex Power BI reports, transform data, and define relationships between tables.
Which tool should the company primarily use?
A. Power BI Service
B. Power BI Desktop
C. Power Automate
D. Power Pages
Correct Answer: B. Power BI Desktop
Explanation: Power BI Desktop provides tools for data modeling, transformation, and report development.
Question 52
Which Power BI component provides a cloud-based environment for publishing, sharing, and collaborating on reports?
A. Power Query
B. Power BI Desktop
C. Power BI Service
D. Power Apps
Correct Answer: C. Power BI Service
Explanation: Power BI Service is the cloud platform used to publish, share, and manage reports and dashboards.
Question 53
A company wants to create an application that allows employees to submit expense reports from their mobile devices.
Which Microsoft Power Platform product should it use?
A. Power BI
B. Power Apps
C. Power Automate Desktop
D. Azure Monitor
Correct Answer: B. Power Apps
Explanation: Power Apps enables organizations to build low-code business applications that employees can access from supported devices.
Question 54
A company wants to automatically send an email whenever a new record is created in Microsoft Dataverse.
Which Power Automate flow type should it use?
A. Scheduled cloud flow
B. Automated cloud flow
C. Desktop flow
D. Business Process Flow
Correct Answer: B. Automated cloud flow
Explanation: Automated cloud flows run when a configured event occurs, such as the creation of a Dataverse record.
Question 55
Which Power Platform component provides secure storage for business data using tables, columns, and relationships?
A. Power BI
B. Power Automate
C. Microsoft Dataverse
D. Power Pages
Correct Answer: C. Microsoft Dataverse
Explanation: Dataverse provides structured business data storage, relationships, security, and business logic.
Question 56
A company wants to create a business application with a customized interface and flexible screen layouts.
Which type of Power Apps application should it use?
A. Model-Driven App
B. Canvas App
C. Power BI Report
D. Power Automate Flow
Correct Answer: B. Canvas App
Explanation: Canvas Apps allow developers to design customized screens and application experiences.
Question 57
Which Power Platform capability allows organizations to define a sequence of stages that employees follow when processing business records?
A. Business Process Flow
B. Power BI Dashboard
C. Azure Monitor
D. Power Query
Correct Answer: A. Business Process Flow
Explanation: Business Process Flows guide users through defined stages and steps to support consistent business processes.
Question 58
Your company has an on-premises SQL Server database containing historical sales data.
You need to display the data in a Power Apps application while securely connecting to the on-premises database.
What should you use?
A. Power BI Dashboard
B. Azure Policy
C. On-Premises Data Gateway
D. Power Apps Theme
Correct Answer: C. On-Premises Data Gateway
Explanation: An On-Premises Data Gateway provides secure connectivity between supported cloud services and on-premises data sources.
Question 59
A recent update to a Power Apps Canvas App causes usability issues.
You need to return the application to a previous working version.
What should you do?
A. Restore the previous version of the application
B. Delete the application permanently
C. Recreate the application from scratch
D. Delete the Dataverse environment
Correct Answer: A. Restore the previous version of the application
Explanation: Power Apps supports restoring earlier saved versions of Canvas Apps.
Question 60
Which Microsoft Power Platform service is primarily designed to automate repetitive business tasks?
A. Power BI
B. Power Automate
C. Power Pages
D. Microsoft Dataverse
Correct Answer: B. Power Automate
Explanation: Power Automate enables organizations to create automated workflows between applications and services.
Question 61
A company wants to analyze customer feedback and identify whether comments are positive, negative, or neutral.
Which AI capability should it use?
A. Object Detection
B. Sentiment Analysis
C. Image Classification
D. Document Processing
Correct Answer: B. Sentiment Analysis
Explanation: Sentiment analysis evaluates text to identify its emotional tone.
Question 62
Which Power Platform capability enables users to integrate applications with services such as SharePoint, Outlook, and SQL Server?
A. Connectors
B. Business Rules
C. Environments
D. Power BI Bookmarks
Correct Answer: A. Connectors
Explanation: Connectors enable communication between Power Platform applications and supported external services.
Question 63
A company needs to connect Power Apps to an external REST API that does not have a predefined connector.
Which component should it create?
A. Power BI Report
B. Custom Connector
C. Business Process Flow
D. Dataverse View
Correct Answer: B. Custom Connector
Explanation: Custom Connectors enable Power Apps and Power Automate to communicate with supported external APIs.
Question 64
A company creates a Power BI dashboard and wants coworkers to collaborate on its content.
Which approach is most appropriate?
A. Create a Power BI workspace and grant coworkers appropriate roles
B. Export the dashboard to an image
C. Store screenshots in SharePoint
D. Create an Azure Virtual Machine
Correct Answer: A. Create a Power BI workspace and grant coworkers appropriate roles
Explanation: Power BI workspaces support collaboration by allowing users to manage and edit content according to their assigned permissions.
Question 65
A company uses Dynamics 365 Sales and wants to create a Power BI report showing customer office locations.
The City and State columns must be combined into one column.
Which Power BI tool should it use?
A. Power Query Editor
B. Power BI Dashboard
C. Power Automate Approvals
D. Microsoft Dataverse Security Roles
Correct Answer: A. Power Query Editor
Explanation: Power Query Editor provides transformation operations, including merging columns.
Question 66
Which Power BI component is designed to display important business metrics on a single page?
A. Dashboard
B. Data Gateway
C. Power Query
D. Dataflow
Correct Answer: A. Dashboard
Explanation: A Power BI dashboard presents important visualizations and business metrics on a single canvas.
Question 67
A company wants to create reports with multiple pages, charts, tables, and interactive filters.
Which Power BI component should it use?
A. Dashboard
B. Report
C. Workspace
D. Connector
Correct Answer: B. Report
Explanation: Power BI reports support multiple pages and interactive visualizations for detailed analysis.
Question 68
Which Power Platform feature helps prevent inappropriate sharing of organizational data through connectors?
A. Data Loss Prevention Policies
B. Canvas App Themes
C. Power BI Bookmarks
D. Business Process Flows
Correct Answer: A. Data Loss Prevention Policies
Explanation: Data Loss Prevention policies govern connector usage and help organizations control how data is shared between services.
Question 69
A company wants to automate the extraction of invoice numbers, dates, and amounts from invoices.
Which Power Platform capability should it use?
A. AI Builder Document Processing
B. Power BI Dashboard
C. Canvas App Theme
D. Power Automate Desktop Recorder
Correct Answer: A. AI Builder Document Processing
Explanation: AI Builder document processing can extract structured information from supported business documents.
Question 70
Which type of Power Automate flow runs when a user manually selects a button?
A. Scheduled cloud flow
B. Automated cloud flow
C. Instant cloud flow
D. Business Process Flow
Correct Answer: C. Instant cloud flow
Explanation: Instant cloud flows are triggered manually by users, such as through a button in Power Automate or Power Apps.
Question 71
A company wants to automatically run a Power Automate workflow every Monday morning.
Which flow type should it use?
A. Instant cloud flow
B. Scheduled cloud flow
C. Desktop flow
D. Business Process Flow
Correct Answer: B. Scheduled cloud flow
Explanation: Scheduled cloud flows run at configured times or recurring intervals.
Question 72
Which Power Platform capability allows organizations to create separate spaces for development, testing, and production?
A. Power BI Reports
B. Environments
C. Business Rules
D. AI Builder Models
Correct Answer: B. Environments
Explanation: Power Platform environments separate applications, flows, data, and administrative configurations.
Question 73
Which Power Platform product is designed for creating secure, external-facing business websites?
A. Power BI
B. Power Automate
C. Power Pages
D. Power Query
Correct Answer: C. Power Pages
Explanation: Power Pages enables organizations to build business websites for external users, such as customers, partners, and suppliers.
Question 74
A company wants to predict future sales outcomes based on historical business data.
Which AI Builder model type should it consider?
A. Object Detection
B. Prediction
C. Text Recognition
D. Sentiment Analysis
Correct Answer: B. Prediction
Explanation: AI Builder prediction models can use historical data to predict supported business outcomes.
Question 75
A company uses a Power Apps application across multiple countries.
It needs to translate application-generated text into different languages in near real time.
Which Microsoft Azure capability should it use?
A. Azure Synapse Analytics
B. Azure AI Translator
C. Microsoft Dataverse
D. Power BI
Correct Answer: B. Azure AI Translator
Explanation: Azure AI Translator provides machine translation capabilities that applications can integrate to translate text between supported languages.
Conclusion
Congratulations on completing Part 3 of the PL-900 Practice Questions series (Questions 51–75)!
In this article, we explored important Microsoft Power Platform concepts related to business application development, workflow automation, data integration, reporting, and artificial intelligence.
Key Concepts to Remember
- Power BI Desktop: Develop reports, transform data, and create data models.
- Power BI Service: Publish, share, and collaborate on reports and dashboards.
- Power Apps: Build low-code business applications.
- Canvas Apps: Create applications with customized interfaces.
- Microsoft Dataverse: Store and manage structured business data.
- Power Automate: Automate repetitive business processes.
- On-Premises Data Gateway: Connect supported cloud services to on-premises data sources.
- AI Builder: Add AI capabilities to applications and workflows.
- Power Query: Clean, combine, and transform data.
- Custom Connectors: Integrate external APIs with Power Platform.
- DLP Policies: Govern connector usage and data sharing.
- Business Process Flows: Guide employees through business processes.
- Power Platform Environments: Separate development, testing, and production.
- Azure AI Translator: Translate text between languages.
When preparing for the PL-900 certification exam, focus on understanding which Power Platform product or capability is best suited for a particular business requirement.
Rather than memorizing definitions, practice identifying the correct solution based on real-world scenarios.
Connect with Me on LinkedIn
Thank you for reading! If you found this article helpful, connect with me on LinkedIn for more learning resources, technology insights, certification content, and career tips. Let’s learn and grow together.