Courseiva

CCNA Power Apps Capabilities Questions

75 of 238 questions · Page 1/4 · Power Apps Capabilities topic · Answers revealed

1
MCQmedium

A company has a model-driven app with a custom table 'Issue' that has a choice column 'Status' with values: New, In Progress, Resolved, Closed. The app uses a business rule to set 'Resolved By' (lookup to User) when status changes to Resolved. Users report that the 'Resolved By' field is not being populated. What is the most likely cause?

A.The 'Resolved By' lookup column is not added to the form.
B.The 'Resolved By' column is required and users don't fill it.
C.The business rule is scoped to the form but the status change happens via a quick create form.
D.The business rule is deactivated.
AnswerC

Business rules only apply to the form they are scoped to.

Why this answer

Business rules in model-driven apps can be scoped to either the entity (all forms) or a specific form. If the rule is scoped to a particular form (e.g., the main form) but the status change occurs via a quick create form, the rule will not trigger. This is the most likely cause because users report the field is not populated, indicating the rule is not firing in the context where the status is being changed.

Exam trap

The trap here is that candidates assume a business rule always applies to all forms of an entity, overlooking the scope setting that can restrict it to a specific form type, such as the main form versus a quick create form.

How to eliminate wrong answers

Option A is wrong because the 'Resolved By' lookup column not being on the form would not prevent the business rule from populating it; business rules can set field values regardless of whether the field is visible on the form. Option B is wrong because a required column would cause a validation error on save, not silently leave the field empty. Option D is wrong because if the business rule were deactivated, it would never fire in any context, but the question states users report the field is not being populated, implying it works in some scenarios (e.g., main form) but not others (quick create), which points to a scoping issue rather than deactivation.

2
MCQeasy

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?

A.Model-driven app
B.Canvas app
C.Power Automate
D.Power Pages
AnswerB

Canvas apps support offline capability with explicit data sync configuration, making them suitable for field service technicians.

Why this answer

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.

3
MCQeasy

A business analyst wants to quickly create a simple app to track team tasks without writing complex formulas. Which Power Apps option is most suitable?

A.Start from a blank canvas app
B.Create a model-driven app
C.Use Power Automate to create the app
D.Use the app from data wizard (e.g., from SharePoint)
AnswerD

Quickly generates a three-screen app from a data source.

Why this answer

The app from data wizard in Power Apps allows creating a simple app from a data source with minimal customization, ideal for quickly tracking team tasks without complex formulas. Option A is wrong because a blank canvas app requires more manual design and formulas. Option B is wrong because model-driven apps are more complex and suited for data-centric applications.

Option C is wrong because Power Automate is for workflow automation, not app creation.

4
MCQeasy

A company has a canvas app that uses Microsoft Dataverse. The app is shared with many users, and some users report that they cannot see any data. What is the most likely cause?

A.Users do not have appropriate security roles in Dataverse to read the data.
B.The app uses a premium connector that requires a license.
C.The app is not published to the environment.
D.The app is configured to run only on mobile devices.
AnswerA

Security roles determine read access to records.

Why this answer

Permissions in Dataverse (A) control data access. B, C, D are less likely because the app is shared and appears functional.

5
MCQeasy

A user wants to edit the fields displayed in a model-driven app form. Where should they go to customize the form?

A.From the app itself by selecting Edit
B.Power Apps maker portal
C.Power Automate
D.SharePoint list settings
AnswerB

The maker portal provides the form designer.

Why this answer

Model-driven app forms are customized using the form designer in the Power Apps maker portal (make.powerapps.com). Option A is incorrect because editing from within the app only changes data, not the form layout. Option C is incorrect because Power Automate is for automation, not form design.

Option D is incorrect because SharePoint list settings are unrelated to model-driven app form customization.

6
MCQhard

You are reviewing a FetchXML query used in a Power Apps component. The exhibit shows the query. What data will this query return?

A.All inactive accounts created in the last 30 days, including all attributes.
B.All accounts created in the last 30 days, only name, accountid, and createdon.
C.Active accounts created in the last 30 days, returning name, accountid, and createdon.
D.All accounts regardless of state, returning all attributes.
AnswerC

The filter conditions match: statecode=0 (Active) and createdon last 30 days, and only the specified attributes are returned.

Why this answer

The query selects accounts where statecode equals 0 (Active) and createdon is within the last 30 days. It returns name, accountid, and createdon. Option A is wrong because statecode 0 is Active, not Inactive.

Option B is wrong because it's not all accounts. Option D is wrong because it does not include all attributes.

7
MCQmedium

Refer to the exhibit. The Azure RBAC custom role definition shown is assigned to a user. What can this user do?

A.Manage all Power Apps in the subscription
B.Create new Power Apps in resource group RG1
C.Edit and delete Power Apps in resource group RG1
D.Read and install Power Apps in resource group RG1
AnswerD

The actions read and install are allowed.

Why this answer

The custom role includes 'Microsoft.PowerApps/apps/read' and 'Microsoft.PowerApps/apps/install' actions, which grant the user permission to read and install Power Apps in the assigned scope (resource group RG1). Therefore, option D is correct. Option A is incorrect because 'manage' implies full control (including write and delete), which is not granted.

Option B is incorrect because creating new apps requires write permission, which is not included. Option C is incorrect because editing and deleting require write and delete permissions, which are not included.

8
MCQhard

A Power Apps developer creates a canvas app that uses the 'Power Apps for Makers' license. The app is shared with 50 users who have 'Microsoft 365 E3' licenses. When users try to run the app, they get a licensing error. What is the most likely cause?

A.The app was published to a different environment
B.The app uses Microsoft Dataverse, which is not included in E3
C.The app uses AI Builder, which is not included in E3
D.The app is a premium app that requires a Power Apps per user license
AnswerD

Correct: Premium connectors or custom apps often need per user licenses.

Why this answer

Canvas apps require Power Apps per user or per app licenses for users without Power Apps for Makers. Microsoft 365 E3 includes only limited Power Apps rights for basic use, not premium custom apps.

9
MCQeasy

A user wants to create an app that allows employees to submit expense reports from their mobile devices. The app should capture photos of receipts and store them. Which type of app is most suitable?

A.Model-driven app
B.Power Apps portal
C.Power Automate flow
D.Canvas app
AnswerD

Canvas apps offer flexible design and mobile capabilities including camera input.

Why this answer

Anvas app (D). Canvas apps provide a flexible, mobile-friendly interface with drag-and-drop controls and built-in support for camera integration, making them ideal for capturing receipt photos. Model-driven apps are form-centric and less customizable for unique layouts.

Power Apps portals are designed for external users, not internal employees. Power Automate is a workflow automation tool, not an app type.

Exam trap

Candidates may falsely assume that model-driven apps are suitable because they support mobile devices, but they lack the custom camera capture functionality needed for receipt photos.

10
Multi-Selectmedium

Which TWO of the following are capabilities of Power Apps that help organizations build custom business applications without writing traditional code?

