PL-900 Describe the business value of Microsoft Power Platform Practice Test 9 — 15 Questions

Question 1

An organization needs to create a centralized repository of business data that can be used by Power Apps, Power Automate, and Power BI. Which data storage option is designed for this purpose?

Accepted Answer

Microsoft Dataverse. Microsoft Dataverse is the correct choice because it is a low-code data platform specifically designed to securely store and manage business data used by Power Apps, Power Automate, and Power BI. It provides a common data schema, built-in business logic, role-based security, and seamless integration with the Power Platform, making it the centralized repository for business data.

Answer

SharePoint lists

Answer

Azure SQL Database

Answer

Excel Online

Question 2

Refer to the exhibit. You are reviewing a Power Apps app definition. Based on the exhibit, which connector does the app use?

Accepted Answer

Microsoft Dataverse. The exhibit shows a Power Apps app definition that includes a reference to a Microsoft Dataverse table (e.g., 'Accounts' or 'Contacts') as the data source. Dataverse is the native data platform for Power Apps, providing relational tables, business logic, and security directly within the Power Platform. The connector used is Microsoft Dataverse, which is the default connector when building canvas or model-driven apps with Dataverse tables.

Answer

Office 365 Users

Answer

SQL Server

Answer

SharePoint

Question 3

A sales team wants to automate follow-up emails after a lead is created in Dynamics 365 Sales. Which Power Platform component should they use?

Accepted Answer

Power Automate. Power Automate is the correct component because it is designed to create automated workflows that trigger actions based on events, such as sending follow-up emails when a lead is created in Dynamics 365 Sales. It integrates directly with Dynamics 365 via connectors, allowing you to define a trigger (e.g., 'When a lead is created') and an action (e.g., 'Send an email') without custom code.

Answer

Power BI

Answer

Power Apps

Answer

Power Virtual Agents

Question 4

A company wants to enable its field service technicians to access customer records and update work orders from their mobile devices offline. Which Power Platform solution should they implement?

Accepted Answer

Power Apps (model-driven) configured for offline use. Model-driven Power Apps natively support offline capabilities through the Dynamics 365 offline sync engine, which allows field service technicians to access customer records and update work orders without connectivity. When the device reconnects, changes are automatically synchronized with the Dataverse, ensuring data consistency. This makes it the correct choice for mobile offline scenarios.

Answer

Power Pages website accessible from mobile browsers

Answer

Power BI dashboards embedded in a mobile app

Answer

Power Automate flows to sync data periodically

Question 5

An organization is using Microsoft Power Platform to build a compliance solution. They need to ensure that sensitive data in Dataverse is encrypted at rest and that access is audited. Which feature should they enable?

Accepted Answer

Customer-managed encryption key (CMK) and Audit logging. Customer-managed encryption key (CMK) provides control over the encryption key used to encrypt data at rest in Dataverse, ensuring sensitive data is encrypted with a key managed by the organization. Audit logging records all access and changes to data, enabling compliance auditing. Together, they directly address the requirements for encryption at rest and access auditing.

Answer

Data Loss Prevention (DLP) policies

Answer

Power Apps business rules

Answer

Microsoft Entra ID Conditional Access policies

Question 6

A marketing department wants to create a custom portal where external partners can submit project proposals and track their status. Which Power Platform product should they use?

Accepted Answer

Power Apps portal (now Power Pages). Power Apps portals (now Power Pages) is the correct choice because it enables organizations to create low-code, externally facing websites that allow external users—such as partners—to sign in, submit project proposals, and track their status. It integrates with Microsoft Dataverse to store and manage the proposal data, and supports role-based access control to ensure partners only see their own submissions.

Answer

Power Automate

Answer

Power Virtual Agents

Answer

Power BI

Question 7

A business analyst wants to create a real-time dashboard showing sales performance from Dynamics 365 Sales data. Which tool should they use?

Accepted Answer

Power BI. Power BI is the correct tool for creating real-time dashboards because it is designed specifically for data visualization and business intelligence. It can connect directly to Dynamics 365 Sales data via the Dataverse connector or direct query mode, enabling live, interactive dashboards that refresh automatically as data changes.

