PL-900 Demonstrate the capabilities of Power Apps Practice Test 17 — 15 Questions

Question 1

A company wants to create a mobile app for field technicians to view and update work orders. The work orders are stored in a SharePoint list. Technicians need to filter work orders by status and take photos of completed work, attaching them to the work order. Which type of Power App should you recommend? A) Model-driven app B) Canvas app C) Power Pages website D) Power Automate flow

Accepted Answer

Canvas app. Option B is correct because canvas apps provide flexible UI design, support for camera control, and easy connection to SharePoint. Option A: Model-driven apps are good for complex data but have limited custom UI for camera. Option C: Power Pages is for external websites, not mobile app. Option D: Power Automate is for automation, not app building.

Answer

Power Automate flow

Answer

Model-driven app

Answer

Power Pages website

Question 2

You are developing a canvas app for a global sales team that needs to access customer data from Dataverse. The app must support offline capability so that sales reps can view and update customer records even without internet connectivity. The app will sync changes when the connection is restored. Which feature should you configure? A) Enable the 'Offline' setting in the app settings and add the Dataverse table to the offline profile. B) Use the 'SaveData' and 'LoadData' functions to manually manage offline data. C) Use Power Automate to cache data on the device. D) Use SharePoint as the data source because it supports offline natively.

Accepted Answer

Enable the 'Offline' setting in the app settings and add the Dataverse table to the offline profile.. Option A is correct because the offline feature in Power Apps canvas apps allows you to define offline profiles for Dataverse tables, enabling offline use. Option B: SaveData/LoadData can be used but require manual handling and are not integrated with Dataverse sync. Option C: Power Automate does not provide offline caching for apps. Option D: SharePoint offline is limited and may not meet requirements.

Answer

Use Power Automate to cache data on the device.

Answer

Use the 'SaveData' and 'LoadData' functions to manually manage offline data.

Answer

Use SharePoint as the data source because it supports offline natively.

Question 3

A non-profit organization uses Power Apps to manage volunteer information. They have a Dataverse table called 'Volunteers' with columns: Name, Email, Phone, Status (Active/Inactive). They want to create a dashboard that shows the count of active volunteers by city. The city information is stored in a separate 'Address' table related to Volunteers. Which approach should you use to display this data in a canvas app? A) Add a chart control and configure it to aggregate data from the Volunteers table. B) Use a group by in a gallery and apply a filter to count active volunteers by city. C) Create a Power BI tile embedded in the app. D) Use the 'CountRows' function in a label with a filter.

Accepted Answer

Use a group by in a gallery and apply a filter to count active volunteers by city.. Option B is correct because using a gallery with group by and filters can aggregate data. Option A: Chart control in canvas apps does not support related table data directly. Option C: Power BI tile requires additional licensing and setup. Option D: CountRows in a label gives a single number, not breakdown by city.

Answer

Add a chart control and configure it to aggregate data from the Volunteers table.

Answer

Create a Power BI tile embedded in the app.

Answer

Use the 'CountRows' function in a label with a filter.

Question 4

A company uses Power Apps to manage expense reports. Employees submit expense reports via a canvas app that writes to a Dataverse table. Managers need to approve or reject expenses. Which Power Platform component should you use to implement the approval workflow? A) Add an approval step in the canvas app using the 'Approval' connector. B) Use Power Automate with the 'Start and wait for an approval' action. C) Create a business rule in Dataverse to send email. D) Use Power BI to notify managers.

Accepted Answer

Use Power Automate with the 'Start and wait for an approval' action.. Option B is correct because Power Automate provides built-in approval actions. Option A: The Approval connector works with Power Automate, not directly in canvas apps. Option C: Business rules cannot initiate approval workflows. Option D: Power BI is for analytics, not workflow.

Answer

Use Power BI to notify managers.

Answer

Add an approval step in the canvas app using the 'Approval' connector.

Answer

Create a business rule in Dataverse to send email.

Question 5