Select 2 answers
A.Integration with Common Data Service (Microsoft Dataverse)
B.Pre-built templates for common business scenarios
C.Natural language processing to create conversational bots
D.Automated workflows triggered by business events
E.Real-time data dashboards with drill-down analytics
AnswersA, B

Dataverse provides a secure data platform for Power Apps.

Why this answer

Power Apps integrates directly with Microsoft Dataverse (formerly Common Data Service), which provides a secure, scalable data platform for storing and managing business data. This integration allows users to build apps that leverage Dataverse’s built-in business logic, security roles, and relationships without writing custom code. Option B is correct because Power Apps offers a library of pre-built templates (e.g., for expense reports, asset management) that can be customized to fit specific business needs, enabling rapid application development with minimal technical effort.

Exam trap

The trap here is that candidates often confuse the distinct roles of Power Platform components—Power Apps for app building, Power Automate for workflows, Power BI for analytics, and Power Virtual Agents for bots—leading them to select options that belong to other services.

11
MCQhard

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.

A.Enable the 'Offline' setting in the app settings and add the Dataverse table to the offline profile.
B.Use Power Automate to cache data on the device.
C.Use the 'SaveData' and 'LoadData' functions to manually manage offline data.
D.Use SharePoint as the data source because it supports offline natively.
AnswerA

Power Apps canvas apps support offline profiles for Dataverse, enabling automatic sync.

Why this answer

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.

12
MCQmedium

You are building a canvas app that collects customer feedback. The app must send an email notification to the manager whenever a new feedback entry is submitted. What is the recommended approach?

A.Use the Office365 Outlook connector within Power Apps to send an email directly
B.Configure the app to call a custom API that sends an email
C.Create a Power Automate flow that triggers when a new row is added to the data source and sends an email
D.Store feedback in a SharePoint list and use 'Send email' action in SharePoint
AnswerC

Power Automate is the standard way to automate email notifications.

Why this answer

Power Automate can trigger on data changes in the data source and send emails. Option A is wrong because the Outlook connector in Power Apps requires user interaction. Option B is wrong because direct email from Power Apps is not secure and not recommended.

Option D is wrong because SharePoint lists don't automatically send emails.

13
MCQmedium

A business analyst wants to create an app that uses a SharePoint list as its data source. They need to include conditional formatting to highlight overdue tasks. Which type of app should they use?

A.Power Virtual Agents chatbot
B.Model-driven app
C.Canvas app
D.Power BI report
AnswerC

Canvas apps support formulas to change control properties based on data, enabling conditional formatting.

Why this answer

Canvas apps allow custom formulas for conditional formatting. Option A is wrong because Power Virtual Agents is for chatbots. Option B is wrong because model-driven apps use business rules but not flexible conditional formatting.

Option D is wrong because Power BI is for analytics, not app creation.

14
MCQeasy

A manager wants to create a Power App that shows a list of customer orders with the ability to drill into each order's details. Which approach is most efficient?

A.Use a data table connected directly to the data source
B.Use a gallery to list orders and navigate to a detail screen on selection
C.Use a single form with navigation buttons to move between orders
D.Export the data to Excel and use Power Apps to display the Excel file
AnswerB

Gallery allows efficient browsing and drill-down

Why this answer

Using a gallery to list orders and navigating to a detail screen on selection is the most efficient pattern for browsing and drilling into details. Option A is incorrect because a data table directly connected to the data source does not provide an easy way to drill into each order's details without additional configuration. Option C is incorrect because a single form with navigation buttons is less efficient for browsing a list and requires manual navigation.

Option D is incorrect because exporting to Excel defeats the purpose of a real-time app and is not efficient.

15
MCQhard

Your organization uses Power Apps and Power Automate to manage a vendor onboarding process. The app must send an email notification to the compliance team when a high-risk vendor is added. The compliance team resides in a different Microsoft Entra ID tenant. Which approach should you use?

A.Use the Outlook 365 connector with a shared mailbox
B.Use the Dataverse connector with a custom action
C.Use the Microsoft Teams connector to post a message
D.Use the HTTP connector with a custom API
AnswerD

HTTP connector can call an external email service.

Why this answer

The HTTP connector can send email to external recipients without sharing a mailbox. Option A is wrong because Dataverse connectors are tenant-scoped. Option B is wrong because Outlook connector requires shared mailbox or user credentials.

Option C is wrong because Teams connector is for internal users.

16
MCQeasy

A team is creating a model-driven app to manage customer service cases. They want to ensure that only users with a specific security role can delete cases. What should they configure?

A.Security roles
B.Business rules
C.SharePoint connector
D.App properties
AnswerA

Security roles grant or restrict delete permissions on tables.

Why this answer

Security roles in model-driven apps define permissions, including the ability to delete records. Option B is wrong because business rules define business logic and form behavior, not security permissions. Option C is wrong because the SharePoint connector is used for integration with SharePoint, not for security.

Option D is wrong because app properties control settings like appearance and ownership, not security permissions.

17
Multi-Selecteasy

Which TWO of the following are valid data sources for a Canvas app? (Choose TWO.)

Select 2 answers
A.SharePoint Online list
B.Power Automate flow
C.Microsoft Intune
D.Microsoft Entra ID
E.Microsoft Dataverse
AnswersA, E

Canvas apps can connect to SharePoint lists.

Why this answer

Options A and E are correct. Canvas apps can connect to SharePoint Online lists and Microsoft Dataverse, both of which are valid data sources. Option D (Microsoft Entra ID) is an identity service, not a data source.

Option B (Power Automate flow) is an automation service, not a data source. Option C (Microsoft Intune) is a device management service and not a data source.

18
MCQhard

Refer to the exhibit. The JSON shows the definition of a Power Apps canvas app. Based on the exhibit, which data source is the app connected to?

A.SharePoint list
B.Microsoft Dataverse
C.SQL Server
D.Excel Online
AnswerA

The 'type' field indicates SharePointList.

Why this answer

The JSON clearly shows the data source type as 'SharePointList'. Option A is correct. Option B is wrong because Dataverse is not listed.

Option C is wrong because SQL Server is not listed. Option D is wrong because Excel is not listed.

19
MCQmedium

A company wants to build a canvas app to allow field technicians to report equipment issues from their mobile devices. The app must work offline and sync data when connectivity is restored. Which feature should the developer use?

A.Power Automate
B.Power Platform admin center
C.Common Data Service
D.Offline
AnswerD

The Offline feature enables canvas apps to work offline and sync later.

Why this answer

Power Apps canvas apps support offline capability using the Offline feature, which caches data on the device and syncs when connectivity is restored. Option A (Power Automate) is a workflow automation tool, not an offline data sync feature. Option B (Power Platform admin center) is used for administration and governance, not for app-level offline capabilities.

Option C (Common Data Service, now Microsoft Dataverse) is a data platform that can enable offline sync when used with the Offline feature, but the question specifically asks for the feature the developer should use, which is the Offline feature itself. Therefore, D is the correct answer.

