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

Question 1

You are a Power Apps developer at Contoso Ltd. The company uses Microsoft 365 E5 licenses and has a complex environment with multiple departments. The HR department needs a canvas app to manage employee onboarding. The app must connect to a SharePoint Online list containing employee records, and also to the Microsoft Graph API to retrieve manager information. The app should be accessible to HR staff only, who are in a security group named 'HR-Staff'. You need to design the app to ensure data security and minimize licensing costs. The app will be used by 50 HR staff members. You have the following options: A) Create a canvas app using Power Apps, connect to SharePoint via the SharePoint connector and to Microsoft Graph via the HTTP connector with custom authentication. Share the app with the 'HR-Staff' security group. B) Create a model-driven app using Power Apps, connect to SharePoint via the SharePoint connector and to Microsoft Graph via the Microsoft Graph connector provided in Power Apps. Share the app with individual users. C) Create a canvas app using Power Apps, connect to SharePoint via the SharePoint connector and to Microsoft Graph via the HTTP connector with custom authentication. Share the app with individual users. D) Create a model-driven app using Power Apps, connect to SharePoint via the SharePoint connector and to Microsoft Graph via the Microsoft Graph connector provided in Power Apps. Share the app with the 'HR-Staff' security group. Choose the best option.

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Create a model-driven app using Power Apps, connect to SharePoint via the SharePoint connector and to Microsoft Graph via the Microsoft Graph connector provided in Power Apps. Share the app with the 'HR-Staff' security group.. Model-driven apps support sharing with security groups natively, simplifying access management for the 50 HR staff members. The Microsoft Graph connector provided in Power Apps offers a simpler and more secure integration than the HTTP connector with custom authentication. Option C (model-driven app with Microsoft Graph connector and security group sharing) meets both requirements efficiently. Option D (model-driven app with individual sharing) is less efficient for managing 50 users. Option A (canvas app with HTTP connector and individual users) introduces complexity and lacks native group sharing. Option B (canvas app with HTTP connector and security group) requires premium licensing for group sharing and uses a custom connector, increasing cost and complexity.

Answer

Create a canvas app using Power Apps, connect to SharePoint via the SharePoint connector and to Microsoft Graph via the HTTP connector with custom authentication. Share the app with individual users.

Answer

Create a canvas app using Power Apps, connect to SharePoint via the SharePoint connector and to Microsoft Graph via the HTTP connector with custom authentication. Share the app with the 'HR-Staff' security group.

Answer

Create a model-driven app using Power Apps, connect to SharePoint via the SharePoint connector and to Microsoft Graph via the Microsoft Graph connector provided in Power Apps. Share the app with individual users.

Question 2

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. Canvas apps provide a flexible, customizable user interface that supports camera controls for taking photos and can easily connect to SharePoint lists for data storage and filtering. Option B (Power Automate flow) is incorrect because it is an automation tool, not an app builder. Option C (Model-driven app) is less suitable due to limited UI customization for camera integration. Option D (Power Pages) is designed for external websites, not mobile field technician apps.

Answer

Power Automate flow

Answer

Model-driven app

Answer

Power Pages website

Question 3

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.. 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 4

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.. 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 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.. By creating a custom security role with record-level security, you can configure sharing so that doctors only see appointments where the Doctor field equals themselves. Option A: Field-level security hides the Doctor field from the form but does not filter records; doctors could still see all appointments. Option C: Creating a team and sharing the app provides app access but does not restrict data visibility; all doctors would see all appointments. Option D: Hierarchy security is for manager-subordinate relationships, not for filtering by a specific field like Doctor.

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.. 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.. 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.. Using a SQL view that filters data server-side minimizes data transfer over the network, improving performance with large datasets. Option A: Using Power Automate adds unnecessary latency and complexity. Option B: The Filter function in Power Apps retrieves all rows from the SQL table and then filters client-side, which is inefficient for millions of rows. Option D: The Search function also operates on client-side data, leading to performance degradation.

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. The command bar designer in the app designer allows adding custom buttons that invoke flows, offering a modern and supported method for customizing the ribbon in model-driven apps. Option B: PCF is used for building custom components, not simple button actions. Option C: Solution Explorer is for classic customizations but is not recommended for modern apps. Option D: Ribbon Workbench is a third-party tool, not an 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. Power Pages is the correct choice because it is designed for external-facing portals that can be accessed anonymously, allowing customers to submit support tickets without signing in. Option A (Power Automate portal) is used for managing flows, not for building portals. Option C (Canvas app with anonymous access) requires authentication; Canvas apps do not support true anonymous access. Option D (Model-driven app with anonymous access) also requires authentication; model-driven apps are for internal users with proper licensing.

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: C and E. Option C: Sharing with a security group is a valid method for canvas apps. Option E: Sharing with individual users by entering their email addresses is the most common and straightforward method. Option A is wrong because sharing with a distribution group is not supported; security groups or Microsoft 365 groups can be used. Option B is wrong because sharing with 'Everyone' in the organization is not supported for canvas apps without premium licensing. Option D is wrong because sharing with a Microsoft 365 group is not directly supported; you can share with the group's members individually or use a security group.

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: B, D, E. Option B: Business rules allow enforcing data validation on forms. Option D: Model-driven apps provide a unified interface across tablet and mobile devices. Option E: They have responsive design that adapts to screen size. Option A is incorrect because model-driven apps use predefined forms and views, not custom drag-and-drop layouts — that capability is for canvas apps. Option C is incorrect because the built-in camera control is a feature of canvas apps, not model-driven apps.

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. The correct answers are D (Dataverse) and E (SharePoint Online). Both are cloud-based data sources that can be directly accessed in a canvas app without needing an on-premises data gateway. On-premises data sources such as SQL Server, Oracle Database, and SAP HANA (options A, B, and C) require a gateway to connect from a cloud canvas app.

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.. 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

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.. It uses owner teams to provide record-level security, ensuring that doctors and managers only see cases assigned to them. JavaScript can call a Power Automate flow to send immediate Teams notifications when Priority is Critical, and the flow can implement a 4-hour escalation timer. Adding a custom Copilot page provides patient history summarization. Auditing can be enabled via Power Apps settings. This combination meets all requirements with minimal custom development. Option B is incorrect because field-level security profiles control access to specific fields, not record visibility; they cannot restrict users to only seeing records assigned to them. Option C is incorrect because sharing permissions are not designed for role-based, record-level access control; they are for ad-hoc sharing. Option D is incorrect because business rules cannot trigger notifications or set timers; they are for simple logic within forms.

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.

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.