PL-900 Practice Test 5 — 10 Questions

Question 1

You are a Power Platform consultant for a large university that wants to build a public-facing Power Pages site for alumni. The site must allow alumni to register, update their profile, view upcoming events, and donate to the university. The university uses Microsoft Entra ID for staff and students, but alumni will use their personal email accounts to register. The security team requires that all data transmitted between the browser and the portal be encrypted. Additionally, the alumni relations team needs to send targeted emails to alumni based on their interests, which are captured during registration. The development team wants to use a low-code approach to integrate the donation functionality, which should process payments through a third-party payment gateway. You need to design the solution. Which of the following is the best approach?

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

Accepted Answer

Enable HTTPS for the site (default), store alumni profiles and interests in Dataverse, use Power Automate with a custom connector for payment processing, and use Power Automate to send targeted emails.. The best approach. Power Pages enables HTTPS by default, ensuring encrypted data transmission. Alumni can register using personal accounts via local authentication or external identity providers (like Microsoft Entra ID, but not required). Storing profiles and interests in Dataverse allows the alumni relations team to use Power Automate to send targeted emails based on interests. For payment processing, a custom connector in Power Automate can be built to call the third-party payment gateway, satisfying the low-code requirement. Option A is incorrect because using a custom web API with Liquid contradicts the low-code requirement and adds complexity. Option B is incorrect because requiring alumni to create Microsoft accounts and using Entra ID as the only provider would prevent alumni from using personal email accounts, which is a requirement. Option C is incorrect because using custom JavaScript for payment processing violates the low-code approach and may introduce security risks.

Answer

Create a custom web API in Azure to handle payments and call it from Power Pages using Liquid.

Answer

Configure Microsoft Entra ID as the only identity provider and require alumni to create a Microsoft account.

Answer

Use the Power Pages design studio to build the donation page with custom JavaScript to call the payment gateway API.

Question 2

A canvas app uses a Patch function to update a SharePoint list item. The update fails silently without error. What is the most likely cause?

Accepted Answer

The column name or data type in the Patch function does not match the SharePoint list.. When a Patch function fails silently, the most common cause is a mismatch between the column name or data type in the function and the actual SharePoint list schema. Power Apps does not throw an error for such mismatches; it simply does not apply the update. This is because the Patch function validates the data against the list's column definitions at runtime, and if the names or types don't align, the operation is ignored without raising an exception.

Answer

The user does not have permission to the SharePoint list.

Answer

The Patch function is being called with incorrect arguments.

Answer

The app is not using delegation.

Question 3

Which TWO are best practices for designing Power Automate flows in a production environment? (Select TWO.)

Accepted Answer

Use 'Configure Run After' to implement error handling.. Options B and E are correct. Using 'Configure Run After' allows you to specify actions to run based on the success, failure, or timeout of previous actions, which is essential for robust error handling in production flows. Option E, using secure inputs and outputs, prevents sensitive data from being displayed in flow run histories, protecting confidential information. Option A is incorrect because disabling logging would hinder troubleshooting and monitoring of production flows. Option C is incorrect because nesting 'Apply to each' actions can lead to performance degradation and throttling; instead, use parallel branches or optimized data processing. Option D is incorrect because hardcoding connection references reduces maintainability and security; use connection references stored in environments or Azure Key Vault for flexibility and security.

Answer

Disable flow logging to improve performance.

Answer

Nest Apply to each actions to handle large datasets.

Answer

Hardcode connection references for simplicity.

Question 4

You are a data analyst at a manufacturing company that uses Microsoft 365 and Power BI. The company has a Power BI tenant with Free, Pro, and Premium Per User (PPU) licenses. Your team has created a Power BI report that visualizes production line efficiency from a SQL Server database on-premises. The report is published to a workspace assigned to a PPU capacity. You need to ensure that all 50 users in the production department can view the report on their mobile devices, with data refreshing every 30 minutes. The users have a mix of Free and Pro licenses. The report uses DirectQuery mode to the on-premises SQL Server. You have configured an on-premises data gateway in personal mode. Users report that the report is slow and sometimes fails to load. What should you do to improve performance and reliability while meeting the refresh requirement?

Accepted Answer

Switch the on-premises data gateway from personal mode to standard mode and add additional gateways to the cluster.. The report uses DirectQuery mode, which requires a standard (on-premises data gateway) mode to handle concurrent queries efficiently. Personal mode is limited to a single user and cannot scale to support 50 users, causing slow performance and failures. Adding additional gateways to a standard mode cluster distributes the query load, improving reliability and performance while maintaining the 30-minute refresh requirement via DirectQuery.

Answer

Move the report to a shared capacity and assign all users Pro licenses.

Answer

Change the report from DirectQuery to Import mode and configure scheduled refresh every 30 minutes.

Answer

Assign all users Premium Per User licenses to ensure they can view the report.

Question 5

A Power Pages site needs to display a dynamic banner that changes based on the user's language preference. The banner text is stored in multiple languages. Which Power Pages feature should be used to manage the multilingual content?