20
MCQeasy

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

A.Power BI
B.Model-driven app
C.Power Automate
D.Canvas app from a template
AnswerD

Canvas apps can be created from templates or data sources with no code required.

Why this answer

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.

21
MCQeasy

A company wants to create a mobile app for field technicians to log service calls. The app will connect to an existing SQL database. Which type of Power App should they build?

A.Power Automate flow
B.Model-driven app
C.Power Pages
D.Canvas app
AnswerD

Canvas apps provide full control over UI and can connect to SQL databases, perfect for mobile field apps.

Why this answer

Canvas apps allow custom layout and connectivity to many data sources like SQL, ideal for mobile scenarios. Option A is wrong because Power Automate is for automation, not app building. Option B is wrong because model-driven apps are form-centric and designed for complex business processes.

Option C is wrong because Power Pages is for external-facing websites.

22
MCQmedium

Refer to the exhibit. A Power Apps canvas app uses the Filter function as shown. What does this expression do?

A.Returns the first record from array1 with Status 'Active'
B.Sorts array1 by Status in ascending order
C.Returns all records from array1 where Status is 'Active'
D.Searches array1 for the text 'Active' in any column
AnswerC

Filter returns matching records.

Why this answer

The Filter function in Power Apps returns a table of records that meet the specified condition. In this expression, Filter(array1, Status = "Active") evaluates each record in array1 and includes only those where the Status column equals 'Active'. This is correct because Filter always returns all matching records, not just the first one.

Exam trap

The trap here is that candidates confuse Filter with First or Search, mistakenly thinking Filter returns a single record or performs a text search, when in fact it returns all records matching an exact column condition.

How to eliminate wrong answers

Option A is wrong because Filter returns all matching records, not just the first; the First function would be needed to return a single record. Option B is wrong because Filter does not sort data; the Sort function is used for ordering records. Option D is wrong because Filter performs an exact equality comparison on a specific column, not a full-text search across all columns; the Search function is used for that purpose.

23
Multi-Selecteasy

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?

Select 2 answers
A.Build a custom connector to the SQL database for enhanced security.
B.Create a SQL stored procedure to filter and aggregate data before sending to the app.
C.Use Collect() to load all data into a collection on app start for offline access.
D.Integrate a Power BI tile to display filtered charts and graphs.
E.Use the Office365Users connector to retrieve sales data from Excel Online.
AnswersB, D

Optimizes performance and reduces data transfer.

Why this answer

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

24
MCQhard

An organization has a model-driven app that uses a custom connector to an on-premises SQL Server database via an on-premises data gateway. Recently, users reported that the app is slow when loading data from the SQL Server. The network team confirms that the gateway server has sufficient resources. Which factor is most likely causing the performance degradation?

A.The model-driven app uses a canvas app component that loads excessive data.
B.The custom connector uses OAuth authentication instead of basic authentication.
C.The Power Apps license assigned to users is per app, not per user.
D.The on-premises data gateway is configured with a single data source and is not scaled for concurrent requests.
AnswerD

A single gateway can become a bottleneck under load; adding more gateways or using a cluster improves performance.

Why this answer

The on-premises data gateway, if configured with a single data source and not scaled for concurrent requests, can become a bottleneck when multiple users or queries access the SQL Server simultaneously, leading to slow performance. Option A is incorrect because the presence of a canvas app component doesn't inherently cause excessive data loading; data loading depends on how the app is built. Option B is incorrect because authentication method (OAuth vs basic) affects security, not performance.

Option C is incorrect because the Power Apps license type (per app vs per user) affects licensing cost and access, not the performance of data retrieval through the gateway.

25
Multi-Selectmedium

Which TWO are benefits of using model-driven apps over canvas apps for enterprise data management?

Select 2 answers
A.Responsive design that automatically adapts to screen size
B.Ability to work offline on mobile devices
C.Support for custom connectors to external systems
D.Easier to create complex formulas and logic
E.Built-in role-based security and compliance
AnswersA, E

Correct. Model-driven apps automatically adapt to screen size, providing a consistent UI across devices without manual layout work.

Why this answer

Model-driven apps provide built-in role-based security and responsive design that adapts to screen size, making them ideal for enterprise data management. Option A is correct because model-driven apps automatically adapt to different devices without extra effort. Option E is correct because they inherit Dataverse role-based security.

Option B is incorrect because offline capability is more commonly associated with canvas apps. Option C is incorrect because custom connectors are available in both app types. Option D is incorrect because canvas apps are better suited for complex formulas with Power Fx.

26
Multi-Selectmedium

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

Select 3 answers
A.Microsoft Excel (desktop file)
B.Microsoft SharePoint
C.SQL Server (on-premises)
D.JSON file
E.Microsoft Dataverse
AnswersB, C, E

SharePoint lists and libraries are supported data sources.

Why this answer

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.

27
MCQhard

Your model-driven app uses a custom entity 'Project' with a 1:N relationship to 'Task'. You need to add a subgrid on the Project form that shows related tasks, but only tasks assigned to the current user. How should you achieve this?

A.Create a workflow that updates a field on the Project form to filter the subgrid
B.Add a business rule on the Project form to filter the subgrid
C.Create a system view on the Task entity that filters by 'Owner equals Current User' and select it in the subgrid properties
D.Configure the subgrid to use the default view and assign security roles to filter tasks
AnswerC

System views can use dynamic filters like current user.

Why this answer

You can create a system view on the Task entity that filters by 'Owner equals Current User' and then select that view in the subgrid properties. Option A is wrong because workflows cannot filter subgrids; they can only automate processes. Option B is wrong because business rules control form behavior (like visibility or field values) but cannot filter subgrid data.

Option D is wrong because using the default view would show all tasks (or those allowed by security roles), not filtered by current user; security roles control access rights, not subgrid filtering criteria.

28
Drag & Dropmedium

Drag and drop the steps to deploy a solution from a development environment to a production environment in Power Platform in the correct order.

Drag steps to the numbered slots on the right, or tap a step then tap a slot.

Steps
Order
1Step 1
2Step 2
3Step 3
4Step 4

Why this order

Solutions are created, components added, exported, imported, and then published.

29
MCQeasy

A user reports that a Power App button does nothing when clicked. The button's OnSelect property contains: Navigate(Screen2). What is the most likely cause?

A.The formula is missing parentheses
B.The user lacks permission to navigate to Screen2
C.The app is not published
D.Screen2 does not exist in the app
AnswerD

Navigate to a non-existent screen causes failure

Why this answer

If Screen2 does not exist, the Navigate function fails silently, causing the button to appear to do nothing. Option A is incorrect because the formula syntax is valid and parentheses are properly used. Option B is incorrect because navigation permissions are not enforced within the same app; any user can navigate between screens.

Option C is incorrect because the app does not need to be published for the button to work in the editor or when running the app.

Exam trap