Answer

Power Apps

Answer

Power Pages

Answer

Power Automate

Question 8

An organization plans to deploy a Power Platform solution that uses Dataverse as the data source. They need to ensure that users can only see records from their own department. What should they implement?

Accepted Answer

Business units and security roles with team-based access. Business units and security roles with team-based access are the correct implementation because Dataverse uses a hierarchical security model where business units define the organizational structure and security roles control record-level permissions. By configuring business units per department and assigning users to teams within those units, you can enforce that users only see records belonging to their own department through record ownership and sharing rules.

Answer

Power Automate to filter records

Answer

Audit logging

Answer

Column-level security profiles

Question 9

A company wants to use AI to automatically categorize customer support tickets based on their description. Which Power Platform AI capability should they use?

Accepted Answer

AI Builder category classification model. AI Builder's category classification model is specifically designed to automatically categorize text into predefined categories, making it ideal for routing support tickets based on their description. This prebuilt AI model uses natural language processing to analyze the text and assign the most relevant category without requiring custom machine learning expertise.

Answer

Power Automate with a regular expression

Answer

Power Virtual Agents (now Copilot Studio)

Answer

Power BI AI visuals

Question 10

A nonprofit organization needs to track donations and volunteers using a custom app without writing code. Which Power Platform tool should they use?

Accepted Answer

Power Apps. Power Apps allows building custom apps with low-code or no-code. Power Automate is for automation, Power BI for analytics, and Power Pages for portals.

Answer

Power BI

Answer

Power Pages

Answer

Power Automate

Question 11

A company has a legacy on-premises SQL Server database and wants to integrate it with a Power App without moving data to the cloud. Which connector should they use?

Accepted Answer

On-premises data gateway with SQL Server connector. The On-premises data gateway acts as a secure bridge between cloud services like Power Apps and on-premises data sources such as SQL Server. When combined with the SQL Server connector, it allows live queries and updates to the on-premises database without requiring data migration to the cloud, fulfilling the requirement to keep data on-premises.

Answer

SQL Server connector directly

Answer

Power Automate on-premises agent

Answer

Dataverse

Question 12

Which Power Platform component can be used to create and deploy a chatbot?

Accepted Answer

Copilot Studio. Copilot Studio (formerly Power Virtual Agents) is the dedicated Power Platform component for creating and deploying chatbots using a no-code graphical interface. It allows you to design conversational topics, trigger flows, and publish the bot to channels like Microsoft Teams or websites without writing code. AI Builder provides AI models that can be integrated into a chatbot solution but cannot create or deploy a standalone chatbot.

Answer

Power Automate

Answer

Power BI

Answer

Power Apps

Answer

AI Builder

Question 13

Which THREE are benefits of using Dataverse as the data platform for Power Platform solutions?

Accepted Answer

Built-in role-based security and auditing. Dataverse provides built-in role-based security that allows administrators to control access at the row, field, and table levels using security roles, and it includes automatic auditing to track data changes. This is a core benefit for enterprise compliance and data governance within Power Platform solutions.

Answer

Full relational database capabilities with T-SQL support

Answer

Free unlimited storage for all data types

Question 14

Which TWO are common use cases for Power Automate?

Accepted Answer

Automating approval workflows. Power Automate is used for automating business processes and integrating apps. Building custom apps is Power Apps, creating dashboards is Power BI, and managing user identities is Microsoft Entra ID.

Answer

Creating interactive dashboards

Answer

Managing user access to Microsoft 365

Answer

Building custom mobile applications

Question 15

An administrator creates the DLP policy shown above. Which of the following actions will be blocked?

Accepted Answer

Creating a flow that uses SharePoint and Salesforce. The DLP policy shown blocks the SharePoint connector, and creating a flow that uses both SharePoint and Salesforce would involve the SharePoint connector, which is prohibited by the policy. DLP policies in Power Platform restrict specific connectors from being used together in the same app or flow, and since SharePoint is blocked, any flow that includes it is prevented from being created or run.

Answer

Using Power Apps with Dataverse

Answer

Creating a flow that uses Dataverse and SQL Server

Answer

Using Power BI with SQL Server