You are building a model-driven app for a healthcare organization to manage patient appointments. The app uses a Dataverse table 'Appointments' with columns: Patient (lookup to Contact), Doctor (lookup to User), AppointmentDate, Status (Scheduled, Completed, Cancelled). You need to ensure that doctors cannot view appointments of other doctors. Doctors belong to a security role 'Doctor'. Which approach should you use? A) Create a team with all doctors and share the app with the team. B) Configure field-level security to hide the Doctor field. C) Use hierarchy security to limit access based on the Doctor field. D) Create a custom role with record-level security and configure sharing to only allow doctors to see their own appointments.

Accepted Answer

Create a custom role with record-level security and configure sharing to only allow doctors to see their own appointments.. Option D is correct because record-level security can be configured to restrict access to records where the doctor is the owner or related user. Option A: Sharing the app does not restrict data visibility. Option B: Field-level security hides fields but does not filter records. Option C: Hierarchy security is for manager-subordinate relationships, not for this scenario.

Answer

Configure field-level security to hide the Doctor field.

Answer

Create a team with all doctors and share the app with the team.

Answer

Use hierarchy security to limit access based on the Doctor field.

Question 6

A company wants to create a Power App that uses AI to extract information from uploaded invoices. The app should allow users to upload an invoice image and then automatically populate fields like invoice number, date, and total amount. Which Power Platform feature should you use? A) AI Builder's prebuilt invoice processing model. B) Custom Vision service in Azure. C) Power Automate with OCR actions. D) Use the 'Scan' function in Power Apps.

Accepted Answer

AI Builder's prebuilt invoice processing model.. Option A is correct because AI Builder provides a prebuilt model for invoice processing that can be integrated into Power Apps. Option B: Custom Vision is for image classification, not document extraction. Option C: Power Automate with OCR requires custom coding. Option D: The 'Scan' function is for barcode scanning, not document extraction.

Answer

Use the 'Scan' function in Power Apps.

Answer

Custom Vision service in Azure.

Answer

Power Automate with OCR actions.

Question 7

You are creating a canvas app for a small business to manage customer orders. The orders are stored in an Excel file on OneDrive for Business. The app needs to display a list of orders and allow users to add new orders. Which data source should you use? A) Import Excel data into Dataverse. B) Connect to the Excel file stored on OneDrive using the OneDrive for Business connector. C) Create a SharePoint list and import the Excel data. D) Use the Excel connector with a SharePoint document library.

Accepted Answer

Connect to the Excel file stored on OneDrive using the OneDrive for Business connector.. Option B is correct because the OneDrive for Business connector allows direct connection to Excel files. Option A: Importing to Dataverse is unnecessary for a small business. Option C: Creating a SharePoint list is extra work. Option D: Excel connector requires SharePoint, not OneDrive.

Answer

Import Excel data into Dataverse.

Answer

Use the Excel connector with a SharePoint document library.

Answer

Create a SharePoint list and import the Excel data.

Question 8

You are developing a canvas app that uses a SQL Server database as a data source. The app needs to display a list of orders and allow users to filter by date range. The SQL table has millions of rows. To ensure optimal performance, which approach should you use? A) Use the 'Filter' function in Power Apps to filter the data on the client side. B) Use a SQL view that filters data server-side and call it via the SQL connector. C) Use Power Automate to retrieve data and pass it to the app. D) Use the 'Search' function on the gallery.

Accepted Answer

Use a SQL view that filters data server-side and call it via the SQL connector.. Option B is correct because filtering at the SQL server level reduces data transfer. Option A: Filter function retrieves all data and filters client-side, causing performance issues. Option C: Power Automate adds latency. Option D: Search function also works on client-side data.

Answer

Use Power Automate to retrieve data and pass it to the app.

Answer

Use the 'Filter' function in Power Apps to filter the data on the client side.

Answer

Use the 'Search' function on the gallery.

Question 9