Candidates may assume a missing formula error or permission issue, but the silent failure of Navigate to a nonexistent screen is a common pitfall.

30
MCQmedium

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?

A.Canvas app
B.Power Virtual Agents bot
C.Model-driven app
D.Power Apps portal
AnswerD

Portals provide external access to Dataverse data via web.

Why this answer

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.

31
MCQmedium

A company uses Microsoft Power Apps to build a leave request application. The app uses SharePoint as the data source. Users report that when they submit a leave request, the app sometimes fails to save the data and shows a generic error. Which should you investigate first?

A.Clear the browser cache and cookies.
B.Verify the connection to the SharePoint data source.
C.Check if the app uses delegation for large lists.
D.Review the app formulas for syntax errors.
AnswerB

Data source connection issues are a common cause of generic save errors.

Why this answer

Generic errors when saving data in Power Apps often indicate a problem with the data source connection, such as network interruption or permission changes. Option A is incorrect because clearing browser cache and cookies typically affects app loading performance, not data submission. Option C is incorrect because delegation issues in Power Apps affect data retrieval (e.g., filtering large lists), not the ability to save new records.

Option D is incorrect because formula syntax errors usually produce specific error messages, not a generic save failure.

32
Multi-Selecthard

Which THREE are valid data sources for a canvas app? (Choose three.)

Select 3 answers
A.Azure DevOps work items
B.SharePoint list
C.SQL Server
D.Excel workbook in OneDrive
E.Power BI dataset
AnswersB, C, D

SharePoint lists are a common data source.

Why this answer

SharePoint lists are supported. Option C is correct because SQL Server is supported. Option D is correct because Excel files stored in OneDrive are supported.

Option A is wrong because Azure DevOps is not a direct canvas app data source (use connectors). Option E is wrong because Power BI datasets are not data sources; you can embed reports but not use as source.

33
MCQmedium

Refer to the exhibit. The JSON shows the definition of a Power App. What can be concluded?

A.The app is deployed to production
B.The app connects to SharePoint Online
C.The app uses Dataverse as its data source
D.The app is a model-driven app
AnswerB

The connectionId indicates SharePoint Online.

Why this answer

The JSON includes a connection reference to SharePoint Online, indicating that the app uses SharePoint as its data source. Option A is incorrect because the JSON does not provide any deployment status information. Option C is incorrect because the data source is SharePoint, not Dataverse.

Option D is incorrect because the 'type' field in the JSON indicates it is a CanvasApp, not a model-driven app.

34
MCQhard

A team is designing a model-driven app for customer service. They need to ensure that only agents in the 'Premium Support' role can see a custom field named 'SLA Level'. What is the best way to implement this security requirement?

A.Remove the field from the form and create a separate form for Premium Support agents
B.Use the 'Visible' property of the field in a Canvas app embedded in the model-driven app
C.Configure field-level security in Microsoft Dataverse
D.Create a business rule that sets the field as read-only for non-Premium roles
AnswerC

Field-level security allows or denies read/write on a field per security role.

Why this answer

Field-level security in Microsoft Dataverse allows administrators to restrict access to a specific field based on security roles. This ensures only agents in the 'Premium Support' role can see the 'SLA Level' field. Option A is incorrect because removing the field from the form would affect all users.

Option B is not a standard security feature; Canvas apps are not designed for field-level permissions in model-driven apps. Option D is incorrect because a business rule can only make a field read-only, but it cannot hide the field from specific roles.

35
MCQmedium

A company uses a model-driven app to manage customer service cases. The team wants to automatically assign cases to the appropriate queue based on the case category. What feature should they use?

A.Workflow
B.SLA KPIs
C.Routing rule set
D.Business process flow
AnswerC

Routing rule sets assign records to queues automatically based on criteria.

Why this answer

Routing rule set, is correct because routing rule sets automatically assign records to queues based on defined conditions such as case category. This feature is specifically designed for automatic queue assignment in model-driven apps. Option A (Workflow) runs background processes but does not handle queue assignment directly.

Option B (SLA KPIs) tracks service level performance, not routing. Option D (Business process flow) guides users through a process but does not automatically assign cases to queues.

36
MCQeasy

Refer to the exhibit. The JSON shows permissions for a user in a Power Apps environment. What can be inferred?

A.The user is a maker who can create apps
B.The user has no access to any app
C.The user can only view apps
D.The user is an administrator of the environment
AnswerD

The Environment Admin role indicates administrative privileges.

Why this answer

The JSON shows the user has the Environment Admin role, which grants full administrative permissions over the environment. Option A is incorrect because the maker role is separate and not indicated. Option B is incorrect because having an admin role implies access.

Option C is incorrect because an admin can perform actions beyond viewing.

37
Multi-Selectmedium

Which TWO features are available in canvas apps but NOT in model-driven apps?

Select 2 answers
A.Integration with Microsoft Dataverse
B.Use of formulas like If, Switch, Filter
C.Ability to use AI Builder models
D.Access to device capabilities like camera and GPS
E.Embedding a canvas app in a model-driven app
AnswersB, D

Canvas apps use Excel-like formulas; model-driven apps use business rules.

Why this answer

Canvas apps provide the ability to write formulas (like If, Switch, Filter) directly in the app, which is not available in model-driven apps. Model-driven apps use business rules and workflows instead of formulas. Additionally, canvas apps can directly access device capabilities (camera, GPS), whereas model-driven apps do not have direct access to native device features.

Option A (Integration with Dataverse) is available in both canvas and model-driven apps, so it is not exclusive. Option C (Ability to use AI Builder models) is also available in both. Option E (Embedding a canvas app in a model-driven app) is a feature of model-driven apps, not canvas apps.

38
MCQmedium

Refer to the exhibit. An ARM template is used to deploy a connection. What is the purpose of this resource?

A.Create a new Power App
B.Create a Dataverse environment
C.Create a SharePoint Online API connection for Power Apps
D.Deploy a SharePoint list
AnswerC

The template creates a connection resource for Power Apps.

Why this answer

The resource type 'Microsoft.Web/connections' creates an API connection. In this context, it is used to create a SharePoint Online API connection for Power Apps. Option C is correct.

Option A is incorrect because it does not create a Power App; it creates a connection. Option B is incorrect because it does not create a Dataverse environment. Option D is incorrect because it does not deploy a SharePoint list; it creates an API connection.

39
MCQmedium

An organization wants to build a Power Apps solution that uses AI to extract information from invoices automatically. Which feature should they use?

A.Power BI
B.AI Builder
C.Power Automate
D.Common Data Service
AnswerB

AI Builder provides prebuilt invoice processing models.

Why this answer

AI Builder is the correct feature because it provides prebuilt and custom AI models that can be trained to extract structured data from documents like invoices. It integrates directly into Power Apps, allowing users to add AI-powered invoice processing without writing code or managing machine learning infrastructure.

Exam trap

The trap here is that candidates confuse Power Automate's ability to orchestrate actions with AI Builder's actual AI processing capability, leading them to select Power Automate because they think 'automation' implies AI extraction.

