PL-900 Practice Test 2 — 30 Questions

Question 1

An organization needs to create a custom app that displays data from Dynamics 365 Sales and allows users to update records. The app should automatically generate a responsive UI based on the data model. Which type of app should they build?

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

Accepted Answer

Model-driven app. A model-driven app is the correct choice because it automatically generates a responsive UI based on the underlying data model (e.g., Dynamics 365 Sales entities like Account, Contact, Opportunity). It provides built-in forms, views, and business process flows that allow users to view and update records without manual UI design, aligning with the requirement for automatic UI generation and data update capabilities.

Answer

Canvas app

Answer

Power Automate

Answer

Power Pages

Question 2

Which TWO of the following are valid environment types in Power Platform?

Accepted Answer

Production. Production and Sandbox are both valid environment types in Power Platform. Production environments are intended for live, end-user applications and data, while Sandbox environments are isolated, non-production environments used for development, testing, and training. Both support the full set of Power Platform capabilities, including Dataverse, Power Apps, Power Automate, and Power Virtual Agents.

Answer

Development

Answer

Trial

Answer

Preview

Question 3

A global organization uses Power Platform to manage IT support tickets. They have the following requirements: 1) Tickets must be routed to the appropriate team based on category. 2) The routing logic must be easy to update by non-developers. 3) All ticket data must be stored in a secure, auditable data source. Which THREE Power Platform components should they use?

Accepted Answer

Power Automate. Power Automate is correct because it provides the workflow automation needed to route tickets to the appropriate team based on category. Its low-code interface allows non-developers to easily update routing logic using triggers, conditions, and actions without writing code.

Answer

Copilot Studio

Answer

Power Apps

Question 4

You have a canvas app that uses a Microsoft Dataverse table. Users need to see only their own records. What is the most efficient method to implement this security?

Accepted Answer

Use the Filter function with User().Email or User().FullName.. The most efficient method is to use the Filter function with User().Email or User().FullName to filter records based on the current user. This approach leverages the app's built-in context without requiring additional security configuration. Option A is incorrect because removing datasource permissions undermines data security and is not a best practice. Option B is incorrect because while security roles can restrict access, they are more complex to set up and may not be the most efficient for simply filtering by user identity. Option D is incorrect because storing user ID in a global variable is less efficient and can be less secure compared to using the User() function directly in the filter.

Answer

Remove the datasource permissions and let the app handle all security.

Answer

Set up Dataverse security roles and assign them to users.

Answer

Store the user ID in a global variable and use it in queries.

Question 5

A small business wants to create a chatbot to answer common customer questions about store hours and return policies. Which Power Platform tool should they use?

Accepted Answer

Copilot Studio. Copilot Studio (formerly Power Virtual Agents) is the correct tool because it is specifically designed to create conversational AI chatbots without writing code. It allows the business to build a bot that answers common questions about store hours and return policies by defining topics and using natural language processing to interact with users.

Answer

Power BI

Answer

Power Automate

Answer

Power Apps

Question 6

A healthcare organization uses Power Apps to manage patient intake forms. The app is built on Dataverse and includes a field for medical record number (MRN) that must be unique. The app currently uses a text input, but duplicate MRNs have been entered. What is the best way to enforce uniqueness at the data layer?

Accepted Answer

Create a Dataverse alternate key on the MRN field. A Dataverse alternate key enforces uniqueness at the database level, preventing duplicate MRN values from being saved regardless of how data enters the system. This is the only option that operates at the data layer, ensuring integrity even if the app, a flow, or an external integration submits a record. Alternate keys are indexed and validated by Dataverse before commit, making them the proper solution for unique field constraints.

Answer

Use a Power Automate flow to check for duplicates after submission

Answer

Configure a business rule on the MRN field

Answer

Add a validation rule in the app to check for duplicates before submitting

Question 7

A Power Platform administrator needs to restrict data loss prevention (DLP) policies to prevent sensitive data from being shared with non-approved connectors. Which scope should the administrator apply?

Accepted Answer

Environment-level. Environment-level DLP policies allow administrators to apply data loss prevention rules to specific environments, ensuring that sensitive data is not shared with non-approved connectors within that environment. This granular control is necessary when different environments have different compliance requirements, such as separating development from production data flows.

Answer

Group-level

Answer

Tenant-level

Answer

User-level

Question 8

A company uses Microsoft Copilot Studio to create a custom copilot. The copilot needs to access customer data stored in a Dataverse table that contains sensitive information. The compliance team requires that data accessed by the copilot must be audited. What should the admin configure?

Accepted Answer

Enable auditing in Microsoft Purview and log copilot interactions.. Microsoft Purview auditing captures detailed logs of user and admin activities, including interactions with custom copilots built in Copilot Studio. By enabling auditing in Purview and logging copilot interactions, the admin can meet the compliance requirement to audit all data accessed by the copilot, ensuring a traceable record of sensitive customer data access.

Answer

Deploy Microsoft Sentinel to monitor copilot behavior.

Answer

Configure a DLP policy to block non-compliant data access.

Answer

Use Copilot Studio analytics to track usage.

Question 9

A company wants to enforce data loss prevention (DLP) policies for Power Automate flows. Which TWO actions can the administrator perform?

Accepted Answer

Block specific connectors from being used in flows. Administrators can block specific connectors from being used in Power Automate flows as part of a DLP policy, preventing data from being shared with unauthorized services. Option C is correct because DLP policies can be scoped to a specific environment, allowing granular control over connector usage within that environment. This enables the administrator to enforce data protection rules tailored to different business contexts.

Answer

Allow users to bypass DLP policies with administrator approval

Answer

Assign DLP policies to specific users

Answer

Inherit the tenant-level DLP policy for all environments

Question 10

A sales team uses a Canvas app to track leads. Users report that the app loads slowly when accessing on mobile devices. Which component should be optimized to improve performance?

Accepted Answer

Optimize data source connections and queries. Optimizing data source connections and queries directly reduces the amount of data transferred and the number of round trips between the Canvas app and its data source (e.g., Dataverse, SharePoint, SQL). On mobile devices, network latency and bandwidth are often constrained, so inefficient queries (e.g., loading all records instead of using filters) cause significant slowdowns. This is the primary performance lever for Canvas apps, as per Microsoft's guidance on app optimization.

Answer

Update the app version number

Answer

Increase the app icon size

Answer

Change the app's background color

Question 11

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?

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 12

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 13

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 14

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 15

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 16

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 17

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 18

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 19

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 20

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.