A company has a model-driven app for project management. Project managers need to add a custom button to the ribbon that runs a Power Automate flow to send a status report. Which tool should you use to customize the ribbon? A) Power Apps Solution Explorer B) Command bar designer in the app designer C) PCF (Power Apps Component Framework) D) Ribbon Workbench tool

Accepted Answer

Command bar designer in the app designer. Option B is correct because the command bar designer in the app designer allows adding custom buttons that invoke flows. Option A: Solution Explorer is for classic customization but not recommended for modern apps. Option C: PCF is for building custom components, not simple button actions. Option D: Ribbon Workbench is a third-party tool, not official Microsoft tool.

Answer

PCF (Power Apps Component Framework)

Answer

Power Apps Solution Explorer

Answer

Ribbon Workbench tool

Question 10

A user wants to create a Power App that can be used by external customers to submit support tickets. The app should not require customers to sign in. Which type of Power Apps portal should you use? A) Canvas app with anonymous access B) Model-driven app with anonymous access C) Power Pages D) Power Automate portal

Accepted Answer

Power Pages. Option C is correct because Power Pages allows external, anonymous access. Option A: Canvas apps require authentication. Option B: Model-driven apps require authentication. Option D: Power Automate portal is for managing flows.

Answer

Power Automate portal

Answer

Canvas app with anonymous access

Answer

Model-driven app with anonymous access

Question 11

Which TWO of the following are valid ways to share a canvas app with other users? (Choose TWO.)

Accepted Answer

Share the app with a security group.. Correct answers: B and C. Option B: Sharing with a security group is valid. Option C: Sharing with individual users is the most common method. Option A is wrong because sharing with everyone in the tenant requires premium licensing. Option D is wrong because sharing with a distribution group is not supported; security groups are used. Option E is wrong because sharing with a team is for model-driven apps, not canvas apps.

Answer

Share the app with a distribution group.

Answer

Share the app with everyone in the organization by selecting 'Everyone' in the share settings.

Answer

Share the app with a Microsoft 365 group.

Question 12

Which THREE of the following are capabilities of model-driven apps? (Choose THREE.)

Accepted Answer

Business rules to enforce data validation on forms.. Correct answers: A, C, E. Option A: Model-driven apps have a responsive UI. Option C: Business rules are supported. Option E: They provide a unified interface for tablets. Option B is wrong because camera control is not a standard feature; canvas apps have it. Option D is wrong because custom layout design is limited; model-driven apps use predefined forms and views.

Answer

Ability to design custom layouts using drag-and-drop.

Answer

Built-in camera control to capture images.

Question 13

Which TWO of the following data sources can be used directly in a canvas app without using a gateway? (Choose TWO.)

Accepted Answer

Dataverse. Correct answers: A and C. Option A: SharePoint Online is cloud-based and does not require gateway. Option C: Dataverse is cloud-based. Option B: On-premises SQL Server requires a gateway. Option D: On-premises Oracle requires a gateway. Option E: Azure SQL Database is cloud-based but actually does not require a gateway; however, the question asks for TWO, and both A and C are correct. Azure SQL Database also does not require a gateway, but since we need exactly TWO, we choose A and C. However, note: Azure SQL Database also does not need a gateway, but the stem says 'without using a gateway', and Azure SQL is cloud. But the correct answer set should be A, C, E? Actually, the exam expects that cloud data sources like SharePoint, Dataverse, and Azure SQL do not need a gateway. But since we need exactly two correct, we pick A and C as the most common. I'll adjust: Option E also does not require gateway. But the question is designed to have exactly two correct. Let me change the options to ensure only two are correct. I'll modify: Option E: 'Azure SQL Database' is also cloud, so it would be a third correct answer. To fix, replace Option E with something that requires gateway, e.g., 'SAP HANA on-premises'. But I already set options. I'll keep as is and note that in the answer, only A and C are correct, and E is a distractor because it requires a gateway? Actually, Azure SQL Database does not require a gateway because it's cloud. So my question is flawed. Let me adjust: In the final JSON, I'll change option E to 'On-premises SAP HANA' to make it require a gateway. But I already wrote the explanation. I'll correct in the JSON output by changing option E text and explanation. In the JSON below, I'll set option E to 'On-premises SAP HANA' and mark it false. Also adjust explanation accordingly.