How to eliminate wrong answers

Option A is wrong because Power BI is a business analytics and visualization tool, not a data extraction or AI model service; it cannot extract information from invoices. Option C is wrong because Power Automate is a workflow automation platform that can trigger actions based on AI Builder results but does not itself perform AI-based extraction. Option D is wrong because Common Data Service (now Microsoft Dataverse) is a data storage and management platform, not an AI service; it can store extracted data but cannot perform the extraction.

40
MCQmedium

You are designing a canvas app for field service technicians. The app must capture photos of equipment and store them with the service record. Which control and data source combination is most suitable?

A.Camera control with Microsoft Dataverse
B.Add media control with Excel Online
C.Attachments control with SharePoint list
D.Image control with SharePoint list
AnswerA

Camera captures photos; Dataverse stores files.

Why this answer

The Camera control captures photos directly within the canvas app, and Microsoft Dataverse can store these images using file or image columns, providing a robust data source for field service records. Option B is incorrect because the Add media control only supports media capture in Power Apps Mobile and Excel Online is not capable of storing binary image data effectively. Option C is incorrect because the Attachments control is designed for SharePoint lists but does not capture photos in-app; it only manages file attachments.

Option D is incorrect because the Image control displays images but does not capture them, making it unsuitable for this requirement.

41
MCQhard

A power user is designing a canvas app for inventory management. The app has a gallery that displays products. The user wants to filter the gallery to show only products with stock less than 10. Which formula should the user use in the Items property of the gallery?

A.LookUp(Products, Stock < 10)
B.Filter(Products, Stock < 10)
C.Sort(Products, Stock)
D.Search(Products, "10", "Stock")
AnswerB

Filter function returns records that satisfy the condition.

Why this answer

The Filter function in Power Apps applies a condition to show only records where Stock < 10. Option A is wrong because LookUp returns a single record, not a filtered collection. Option C is wrong because Sort changes the order but does not filter.

Option D is wrong because Search is for text search, not numeric comparison.

42
MCQmedium

A model-driven app shows a custom form with fields from two related tables: Order and Customer. The form is set to display the Customer fields as a subgrid. Users want to see Customer details inline without navigating away. What should the app maker do?

A.Add a new form section for Customer fields
B.Create a custom page with a canvas control
C.Use a quick view form for the Customer table
D.Add a subgrid for the Customer table
AnswerC

Correct: Quick view forms display related fields inline.

Why this answer

Quick view forms allow displaying related entity fields inline. Subgrids show lists, not detail fields. Custom pages are for canvas experiences.

Form sections don't add inline detail from other tables.

43
MCQmedium

You are designing a Power Apps solution for a global sales team. The app must display data in the user's local time zone. The data is stored in Dataverse in UTC. What is the best practice for time zone handling?

A.Convert UTC to each time zone using Power Fx formulas
B.Store times in UTC and let Power Apps handle conversion automatically
C.Store local time in the database based on user's location
D.Use a Power Automate flow to convert time zones
AnswerB

Power Apps uses the user's device time zone.

Why this answer

The best practice is to store times in UTC and let Power Apps handle the conversion to the user's local time zone automatically based on their browser or device settings. This ensures consistency across global users and avoids errors from manual conversion or storing local times. Option A is error-prone due to complex formulas, option C causes confusion because the same record would show different times for different users, and option D adds unnecessary complexity.

44
MCQmedium

You are building a canvas app to track support tickets. The app will be used by team members who often work offline in remote locations. Which data source should you use to ensure offline data access without requiring custom development?

A.Excel Online (via OneDrive)
B.SharePoint list
C.Microsoft Dataverse
D.Azure SQL Database
AnswerC

Dataverse includes built-in offline sync capabilities for canvas apps.

Why this answer

Microsoft Dataverse provides built-in offline sync capability for canvas apps without requiring custom development. Option A (Excel Online via OneDrive) does not support offline access. Option B (SharePoint list) requires custom logic for offline synchronization.

Option D (Azure SQL Database) requires a VPN or gateway for offline access and does not offer automatic sync.

45
MCQmedium

Refer to the exhibit. A Power App uses the Patch function to create a new record in the Orders table. The code runs without error, but no record appears in the Orders table. What is the most likely issue?

A.The Patch function is missing the 'As' parameter
B.The table name 'Orders' is misspelled
C.The user does not have write permissions to the Orders table
D.The Patch function is being called from a non-delegable data source
AnswerC

Without write permission, Patch silently fails

Why this answer

If the user does not have write permissions to the Orders table, the Patch function may execute without throwing an error but the record will not be created. Options A and B would typically cause an error, not silent failure. Option D (non-delegable data source) does not prevent record creation.

Therefore, the most likely cause is insufficient permissions.

46
MCQhard

Refer to the exhibit. An ARM template deploys a Power App with a connection to Office 365 Outlook. What is the purpose of the 'dependsOn' element?

A.To deploy the resources to different regions
B.To ensure the connection is deployed before the app
C.To ensure the app is deployed before the connection
D.To reduce the cost of the deployment
AnswerB

The app depends on the connection, so connection must exist first.

Why this answer

The dependsOn element ensures that the connection resource is created before the app resource, because the app references the connection. Option B is correct. Option A is wrong because the order is connection then app.

Option C is wrong because dependsOn does not affect pricing. Option D is wrong because dependsOn is about resource creation order, not deployment scope.

47
MCQhard

A manufacturing company uses Power Apps to manage inventory. The app includes a main screen that displays a gallery of inventory items, a detail screen for editing item properties, and a form screen for adding new items. The app uses a SharePoint list as the data source. Recently, users reported that when they edit an item on the detail screen and save, the changes do not appear in the gallery until they manually refresh the app. Additionally, some users occasionally encounter a 'Delegation warning' when filtering the gallery by item name. The app is shared with 200 users, and performance is becoming an issue. You need to resolve these issues. Which action should you take?

A.Convert the model-driven app to a canvas app to gain more control over data refresh and delegation.
B.Modify the detail screen's Save button to use the Refresh() function on the gallery's data source after the form submission, and change the gallery's Items property to use a Filter query on an indexed SharePoint column to avoid delegation.
C.Increase the data row limit in Power Apps settings to 2000 to prevent delegation warnings.
D.Migrate the data source from SharePoint to Microsoft Dataverse to eliminate delegation warnings and improve performance.
AnswerB

Refresh() updates the gallery with the latest data, and using Filter on an indexed column allows delegation, removing the warning and improving performance.

Why this answer

The Refresh() function after form submission ensures the gallery's data source is updated immediately, eliminating the need for manual refresh. Changing the gallery's Items property to use a Filter query on an indexed SharePoint column avoids delegation warnings by ensuring the query can be processed server-side, as SharePoint supports delegation only for indexed columns and certain operators.

Exam trap