Accepted Answer

Content snippets. Content snippets in Power Pages are used to store localized text strings. They support multiple languages and can be referenced in Liquid templates to display content based on the user's language. Option A is incorrect because web templates are for custom page layouts. Option C is incorrect because basic forms are for data entry. Option D is incorrect because page templates define the overall page structure.

Answer

Web templates

Answer

Basic forms

Answer

Page templates

Question 6

A canvas app displays a label with the formula shown. Users report that the label shows 'Welcome, !' without a name. What is the most likely cause?

Accepted Answer

The user is not authenticated with Power Apps. The User() function returns the current user's details. If the user is not signed in or the app doesn't have permission, FullName may be blank. The formula syntax is correct, and concatenation works.

Answer

The FullName property is spelled incorrectly

Answer

The ampersand (&) operator is incorrect

Answer

The User() function is not available in canvas apps

Question 7

A model-driven app has a business rule that sets the 'Priority' field to 'High' when the 'Request Type' is 'Urgent'. However, the rule does not fire when the request type is changed from the form. What is the most likely cause?

Accepted Answer

The business rule only triggers when the form loads, not on field changes.. The most likely cause is that the business rule is configured to run only when the form loads, not when a field is changed. In model-driven apps, business rules can be set to trigger 'on form load' or 'on every change'. If the rule is set to 'on form load', it will execute only when the form initially opens and will not re-fire when the 'Request Type' field is changed later. This matches option C. Option A is incorrect because scope 'All Forms' includes custom forms. Option B is incorrect because the condition type ('contains' vs 'equals') would not prevent the rule from firing; it would affect which records meet the condition. Option D is incorrect because a deactivated rule would never fire, not just when changing a field.

Answer

The business rule is set to scope 'All Forms' but the form is custom.

Answer

The condition uses 'contains' instead of 'equals'.

Answer

The business rule is deactivated in the solution.

Question 8

Which TWO are valid ways to distribute a Power App to end users? (Select 2)

Accepted Answer

Add the app to Microsoft Teams. Power Apps can be added directly to Microsoft Teams as a tab or personal app, allowing end users to access the app within the Teams interface without leaving the collaboration environment. This leverages the Teams integration capabilities of Power Apps, which uses the Teams manifest and the Power Apps app for Teams to provide seamless access.

Answer

Email the app as an attachment

Answer

Export the app and send it as a .msapp file

Answer

Publish the app to Microsoft AppSource

Question 9

Contoso, Ltd. is a multinational company with a global sales team. They use Microsoft Power Apps to build a model-driven app for managing customer accounts and opportunities. The app uses Microsoft Dataverse as the data source. The sales team accesses the app on mobile devices while traveling. Recently, users have reported that the app is slow when loading large numbers of opportunities. The app has a custom page that displays a list of all opportunities without any filters. The page uses a gallery that loads all records at once. The app also uses several custom connectors to external systems, but the slowness is primarily observed when loading the opportunities list. The IT team has confirmed that the Dataverse environment is in the same region as the users, and network latency is not an issue. They need to improve the performance of the app. Which two actions should the IT team take? (Choose two.)

Accepted Answer

Implement delegation in the gallery to filter data on the server. The correct answers are D and E. Implementing delegation in the gallery (D) ensures that filtering and sorting operations are performed server-side in Dataverse, reducing the amount of data transferred and improving load times. Adding a search box with a delegable filter (E) allows users to search for specific opportunities, and when the filter is delegable, the filtering happens on the server, further reducing the data retrieved. Option A is incorrect because disabling real-time synchronization with Microsoft Entra ID would not address data loading performance and could cause authentication issues. Option B is incorrect because simply replacing a model-driven app with a canvas app does not inherently improve performance; both app types can be optimized, and the issue is with data loading, not the app type. Option C is incorrect because increasing Dataverse storage capacity does not affect query execution speed; it only increases available storage space.

Answer

Disable real-time synchronization with Microsoft Entra ID

Answer

Replace the model-driven app with a canvas app

Answer

Increase the Dataverse storage capacity

Question 10

Refer to the exhibit. You are troubleshooting a Power Automate flow that fails when trying to access an on-premises SQL Server database. The flow uses the SQL connector. Based on the exhibit, what is the most likely cause of the failure?

Accepted Answer

The flow is using the cloud SQL connector without an on-premises data gateway.. The exhibit shows a Power Automate flow using the SQL connector to access an on-premises SQL Server database. The SQL connector in Power Automate is a cloud-based connector that, by default, cannot directly reach on-premises resources. To bridge this gap, an on-premises data gateway must be installed and configured on a machine within the same network as the SQL Server, and the connector must be associated with that gateway. Without this gateway, the flow will fail with a connection error, making option B the correct answer.

Answer

The Office 365 connector is conflicting with the SQL connector.

Answer

The environment type is Production, which restricts access to on-premises data.

Answer

The region 'eastus' does not support on-premises connectivity.