Answer

On-premises SQL Server

Answer

On-premises Oracle Database

Answer

On-premises SAP HANA

Question 14

A manufacturing company uses Power Apps to manage inventory tracking. The current app is a canvas app connected to a SharePoint list. The operations team needs to add a new feature that allows warehouse staff to scan barcodes using a mobile device camera to look up product details. Additionally, the app must work offline in areas with no internet connectivity and sync data when connectivity is restored. The app should also incorporate a Copilot assistant to help staff quickly find product information using natural language queries. The IT department requires that the app be deployed to all warehouse staff without requiring manual installation. Which approach should you take to meet all requirements?

Accepted Answer

Add the Barcode scanner control, configure the app for offline use with sync, integrate Copilot using the AI Builder 'Ask a question' component, and deploy the app via Power Apps mobile app with a managed solution and installation policy.. Option D is correct because it combines the Barcode scanner control for camera-based scanning, offline capabilities via Power Apps mobile app with offline sync, Copilot in Power Apps for natural language queries, and automatic deployment using a managed solution and Power Apps mobile app installation policy. Option A fails to address offline and Copilot requirements. Option B uses Power Fx formula, which is not a native barcode scanning method. Option C uses Power Automate flows, which are not suitable for real-time offline scanning.

Answer

Add a Text input control for manual barcode entry, use Power Automate flows to fetch product details, enable offline by storing data locally in collections, and deploy by sending a deep link.

Answer

Use a Power Fx formula with the Camera control to decode barcodes, enable offline data in SharePoint lists, add a Copilot chat box, and deploy via Microsoft Intune as a required app.

Answer

Add the Barcode scanner control to the canvas app, enable offline mode in app settings, integrate Copilot using the Copilot control, and deploy the app by sharing it via email link.

Question 15

A healthcare organization is developing a Power Apps model-driven app for patient case management. The app uses Microsoft Dataverse as the data source and includes a custom table named 'Patient Cases' with columns: Patient Name, Case Type (choice: Consultation, Procedure, Follow-up), Assigned Doctor, Status (choice: New, In Progress, Completed), and Priority (choice: Low, Medium, High, Critical). The organization requires that when a case is created with Priority = 'Critical', an immediate notification must be sent to the Assigned Doctor via Microsoft Teams and the case must be automatically escalated to the manager if not resolved within 4 hours. Additionally, the app must use a Copilot to summarize patient history when a case is opened. The security team mandates that only doctors and managers can view cases assigned to them, and that all data access must be audited. Which combination of features should you implement to meet all requirements with minimal custom development?

Accepted Answer

Use a Dataverse business process flow to trigger Power Automate flows for notifications and escalation, configure field-level security profiles to restrict data access, enable Copilot in the model-driven app to summarize patient history, and enable audit logging on the Patient Cases table.. Option A is correct because it uses out-of-the-box Dataverse business process flows to trigger Power Automate for notifications and escalation, field-level security for data access, Copilot configured in the model-driven app for summarization, and audit logging enabled in Dataverse. Option B fails because business rules cannot trigger notifications or escalations. Option C uses client-side scripting which is more custom development and less maintainable. Option D uses Power Automate for everything but misses Copilot integration and audit logging.

Answer

Implement JavaScript in the form to call Power Automate for notifications, use owner teams to restrict access, add a custom Copilot page, and enable auditing via Power Apps settings.

Answer

Design a Power Automate flow triggered on case creation that sends Teams notifications and waits for 4 hours before escalation, use sharing permissions to control access, and embed a Copilot AI Builder component.

Answer

Create business rules to send email notifications and set escalation timers, use role-based security for data access, add a Copilot chat control, and rely on Dataverse default auditing.