The trap here is that candidates may think delegation warnings are solved by increasing the data row limit (Option C) or by switching data sources (Option D), when in fact the root cause is the use of non-delegable queries on unindexed columns, which can be fixed by proper filtering and indexing.

How to eliminate wrong answers

Option A is wrong because the app is already a canvas app (described as having a gallery, detail screen, and form screen), and converting to a model-driven app would not resolve data refresh or delegation issues; model-driven apps have different data handling but still rely on the same underlying data source limitations. Option C is wrong because increasing the data row limit to 2000 does not prevent delegation warnings; delegation warnings occur when a query cannot be fully processed on the data source, and the row limit only affects how many records are retrieved locally, not the delegation itself. Option D is wrong because migrating to Dataverse is an over-engineered solution that may improve performance but is not necessary to fix the specific issues of manual refresh and delegation warnings; the simpler fix in Option B directly addresses both problems without requiring a data source migration.

48
MCQeasy

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

A.Power Automate portal
B.Power Pages
C.Canvas app with anonymous access
D.Model-driven app with anonymous access
AnswerB

Power Pages allows external anonymous access and can be used for support ticket submission.

Why this answer

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.

49
MCQmedium

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.

A.AI Builder's prebuilt invoice processing model.
B.Use the 'Scan' function in Power Apps.
C.Custom Vision service in Azure.
D.Power Automate with OCR actions.
AnswerA

AI Builder offers a ready-to-use invoice processing model that extracts fields from invoices.

Why this answer

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.

50
MCQhard

A model-driven app has a subgrid showing related opportunities. Users want to be able to edit opportunity fields directly in the subgrid without opening the record. Which feature should be enabled?

A.Enable the 'Chart' option on the subgrid properties.
B.Set the subgrid's 'Default view' to a custom view.
C.Change the subgrid type from 'Standard' to 'Editable'.
D.Set the subgrid's 'View Selector' to show multiple views.
AnswerC

Editable subgrid allows inline editing of fields.

Why this answer

Editable subgrid (C) allows inline editing. A is for charts. B is for custom views.

D is for read-only subgrids.

51
MCQeasy

A company wants to build a Power Apps app that uses a SQL Server database as its data source and requires complex business logic validation before saving data. Which type of app should they use?

A.Model-driven app
B.Canvas app
C.Power Automate
D.Portal
AnswerB

Canvas apps allow complex formulas and custom validation.

Why this answer

Canvas apps are the correct choice because they allow full control over the user interface and can incorporate complex business logic validation using Power Fx formulas before data is written to the SQL Server database. Unlike model-driven apps, which rely on predefined forms and server-side business rules, canvas apps enable custom validation logic directly in the app's formulas, such as checking multiple field conditions or calling custom connectors.

Exam trap

The trap here is that candidates often confuse model-driven apps with canvas apps, assuming model-driven apps can handle complex client-side validation, when in fact model-driven apps rely on server-side business rules and cannot execute custom Power Fx logic directly on the form.

How to eliminate wrong answers

Option A is wrong because model-driven apps are designed for rapid form generation from Dataverse or SQL Server but rely on server-side business rules and workflows, not custom client-side validation logic, making them less suitable for complex business logic validation before saving. Option C is wrong because Power Automate is an automation and workflow service, not an app type; it can be used to run validation after data is submitted but cannot provide real-time, interactive validation within a user-facing app. Option D is wrong because Power Apps portals are intended for external-facing websites with limited customization for complex business logic, and they primarily use Dataverse as a data source, not direct SQL Server integration with custom validation.

52
MCQmedium

You need to design a Power App that allows users to view and update customer records from a SQL Server database. The app must enforce row-level security based on the user's region. What should you use?

A.Power Apps security groups
B.Dataverse security roles
C.Environment security
D.SQL Server row-level security with the USER_NAME() function
AnswerD

SQL Server RLS filters rows based on the user executing the query.

Why this answer

SQL Server row-level security with the USER_NAME() function. This allows you to filter rows in SQL Server based on the user's identity, which can be passed from Power Apps using the User() function. Option A is incorrect because Power Apps security groups control access to the app itself, not data row-level filtering.

Option B is incorrect because Dataverse security roles apply to Dataverse tables, not SQL Server. Option C is incorrect because environment security restricts access to the environment, not specific rows in a SQL Server database.

53
MCQmedium

A Power Apps app uses a Dataverse table with a choice column 'Priority' (Low, Medium, High, Critical). The app must display the priority as a color-coded badge in a gallery. Which method is most efficient?

A.Add a second table with colors and use LookUp in the gallery.
B.Create a Power Automate flow to update a color field on the record.
C.Use the Switch function in the gallery's Fill property to map each choice value to a color.
D.Use an If function with multiple conditions to set the Fill property.
AnswerC

Switch function is efficient and built-in for conditional formatting.

Why this answer

The Switch function in the gallery's Fill property directly maps each priority choice value to a color without requiring additional tables, flows, or nested conditions. Option A adds an unnecessary lookup table, option B involves an external flow which is overkill for simple color mapping, and option D uses multiple If conditions which is less efficient and harder to maintain than a Switch function.

54
MCQeasy

A company wants to create a mobile app for field service technicians to log work orders. The app must use a SharePoint list as the data source and include offline capability. Which type of Power App should they build?

A.Power Pages site
B.Power Automate flow
C.Model-driven app
D.Canvas app
AnswerD

Canvas apps support offline and custom UI, ideal for field service scenarios.

Why this answer

A canvas app allows custom layout and offline support via Power Apps mobile. Model-driven apps (C) are primarily for data management and require online connectivity. Power Pages (A) is for external websites.

Power Automate (B) is for workflow automation.

55
MCQeasy

A user wants to add a chart to a model-driven app to visualize sales data. Which component should they use?

A.Chart component from the Dataverse table
B.Chart control from the Power Apps canvas
C.Excel chart imported into the app
D.Power BI tile embedded in the app
AnswerA

Model-driven apps can display charts based on table views.

Why this answer

Model-driven apps include built-in chart visualization for Dataverse data. Option B is for Canvas apps. Option C is for custom visuals in Power BI.

Option D is not a standard chart component.

56
Multi-Selectmedium

Which TWO of the following are valid ways to share a canvas app with other users? (Choose TWO.)

Select 2 answers
A.Share the app with a distribution group.
B.Share the app with everyone in the organization by selecting 'Everyone' in the share settings.
C.Share the app with a security group.
D.Share the app with a Microsoft 365 group.
E.Share the app with individual users by entering their email addresses.
AnswersC, E

Canvas apps can be shared with security groups.

Why this answer

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.

57
MCQhard

A user reports that a canvas app displays an error: 'The data source is not found.' The app connects to a SQL Server database via an on-premises data gateway. The gateway status shows 'Running' and the connection is configured. What is the most likely cause?

A.A required environment variable is missing
B.A SharePoint list used in the app was deleted
C.The SQL table name in the app formula is incorrect
D.The on-premises data gateway is offline
AnswerC

A misspelled table name causes 'data source not found'.

