PL-900 Practice Test 30 — 15 Questions

Question 1

A small business wants to create a Power Apps app to track customer interactions. They have limited budget and no dedicated IT staff. The app must be easy to maintain and should use a data source that requires minimal setup. The app will be used by 5 sales reps. Which approach should they take?

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

Accepted Answer

Use a SharePoint list as the data source and a Canvas app. SharePoint lists are easy to set up with no extra licensing (often included with Microsoft 365) and can be used with Canvas apps, which are low-code and easy to maintain. Option A is wrong because Dataverse requires additional licensing and Model-driven apps are more complex to build and maintain. Option B is wrong because Excel on OneDrive does not support multi-user concurrent access reliably and can lead to data conflicts. Option C is wrong because SQL Server requires dedicated infrastructure and maintenance, which is not feasible for a small business with limited budget and no IT staff.

Answer

Use Dataverse as the data source and a Model-driven app

Answer

Use Excel stored on OneDrive and a Canvas app

Answer

Use SQL Server as the data source and a Canvas app

Question 2

Which THREE are features of model-driven apps compared to canvas apps?

Accepted Answer

Automatic form generation from Dataverse tables. Correct: A, B, and D. Model-driven apps automatically generate forms from Dataverse tables (A), have responsive design that adapts to different screen sizes (B), and include built-in business process flows (D). Option C is incorrect because drag-and-drop layout customization is a feature of canvas apps, not model-driven apps. Option E is incorrect because pixel-perfect design control is a characteristic of canvas apps, while model-driven apps provide a more structured layout.

Answer

Drag-and-drop layout customization

Answer

Full control over pixel-perfect design

Question 3

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 4

Your organization uses Power Automate to synchronize data between Salesforce and Dataverse. The flow runs successfully for most records, but some records fail with a 'duplicate record' error in Dataverse. You need to prevent duplicate records from being created. What should you do?

Accepted Answer

Configure duplicate detection rules in Dataverse and use the 'Create a new record' action with duplicate detection enabled.. Configuring duplicate detection rules in Dataverse and using the 'Create a new record' action with duplicate detection enabled will prevent duplicates. Option B is wrong because the 'Compose' action is used to create variables and does not check for duplicates. Option C is wrong because using 'Update a record' requires an existing record; it does not prevent creation of duplicates. Option D is wrong because using 'Delete a record' before creating a new one is not a standard method to handle duplicate detection and may cause data loss.

Answer

Use the 'Compose' action to check for duplicates before creation.

Answer

Use the 'Update a record' action instead of 'Create a new record' to update existing records.

Answer

Use the 'Delete a record' action before creating a new one.

Question 5

A business analyst creates a model-driven app to manage customer service cases. The app includes a custom form with a field called 'Priority' that has three options: Low, Medium, High. The analyst wants to ensure that only users in the 'Service Managers' security role can change the priority of a case. What should the analyst do?

Accepted Answer

Configure a field security profile for the Priority field and grant read-only access to other roles.. Field security profiles allow restricting write access to specific fields based on user roles. Option B is wrong because editing the Service Manager security role to include write privileges for the Case entity would grant write access to all fields, not just Priority, and would not restrict other roles. Option C is wrong because setting the field to 'Read-Only' in the form editor applies to all users, not based on roles. Option D is wrong because a business rule to hide the field does not prevent users with direct URL access or other methods from changing the field; it only hides it in the form.

Answer

Edit the Service Manager security role to include write privileges for the Case entity.

Answer

Set the Priority field to 'Read-Only' in the form editor.

Answer

Create a business rule to hide the field when the user is not a Service Manager.

Question 6

A company wants to allow external partners to submit support tickets via a web interface. The data should be stored in Dataverse. Which type of app should they build?

Accepted Answer

Power Apps portal. Power Apps portals (now Power Pages) are specifically designed to create external-facing websites that allow external users, such as partners, to interact with Dataverse data through a web interface. Canvas apps and model-driven apps are intended for internal users, while Power Virtual Agents is for chatbots.

Answer

Canvas app

Answer

Power Virtual Agents bot

Answer

Model-driven app

Question 7

A company uses a model-driven app to manage support tickets. Users want to automate the creation of a follow-up task when a ticket is resolved. Which component should be used?

Accepted Answer

Power Automate flow. Power Automate can trigger on record changes (e.g., status change to resolved) to automatically create a follow-up task. Option B is wrong because Microsoft Copilot Studio is for building chatbots, not for task automation. Option C is wrong because a custom Power Apps page would require manual interaction, not automation. Option D is wrong because Business Rules are limited to simple form logic and cannot create records.

Answer

Microsoft Copilot Studio

Answer

Custom Power Apps page

Answer

Business Rule

Question 8

A company wants to integrate Power Automate with Microsoft Teams so that when a new task is assigned in Planner, a message is posted in a Teams channel. Which connector should be used?

Accepted Answer

Microsoft Teams. Microsoft Teams. The Microsoft Teams connector allows posting messages to Teams channels, which is exactly what the scenario requires. Option A (Outlook.com) is for personal email, not Teams. Option B (SharePoint) is for document management, not Teams messaging. Option C (Office 365 Outlook) is for email and calendar, not for posting to Teams channels.

Answer

Outlook.com

Answer

