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

Question 1

Which TWO Power Apps features allow you to integrate AI capabilities into your app? (Choose two.)

Accepted Answer

Copilot integration. Options D and E are correct because AI Builder allows you to add AI models directly to Power Apps, and Copilot integration enables embedding AI-powered copilots. Option A (Power Virtual Agents) is a standalone product for chatbots, not a feature within Power Apps. Option B (Power Automate) is a separate automation product. Option C (Common Data Model) is a data schema, not an AI-capability feature.

Answer

Power Virtual Agents

Answer

Power Automate

Answer

Common Data Model

Question 2

Which THREE components are required to build a model-driven app in Power Apps? (Choose three.)

Accepted Answer

Dataverse tables. Dataverse tables are the core data storage and management layer in model-driven apps. They provide the structured schema, relationships, and business logic (such as calculated columns and rollups) that model-driven apps rely on for data operations. Without Dataverse tables, there is no data source to bind forms, views, or the sitemap to, making them a mandatory component.

Answer

Canvas controls

Answer

Power Automate flows

Question 3

Which TWO data sources can be used directly in a canvas app without a gateway? (Choose two.)

Accepted Answer

Microsoft Dataverse. Options C and D are correct because Microsoft Dataverse and SharePoint are cloud-based data sources that can be accessed directly without a gateway. Options A, B, and E are incorrect because SQL Server on-premises, Oracle on-premises, and SAP on-premises require an on-premises data gateway.

Answer

SQL Server on-premises

Answer

Oracle database on-premises

Answer

SAP on-premises

Question 4

Refer to the exhibit. You are reviewing the app definition XML for a model-driven app. Based on the exhibit, which tables are included in the app?

Accepted Answer

Account, contact, opportunity. The <component> elements list account, contact, and opportunity, which are the tables included in the app. Option A is incorrect because 'lead' is not listed among the components; Option B is incorrect because it omits 'opportunity'; Option D is incorrect because 'salesDashboard' is a dashboard component, not a table.

Answer

Account, contact, opportunity, lead

Answer

Account, contact

Answer

Account, contact, opportunity, salesDashboard

Question 5

Refer to the exhibit. You deploy this ARM template to create a Power Apps environment. What will be the SKU of the created environment?

Accepted Answer

Production. The property 'environmentSku' is set to 'Production'. Options B, C, and D are incorrect because they do not match the value in the template.

Answer

Sandbox

Answer

Developer

Answer

Trial

Question 6

A company wants to build a mobile app for field service technicians to view and update work orders. The app must work offline and sync when connectivity is available. Which Power Apps type should they use?

Accepted Answer

Canvas app. Canvas apps support offline capability with explicit data sync configuration, making them suitable for field service technicians who need to work without constant connectivity. Model-driven apps require online connectivity and are not designed for offline use. Option B (Canvas app) is correct. Option A is wrong because model-driven apps are primarily online. Option C is wrong because Power Automate is for automation, not app building. Option D is wrong because Power Pages is for external web portals.

Answer

Model-driven app

Answer

Power Automate

Answer

Power Pages

Question 7

A Power Apps canvas app uses a SharePoint list as its data source. Users report that the app is slow to load when the list contains over 10,000 items. What is the best approach to improve performance?

Accepted Answer

Use delegation-compatible functions and filters in the app.. Delegation allows queries to be processed on the data source side, reducing the amount of data transferred and improving performance. Option D is correct because delegation-compatible functions (e.g., Filter, LookUp) ensure only relevant data is retrieved. Option A is wrong because increasing the data row limit loads more data, worsening performance. Option B is wrong because switching to Dataverse might help but is not the best approach—it requires migration and may not always be feasible. Option C is wrong because reducing columns only marginally reduces data size, but without delegation, performance issues persist due to large row counts.

Answer

Increase the data row limit in the app settings.

Answer

Switch to a Microsoft Dataverse data source.

Answer

Reduce the number of columns in the SharePoint list.

Question 8

You are designing a Power Apps model-driven app for a sales team. The app must enforce that a discount field cannot exceed 50% of the total price. Where should you implement this validation?

Accepted Answer

Create a business rule on the table.. Business rules in model-driven apps provide real-time validation on forms. Option B is correct. Option A is wrong because the formula bar is for canvas apps. Option C is wrong because Power Automate is for backend automation, not instant form validation. Option D is wrong because JavaScript can be used but is not the recommended low-code approach.

Answer

In the canvas app formula bar.

Answer

Use a Power Automate flow triggered on record creation.

Answer

Write JavaScript in the form customisation.

Question 9

A company wants to build an app that allows employees to submit expense reports. The app must include approval workflow. Which Power Platform component should be used to define the approval process?

Accepted Answer

Power Automate. Power Automate is the tool for creating approval workflows. Option C (Power Automate) is correct. Option A (Power Virtual Agents) is wrong because it is for chatbots. Option B (Power Apps) is wrong because it is for building the app interface, not the workflow. Option D (Power BI) is wrong because it is for data visualization.

Answer

Power Virtual Agents

Answer

Power Apps

Answer

Power BI

Question 10

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 11

Your organisation has a Power Apps canvas app that uses a custom connector to call an external API. The API key is stored in a global variable. What is the security concern with this approach?

Accepted Answer

The API key can be exposed to end users in the app code.. Storing an API key in a global variable within a Power Apps canvas app is insecure because the app's code is accessible to end users. Anyone with access to the app can view the global variable's value through the App object or by inspecting the app's formulas, potentially exposing the API key. The correct answer is D. Option A is incorrect because custom connectors can be used with Power Apps. Option B is incorrect because global variables in Power Apps are writable, not read-only. Option C is incorrect because API keys typically do not expire quickly; the security concern is exposure, not expiration.

Answer

The custom connector cannot be used with Power Apps.

Answer

Global variables cannot store API keys because they are read-only.

Answer

The API key will expire quickly.

Question 12

A manager wants to create an app without writing any code. Which Power Apps type should they use?

Accepted Answer

Canvas app from a template. Canvas apps from templates allow users to create apps without writing any code by selecting a pre-built template and customizing it. Option A (Power BI) is a business analytics tool, not for app creation. Option B (Model-driven app) also allows no-code development but is more structured and less template-driven; the question specifically mentions 'from a template', making canvas app the best answer. Option C (Power Automate) is for automating workflows, not building apps.

Answer

Power BI

Answer

Model-driven app

Answer

Power Automate

Question 13

You have a model-driven app that includes a custom table. You need to add a field that calculates a value based on other fields (e.g., total price = quantity * unit price). Which type of field should you create?

Accepted Answer

Calculated field. Calculated fields perform calculations at the data source level, such as total price = quantity * unit price. Option A is correct. Option B is wrong because text fields store plain text, not calculations. Option C is wrong because choice fields provide a dropdown list of options. Option D is wrong because rollup fields aggregate data from related records, not compute values from fields in the same record.

Answer

Text field

Answer

Choice field

Answer

Rollup field

Question 14

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 15

Which of the following are valid data sources for Power Apps?

Accepted Answer

Microsoft SharePoint. SharePoint Online (B), SQL Server on-premises with a gateway (C), and Microsoft Dataverse (E) are all valid data sources for Power Apps. Option A is incorrect because a desktop Excel file is not directly supported; it must be stored in OneDrive or SharePoint. Option D is incorrect because JSON is a data format, not a data source.

Answer

Microsoft Excel (desktop file)

Answer

JSON file