Why this answer

The error 'The data source is not found' typically indicates that the app formula references a table name that does not exist or is misspelled in the SQL database. Option A is incorrect because missing environment variables cause different errors. Option B is incorrect because a deleted SharePoint list would affect SharePoint-based data sources, not SQL Server.

Option D is incorrect because the gateway status shows 'Running' and the connection is configured, so the gateway is not offline.

58
Multi-Selecthard

Which TWO are benefits of using model-driven apps over canvas apps? (Choose two.)

Select 2 answers
A.Easier to create complex formulas
B.No Microsoft Entra ID licensing required
C.Built-in business process flows
D.Responsive design automatically adapts to screen size
E.Unlimited custom layout control
AnswersC, D

Model-driven apps include business process flows.

Why this answer

Options C and D are correct. Model-driven apps include built-in business process flows (C) that guide users through processes, and they are responsive by default, automatically adapting to different screen sizes (D). Option A is incorrect because canvas apps, not model-driven apps, are designed for complex formulas and custom layouts.

Option B is incorrect because both types require Microsoft Entra ID licensing. Option E is incorrect because model-driven apps have limited layout customization; canvas apps offer full control.

59
MCQmedium

A company has a Power Apps model-driven app for sales. Sales reps need to see their assigned leads only. Which security feature should be configured?

A.Configure business unit security to isolate each rep's data
B.Use field-level security to set permissions on the 'Assigned To' field
C.Assign security roles that filter leads by owner
D.Share the app with each rep individually
AnswerC

Correct. Security roles with appropriate access levels (e.g., 'User' on the Lead entity) ensure users see only records they own, which matches the requirement.

Why this answer

Security roles with 'User' access level on the Lead entity filter records so that users see only records they own. This is the appropriate method to restrict leads by assigned owner in a model-driven app. Option B is incorrect because field-level security controls read/write permissions on a specific field (like 'Assigned To'), not which records are visible.

It does not filter the list of records. Option A is incorrect because business unit security isolates data at the business unit level, not per user. Option D is incorrect because sharing the app grants access to the app but does not filter the underlying data.

60
Multi-Selecthard

Which THREE components are part of a model-driven app? (Choose three.)

Select 3 answers
A.Gallery
B.Cloud flow
C.Form
D.Dashboard
E.Business process flow
AnswersC, D, E

Forms are the primary data entry interface.

Why this answer

In a model-driven app, Forms (C) provide the data entry interface, Dashboards (D) offer visual overviews of key metrics, and Business process flows (E) guide users through a defined process. Galleries (A) are components of canvas apps, not model-driven apps. Cloud flows (B) are automation tools in Power Automate and not part of the app UI.

61
MCQhard

A model-driven app uses a business process flow to guide users through a sales process. The flow has multiple stages, and users complain that they can move to the next stage without completing required fields. What should the app maker do to enforce data entry?

A.Set the fields as business required in the entity
B.Set the fields as required in the business process flow stage
C.Add a validation rule on the entity fields
D.Make the fields read-only in the business process flow stage
AnswerB

Required fields in the stage must be filled before moving to the next stage.

Why this answer

Setting fields as required in the business process flow stage ensures they must be filled before progressing to the next stage. Option A is incorrect because setting fields as business required in the entity applies globally, not just within the flow, and would affect all forms and views. Option C is incorrect because validation rules apply to the field's data integrity, not to flow stage transitions.

Option D is incorrect because making fields read-only would prevent data entry entirely, not enforce required completion.

62
Multi-Selecthard

Which THREE of the following are capabilities of Power Apps?

Select 3 answers
A.Create complex workflow automations
B.Perform real-time streaming analytics
C.Use AI Builder to add artificial intelligence
D.Connect to Microsoft 365 data (e.g., SharePoint, Outlook)
E.Run on mobile devices (iOS, Android, Windows)
AnswersC, D, E

Correct. Power Apps integrates with AI Builder to add AI capabilities such as object detection, form processing, and text recognition.

Why this answer

Power Apps allows users to connect to Microsoft 365 data (e.g., SharePoint, Outlook) for building business applications. It also integrates with AI Builder to add artificial intelligence capabilities. Additionally, Power Apps can run on mobile devices (iOS, Android, Windows) through the Power Apps mobile app.

Option A is incorrect because complex workflow automations are a capability of Power Automate, not Power Apps. Option B is incorrect because real-time streaming analytics is not a core capability of Power Apps; it is more aligned with Azure Stream Analytics or Power BI.

63
MCQhard

An organization has a canvas app that uses a SharePoint list as its data source. Users report that the app loads slowly and sometimes times out. The developer needs to improve performance. Which approach should the developer take?

A.Increase the timeout setting in the app settings
B.Migrate the data source to SQL Server to improve performance
C.Split the app into multiple screens to reduce load per screen
D.Use delegable queries to filter data at the source
AnswerD

Delegation pushes filters to SharePoint, reducing data transfer.

Why this answer

Using delegable queries allows the data source to filter data before sending it to the app, reducing the amount of data transferred and improving performance. Option A is wrong because increasing timeouts does not address the root cause of slow loading. Option B is wrong because migrating to SQL Server is an unnecessary and costly change; the issue can be resolved within the current data source by using delegation.

Option C is wrong because splitting into multiple screens does not reduce the data load per screen if queries are not delegable.

64
Multi-Selectmedium

Which TWO are valid ways to share a canvas app with other users in your organization?

Select 2 answers
A.Publish the app to a SharePoint list
B.Share directly from the Power Apps maker portal
C.Embed the app in Microsoft Teams
D.Provide a direct link to the .msapp file
E.Send the app file as an email attachment
AnswersB, C

You can share by entering user emails or security groups in the portal.

Why this answer

Correct: B and C. The two valid ways to share a canvas app with other users in your organization are: sharing directly from the Power Apps maker portal (B) and embedding the app in Microsoft Teams (C). Sharing directly from the maker portal is the standard method, and embedding in Teams allows users to access the app within the Teams interface.

Option A is incorrect because publishing to a SharePoint list is not a sharing method for canvas apps; that's for SharePoint lists themselves. Option D is incorrect because providing a direct link to the .msapp file is not supported; users need a proper share link or must be added to the app's permissions. Option E is incorrect because sending the app file as an email attachment is not possible; the app file is not a standalone executable.

65
Multi-Selectmedium

Which TWO Power Apps features allow sharing apps with users who have a Power Apps per app plan?

Select 2 answers
A.Adding users as co-owners of the app
B.Sharing the app with a security group
C.Assigning per app plan licenses to users
D.Granting Dataverse access to users
E.Sharing the app with everyone in the organization
AnswersB, C

Security groups can be assigned per app plan licenses.

Why this answer

Sharing an app with a security group allows you to assign per app plan licenses to all members of that group. Option C is correct because you must assign per app plan licenses to users explicitly to grant access. Option A is incorrect because adding users as co-owners does not provide them with a license; they still need a per app plan or per user plan.