SharePoint

Answer

Office 365 Outlook

Question 9

You need to create a Power Automate flow that runs every Monday at 9 AM to update a SharePoint list. Which trigger should you use?

Accepted Answer

Schedule - Recurrence. The correct trigger for a flow that runs on a schedule (every Monday at 9 AM) is the 'Schedule - Recurrence' trigger. Option A ('When an item is created') is an event-based trigger that runs when an item is added to a list, not on a schedule. Option B ('Power Apps button') is a manual trigger that requires user interaction. Option D ('When a new email arrives') is an event-based trigger that runs when an email arrives. Therefore, only option C meets the requirement.

Answer

When an item is created

Answer

Power Apps button

Answer

When a new email arrives

Question 10

Which THREE Power Automate features are available only in premium licenses? (Choose 3)

Accepted Answer

Robotic Process Automation (RPA). Options B, C, and E are correct. Robotic Process Automation (RPA), business process flows, and AI Builder models require premium licenses. Options A and D are available with standard licenses.

Answer

SharePoint triggers

Answer

Approval flows

Question 11

Which TWO data sources can be directly connected to a canvas app without using an on-premises data gateway?

Accepted Answer

SharePoint Online. Options C and E are correct because SharePoint Online and Microsoft Dataverse are cloud-based data sources that can be directly connected to canvas apps without an on-premises data gateway. Options A, B, and D are incorrect because SQL Server on-premises, SAP ERP on-premises, and Oracle database on-premises all require an on-premises data gateway to connect.

Answer

SQL Server on-premises

Answer

SAP ERP on-premises

Answer

Oracle database on-premises

Question 12

Refer to the exhibit. You have a Power Automate flow that sends an approval email and then checks if the email was sent successfully. If successful, it updates a SharePoint item status to 'Approved'. Otherwise, it sends a rejection email. However, the flow always updates the SharePoint item to 'Approved' even when the approval email fails. What is the likely issue?

Accepted Answer

The flow uses 'Send an email' instead of a proper approval action.. The flow uses the 'Send an email' action, which only sends an email message; it does not implement an approval process. The 'Succeeded' status indicates the email was sent, not that the recipient approved. To create an approval, you must use the 'Start and wait for an approval' action, which pauses the flow until the recipient responds. Options A, B, and D are incorrect because they do not address the core issue: the lack of a proper approval action.

Answer

The 'email/To' parameter is missing the recipient's email.

Answer

The condition expression is incorrectly formatted.

Answer

The 'body' function should be 'outputs' instead.

Question 13

Which THREE are valid data sources for canvas apps in Power Apps?

Accepted Answer

SQL Server database. Correct: A, C, and D. SQL Server (A), SharePoint lists (C), and Microsoft Dataverse (D) are all supported data sources for canvas apps. Option B is incorrect because local Excel files are not directly supported; they must be stored in OneDrive or SharePoint to be used with the Excel Online connector. Option E is incorrect because Oracle Database is not a built-in connector in Power Apps.

Answer

Local Excel file

Answer

Oracle Database

Question 14

A Power Automate flow uses a 'When a HTTP request is received' trigger. The flow is called by an external application. The flow runs successfully but the external application receives a '500 Internal Server Error' response. What is the most likely cause?

Accepted Answer

The flow does not have a 'Respond to a PowerApp or flow' action to send a response.. When a Power Automate flow is triggered by an HTTP request, it must include a 'Respond to a PowerApp or flow' action to send a response back to the caller. If this action is missing, the flow will still run but the HTTP trigger will timeout or return a 500 error because no response is sent. Option A is incorrect because if the flow were disabled, the trigger would not fire and the external application would likely get a 404 or 503, not a 500. Option B is incorrect because the flow runs, meaning the request was received; a payload mismatch would cause a different error (like a 400) or failure within the flow. Option D is incorrect because authentication issues typically return 401 Unauthorized, not 500.

Answer

The flow is disabled or paused.

Answer

The external application is not sending the correct JSON payload.

Answer

The flow requires authentication and the API key is missing.

Question 15

A retail company is building a Power Apps canvas app for store managers to review sales performance. The app connects to a SQL database and displays real-time sales data. The managers need to be able to filter data by store and date range, and view the data in a chart. The company wants to minimize licensing costs while ensuring scalability and performance. Which TWO features should you recommend?

Accepted Answer

Create a SQL stored procedure to filter and aggregate data before sending to the app.. (Create a SQL stored procedure to filter and aggregate data before sending to the app) improves performance and scalability by offloading complex queries to the database. Option D (Integrate a Power BI tile to display filtered charts and graphs) allows embedding live reports and charts directly into the canvas app, providing robust filtering and visualization capabilities without additional licensing. Option A is incorrect because custom connectors require additional development and licensing, and are not necessary for security if the SQL database is properly configured. Option C is incorrect because using Collect() to load all data on app start would not provide real-time data and could cause performance issues with large datasets. Option E is incorrect because the Office365Users connector is for user information, not for retrieving sales data from Excel Online, and Excel Online is not suitable for real-time SQL data integration.

Answer

Build a custom connector to the SQL database for enhanced security.

Answer

Use Collect() to load all data into a collection on app start for offline access.

Answer

Use the Office365Users connector to retrieve sales data from Excel Online.