Option D is incorrect because granting Dataverse access does not include a Power Apps license. Option E is incorrect because sharing with everyone in the organization requires a per user plan or different licensing agreement.

66
MCQeasy

A user needs to create an app that shows data from a SQL Server database and allows users to edit records. The user has no coding experience. Which Power Apps approach should they use?

A.Create a model-driven app
B.Use the Power Apps template for SQL Server
C.Start from blank canvas and use SQL Server connector
D.Use Power Automate to create a user interface
AnswerB

Provides a pre-built app for SQL Server data.

Why this answer

The Power Apps template for SQL Server provides a ready-made app that can be connected to a database. Option A is wrong because model-driven apps require Dataverse. Option C is wrong because starting from blank is more complex.

Option D is wrong because Power Automate is for automation.

67
MCQmedium

A company uses Power Apps to build a canvas app for field technicians to report equipment issues. The app includes a GPS location control and requires offline capability. During a pilot, technicians report that the app fails to load data when they are in remote areas with no internet. Which design change should the app maker implement to address this issue?

A.Adjust the GPS control to use high accuracy mode.
B.Add a Power Automate flow to sync data periodically.
C.Enable offline use and configure the app to cache data locally.
D.Convert the canvas app to a model-driven app.
AnswerC

Offline capability allows cached data access without internet.

Why this answer

Enabling offline use in canvas apps allows users to load data while connected and work with cached data when disconnected. Option A is wrong because adjusting GPS settings does not affect offline data availability. Option B is wrong because Power Automate flows require connectivity and do not enable offline data storage.

Option D is wrong because converting to a model-driven app does not inherently solve offline requirements unless specifically configured.

68
Multi-Selecteasy

Which TWO data sources can be used with a canvas app? (Choose two.)

Select 2 answers
A.Microsoft Power Platform
B.Microsoft Teams
C.SharePoint list
D.Power Automate
E.Microsoft Dataverse
AnswersC, E

Canvas apps can connect to SharePoint lists.

Why this answer

SharePoint lists and Microsoft Dataverse are both valid data sources for canvas apps. SharePoint lists allow you to read and write data from SharePoint. Microsoft Dataverse is a scalable data platform that stores business data.

The other options are not data sources: Microsoft Power Platform is the product family, Microsoft Teams is a collaboration app, and Power Automate is an automation service.

69
Multi-Selecthard

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

Select 3 answers
A.Automatic form generation from Dataverse tables
B.Responsive design that adapts to different screen sizes
C.Drag-and-drop layout customization
D.Built-in business process flows
E.Full control over pixel-perfect design
AnswersA, B, D

Forms are generated based on the table definition.

Why this answer

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.

70
Multi-Selecteasy

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

Select 3 answers
A.View
B.Table (entity)
C.Microsoft Dataverse database
D.Canvas app component
E.Power Automate flow
AnswersA, B, C

Views define how data is displayed.

Why this answer

Options A, B, and C are correct because a model-driven app requires a Microsoft Dataverse database, tables (entities) to store data, and views to display data. Option D is incorrect because canvas apps are a different type of app, not a component of a model-driven app. Option E is incorrect because Power Automate flows are optional and not required components.

71
Multi-Selectmedium

Which TWO actions can be performed using Power Apps? (Choose two.)

Select 2 answers
A.Create a custom mobile app that connects to SharePoint
B.Create a dashboard with visualizations from multiple data sources
C.Build a chatbot to answer customer questions
D.Automate a workflow when a new email arrives
E.Embed a canvas app into Microsoft Teams
AnswersA, E

Power Apps can create canvas apps connecting to SharePoint.

Why this answer

Options A and E are correct. Power Apps allows you to create custom mobile apps that connect to various data sources, including SharePoint, and to embed canvas apps into Microsoft Teams. Option B is incorrect because creating dashboards with visualizations from multiple data sources is a capability of Power BI, not Power Apps.

Option C is incorrect because building a chatbot to answer customer questions is a capability of Power Virtual Agents, not Power Apps. Option D is incorrect because automating a workflow when a new email arrives is a capability of Power Automate, not Power Apps.

72
MCQhard

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?

A.The user does not have permission to the SharePoint list.
B.The column name or data type in the Patch function does not match the SharePoint list.
C.The Patch function is being called with incorrect arguments.
D.The app is not using delegation.
AnswerB

Mismatched column names or types cause the update to fail without error in some cases.

Why this answer

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.

Exam trap

The trap here is that candidates often assume a silent failure must be a permission or delegation issue, but the PL-900 exam specifically tests the nuance that column name/type mismatches in Patch cause silent failures, not errors.

How to eliminate wrong answers

Option A is wrong because a permission issue would typically result in a clear error message (e.g., 'Access denied') when the app tries to write to the SharePoint list, not a silent failure. Option C is wrong because incorrect arguments (e.g., wrong number of parameters or invalid record structure) would cause a compilation error or a runtime error with a descriptive message, not a silent failure. Option D is wrong because delegation is a concept for data source filtering and retrieval in galleries or data tables, not for the Patch function, which operates on individual records and does not rely on delegation.

73
Multi-Selecthard

Which THREE are capabilities of model-driven apps?

Select 3 answers
A.Business process flows to guide users through steps
B.Custom CSS to style the app
C.Pixel-perfect layout design using drag and drop
D.Server-side logic using classic workflows or Power Automate
E.Business rules to enforce field requirements and visibility
AnswersA, D, E

Business process flows provide a step-by-step data entry experience.

Why this answer

Options A, D, and E are correct. Model-driven apps include business process flows to guide users, server-side logic via classic workflows or Power Automate, and business rules to enforce field behavior. Option B is incorrect because custom CSS is not a capability; model-driven apps use responsive design.

Option C is incorrect because pixel-perfect drag-and-drop layout is a canvas app feature.

74
MCQeasy

A business analyst wants to create a simple app to track employee vacation requests without writing code. Which type of Power App should they use?

A.Power Pages site
B.Model-driven app
C.Canvas app from a template
D.Power Automate flow
AnswerC

Canvas apps provide a low-code drag-and-drop interface and can start from templates.

Why this answer

Canvas apps from templates provide a low-code or no-code way to build apps with a drag-and-drop interface, ideal for simple tasks like tracking vacation requests. Option A is wrong: Power Pages is for building external-facing websites, not internal apps. Option B is wrong: Model-driven apps are more complex and rely on Dataverse, requiring more structure than needed.

Option D is wrong: Power Automate is for automating workflows, not for building interactive apps.

75
MCQeasy

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?

A.The FullName property is spelled incorrectly
B.The user is not authenticated with Power Apps
C.The ampersand (&) operator is incorrect
D.The User() function is not available in canvas apps
AnswerB

Correct: User() returns blank if not authenticated.

Why this answer

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.

Page 1 of 4 · 238 questions totalNext →

Ready to test yourself?

Try a timed practice session using only Power Apps Capabilities questions.