CCNA Power Apps Capabilities Questions — Page 2 of 4

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, C, and D are correct because a model-driven app requires a Dataverse database, tables, and views. Option B is wrong because flows are optional. Option E is wrong because canvas apps are a different type.

Practice this question →

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 C are correct. Power Apps can create custom apps and integrate with Microsoft 365. Option B is for Power Automate, D is for Power BI, E is for Power Virtual Agents.

Practice this question →

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.

Practice this question →

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, C, and D are correct. Model-driven apps have business process flows, business rules, and server-side logic like workflows. Option B is wrong because pixel-perfect layout is a feature of canvas apps.

Option E is wrong because model-driven apps do not support custom CSS; they have a responsive design.

Practice this question →

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

Option A is correct because canvas apps allow building from a blank canvas or template with a drag-and-drop interface, requiring minimal code. Option B is wrong because model-driven apps are more structured and require Dataverse. Option C is wrong because Power Automate is for workflows.

Option D is wrong because Power Pages is for external websites.

Practice this question →

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.

Practice this question →

MCQhard

A Power Apps canvas app uses a SharePoint list as a data source. Users report that the app is slow when loading data. The list has 10,000 items. Which optimization should you recommend?

A.Reduce the number of columns in the SharePoint list

B.Increase the data row limit for non-delegable queries to 2000

C.Move the data to a SQL database and connect via Power Automate

D.Use delegable filters like Filter() with indexed columns to limit data retrieved

AnswerD

Correct: Delegable queries process on the server, reducing data transferred.

Why this answer

Option C is correct because delegable queries reduce the data retrieved from SharePoint, improving performance. Option A is wrong because increasing the limit doesn't help if the query is non-delegable. Option B is wrong because more columns increase data volume.

Option D is wrong because Power Automate can be used but adds latency.

Practice this question →

MCQhard

A canvas app displays incorrect data because the source SharePoint list has a lookup column to another list. The app maker used 'Choices' function to populate a dropdown, but the dropdown shows IDs instead of display names. What is the cause?

A.The Choices function was used on a lookup column, which returns a table of IDs; use Choices( [List].[Column].DisplayName ) instead.

B.The Choices function was used correctly but the dropdown's DisplayFields property is not set to the display name column.

C.The lookup column is a number type, not text, so it cannot show names.

D.The formula is not delegable, causing only partial data.

AnswerA

For lookup columns, Choices returns the ID table; use the DisplayName property to get display names.

Why this answer

The Choices function returns a table with IDs by default when used with a lookup column; to get display names, the maker should use the 'DisplayName' property. Option A is wrong because delegation is not the issue. Option B is wrong because the formula is correct for single-choice columns.

Option D is wrong because the data type is not number.

Practice this question →

MCQhard

You are troubleshooting a canvas app that loads slowly. The app uses over 50 data sources and many formulas. Which action is most likely to improve performance?

A.Increase the data row limit for each data source

B.Use delegable queries to filter data at the source

C.Disable the formula-level error checking

D.Remove unused data sources from the app

AnswerB

Delegation pushes filtering to the data source, reducing data transfer.

Why this answer

Option C is correct because delegable queries reduce the amount of data transferred by processing on the server side. Option A is wrong because removing data sources might break functionality. Option B is wrong because increasing the data row limit can worsen performance.

Option D is wrong because disabling error checking does not affect performance.

Practice this question →

MCQhard

A developer builds a canvas app that uses a custom connector to call an external API. The API requires an OAuth 2.0 client credentials flow. Which authentication type should the developer configure in the custom connector?

A.OAuth 2.0

B.Windows Authentication

C.API Key

D.Basic Authentication

AnswerA

Supports client credentials grant type.

Why this answer

Option D is correct because OAuth 2.0 client credentials is a standard OAuth flow. Option A is wrong because API Key is a different mechanism. Option B is wrong because Basic authentication is not OAuth.

Option C is wrong because Windows Authentication is not OAuth.

Practice this question →

MCQeasy

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

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

B.Use Excel stored on OneDrive and a Canvas app

C.Use SQL Server as the data source and a Canvas app

D.Use a SharePoint list as the data source and a Canvas app

AnswerD

Correct: SharePoint is included with many Microsoft 365 subscriptions and is easy to manage.

Why this answer

Option A is correct because SharePoint lists are easy to set up, no extra licensing, and can be used with Canvas apps. Option B is wrong because Dataverse requires additional licensing. Option C is wrong because SQL Server requires infrastructure.

Option D is wrong because Excel is not suitable for multi-user concurrent access.

Practice this question →

Multi-Selecthard

A company deploys a model-driven app that uses a custom table 'Project' with a status choice column. The app includes a business rule that shows a warning message when the status is set to 'Completed' but the 'End Date' is blank. The business rule works on the main form but not when records are updated via a Power Automate flow. Which THREE actions should the administrator take to enforce the rule regardless of update method?

Select 3 answers

A.Use a synchronous plug-in that runs on the Update message of the Project table.

B.Add a custom API step in the Power Automate flow to validate the End Date before updating.

C.Configure an asynchronous workflow that runs after the update.

D.Create a real-time workflow on the Project table to validate on update.

E.Modify the business rule to run on all forms.

AnswersA, B, D

Synchronous plug-ins run on the server and can enforce validation.

Why this answer

Option A is correct because a synchronous plug-in runs on the Update message of the Project table, executing immediately within the database transaction. This ensures the validation logic (checking that End Date is not blank when Status is 'Completed') is enforced regardless of the update method, including Power Automate flows, which bypass client-side business rules.

Exam trap

The trap here is that candidates assume business rules apply to all update methods, but they are client-side only and do not execute during server-side operations like Power Automate flows or API calls.

Practice this question →

MCQeasy

A user wants to build an app that allows field technicians to view work orders and capture photos offline. Which type of Power App should be chosen?

A.Power Pages site with offline access.

B.AI Builder model embedded in a canvas app.

C.Model-driven app because it natively supports offline.

D.Canvas app with offline capability enabled.

AnswerD

Canvas apps support offline data and photo capture via the mobile app.

Why this answer

Canvas apps can be enabled for offline use with the mobile app. Option B is wrong because model-driven apps have limited offline capability. Option C is wrong because Power Pages are public websites.

Option D is wrong because AI Builder is not an app type.

Practice this question →

MCQhard

A company uses a model-driven app to manage IT support tickets. The app includes a timeline control to track activities. Recently, users noticed that emails sent from the app are not appearing in the timeline. The email activity is configured correctly. What could be the issue?

A.The email is sent from a shared mailbox.

B.The 'Auto-track' setting in Outlook is disabled.

C.Server-side synchronization is not configured to track sent emails.

D.The timeline control is not added to the form.

AnswerC

Server-side sync must be enabled for email tracking in Dataverse.

Why this answer

Option D is correct because server-side synchronization must be configured to track emails sent from the app; otherwise, they may not appear in the timeline. Option A is wrong because auto-track in Outlook is for incoming emails. Option B is wrong because the timeline control itself does not need configuration.

Option C is wrong because Exchange integration is required but the specific setting is server-side sync.

Practice this question →

Multi-Selecteasy

Which TWO are benefits of using Dataverse as the data source for Power Apps?

Select 2 answers

A.Built-in support for graph data

B.Automatic Excel export

C.Ability to run complex SQL queries

D.Rich relationships between tables

E.Role-based security and field-level permissions

AnswersD, E

Dataverse supports one-to-many and many-to-many relationships.

Why this answer

Options B and D are correct. Dataverse provides built-in security and rich relationships. Option A is wrong because Dataverse is not a relational database management system; it is a data platform.

Option C is wrong because Dataverse is not a graph database. Option E is wrong because Excel is not a benefit of Dataverse.

Practice this question →

MCQhard

A developer creates a canvas app to display orders from Microsoft Dataverse. The app uses the gallery and data configuration shown in the exhibit. When the app runs, the gallery shows orders but the 'View Details' button does nothing when tapped. What is the most likely cause?

A.The button's OnSelect property has a syntax error

B.The target screen 'OrderDetailScreen' does not exist in the app

C.The Dataverse connection requires user authentication

D.The gallery's items property is misconfigured

AnswerB

The navigation action references a screen that is not defined.

Why this answer

Option B is correct because the Navigate function in the button's OnSelect property references 'OrderDetailScreen', but if that screen does not exist in the app, the function cannot execute, causing the button to appear unresponsive. The gallery displays orders correctly, confirming the data source and Items property are functional, isolating the issue to the navigation target.

Exam trap

The trap here is that candidates assume the button's OnSelect property must have a syntax error when it does nothing, but Power Apps silently fails on invalid screen references, making the missing screen the more subtle and likely cause.

How to eliminate wrong answers

Option A is wrong because a syntax error in the OnSelect property would typically cause a yellow triangle warning or a runtime error message, not a silent failure where the button does nothing; the app would still attempt to evaluate the expression. Option C is wrong because if the Dataverse connection required authentication, the gallery would not load orders at all, as the data retrieval would fail with an authentication error. Option D is wrong because the gallery correctly shows orders, proving the Items property is properly configured and returning data from Dataverse.

Practice this question →

Multi-Selecteasy

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

Select 2 answers

A.SQL Server on-premises

B.Oracle database on-premises

C.Microsoft Dataverse

D.SharePoint

E.SAP on-premises

AnswersC, D

Dataverse is a cloud data service.

Why this answer

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

Practice this question →

Multi-Selectmedium

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

Select 2 answers

A.Automate a multi-step approval process

B.Embed an app in Microsoft Teams

C.Build a mobile app for field service technicians

D.Create a chatbot for customer inquiries

E.Create a dashboard with sales data

AnswersB, C

Power Apps can be embedded in Teams.

Why this answer

Power Apps is a low-code platform for building custom apps. Option B is correct because Power Apps can be embedded directly into Microsoft Teams as a tab or personal app, allowing users to access custom apps without leaving the Teams interface. Option C is correct because Power Apps is designed to build mobile apps that can run on iOS, Android, and Windows, making it ideal for field service technicians who need offline-capable, data-entry apps.

Exam trap

The trap here is that candidates confuse the distinct low-code tools in the Power Platform—Power Apps for building apps, Power Automate for workflows, Power BI for dashboards, and Power Virtual Agents for chatbots—and select options that belong to other services.

Practice this question →

Multi-Selecthard

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

Select 3 answers

A.Galleries

B.Views

C.Tables

D.Forms

E.Screens

AnswersB, C, D

Views define how records are listed.

Why this answer

Views, tables, and forms are core components of a model-driven app in Power Apps. Views define how records in a table are displayed in lists, tables store the data, and forms provide the user interface for viewing and editing records. These components are built on Microsoft Dataverse and are essential for structuring the app's data and user experience.

Exam trap

The trap here is that candidates often confuse canvas app components (like galleries and screens) with model-driven app components, because both are part of Power Apps but serve different app types and design paradigms.

Practice this question →

MCQmedium

A Power Apps developer needs to store an image uploaded by a user in a canvas app. The app uses Microsoft Dataverse. Which column type should be used for the image?

A.Text column

B.Image column

C.File column

D.Binary column

AnswerB

Image columns store image data in Dataverse.

Why this answer

Image column (B) in Dataverse is designed to store images. A is for text. C is for files.

D is binary but not directly accessible.

Practice this question →

MCQmedium

A company uses a model-driven app to manage customer cases. The app needs to ensure that when a case is resolved, the resolution time (in hours) is automatically calculated and stored in a custom field. Which feature should be used?

A.A calculated field that computes the difference between created and resolved dates.

B.A real-time workflow (cloud flow) triggered when a case is resolved.

C.A business rule that sets the resolution time field when the status changes.

D.A scheduled Power Automate flow that runs every hour and updates resolved cases.

AnswerB

Real-time workflows can run synchronously when a record's status changes and perform calculations.

Why this answer

A real-time workflow (now called cloud flow) can run immediately when a record status changes and perform calculations. Option A is wrong because business rules cannot write to fields outside the form. Option C is wrong because calculated fields cannot reference other record updates.

Option D is wrong because Power Automate scheduled flow is not triggered by status change.

Practice this question →

MCQhard

A model-driven app uses a custom table 'Service Request' with a status field. The business requires that when a status changes to 'Resolved', the app automatically sends an email to the requester. Which approach should be used?

A.Use a Power Apps component framework (PCF) control to trigger an email.

B.Create a Power Automate flow with a trigger 'When a record is updated' and condition on status change.

C.Add a button on the form that runs a Power Automate flow on demand.

D.Create a business rule that sends an email when the status is updated.

AnswerB

This flow runs automatically when the status field changes.

Why this answer

A Power Automate flow triggered on status change (D) is the correct way to send email automatically. A is a manual action. B does not trigger automatically.

C requires user interaction.

Practice this question →

Multi-Selecthard

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

Select 3 answers

A.Dataverse tables

B.Power Automate flows

C.Views

D.Forms

E.Canvas app screens

AnswersA, C, D

Tables store the data

Why this answer

Option A is correct because tables in Dataverse are the foundation. Option C is correct because forms define how data is displayed and edited. Option E is correct because views define the list of records.

Option B is wrong because canvas apps are separate. Option D is wrong because flows are automations, not required for the app itself.

Practice this question →

MCQhard

A canvas app uses a SharePoint list as its data source. The list contains over 5000 items. Users can only see the first 500 items in the app. What is the most likely solution?

A.Change the gallery to display items in a data table

B.Migrate the data to Microsoft Dataverse

C.Increase the SharePoint list view threshold

D.Modify the query to use a delegable filter

AnswerD

Correct: Delegable filters allow querying all items.

Why this answer

Power Apps has a default delegation limit of 500 items for non-delegable queries. Using a delegable query (e.g., Filter with column that supports delegation) solves this. Changing to gallery doesn't help; increasing list size limit is not possible; switching to Dataverse avoids the issue but is a bigger change.

Practice this question →

100

MCQmedium

A company has a legacy system that exposes a REST API. They want to build a Power App that displays data from this API and allows users to update records. Which connector should they use?

A.HTTP with Azure AD connector

B.Office 365 Users connector

C.SQL Server connector

D.SharePoint connector

AnswerA

Allows calling any REST API with Azure AD authentication.

Why this answer

Option B is correct because the HTTP with Azure AD connector can call any REST API and supports authentication. Option A is wrong because SharePoint connector is for SharePoint lists. Option C is wrong because SQL Server connector is for SQL databases.

Option D is wrong because Office 365 Users connector is for user profiles, not custom APIs.

Practice this question →

101

MCQhard

You are designing a model-driven app for a sales team. The app must show related opportunities on an account form using a subgrid. The subgrid should only display open opportunities. Which configuration should you apply?

A.Add a subgrid and select a view that filters for status equals 'Open'

B.Use a business rule to hide closed opportunities

C.Set a calculated field to mark opportunities as open

D.Create a workflow to remove closed opportunities from the subgrid

AnswerA

Views define the filter criteria for subgrid rows.

Why this answer

Option A is correct because a subgrid in a model-driven app can be filtered by a view that filters for open opportunities. Option B is wrong because business rules cannot filter subgrids. Option C is wrong because workflows run in the background and don't filter subgrids.

Option D is wrong because calculated fields modify data, not filter subgrids.

Practice this question →

102

Matchingmedium

Match each Power Virtual Agents feature to its purpose.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts

Matches

Conversation path for a specific user goal

Extracts specific information from user input

Default response when bot doesn't understand

Transfers conversation to a human agent

Phrases that initiate a topic

Why these pairings

Topics and entities define chatbot behavior.

Practice this question →

103

MCQhard

You are a Power Apps developer at Contoso Ltd. The company uses Microsoft 365 E5 licenses and has a complex environment with multiple departments. The HR department needs a canvas app to manage employee onboarding. The app must connect to a SharePoint Online list containing employee records, and also to the Microsoft Graph API to retrieve manager information. The app should be accessible to HR staff only, who are in a security group named 'HR-Staff'. You need to design the app to ensure data security and minimize licensing costs. The app will be used by 50 HR staff members. You have the following options: A) Create a canvas app using Power Apps, connect to SharePoint via the SharePoint connector and to Microsoft Graph via the HTTP connector with custom authentication. Share the app with the 'HR-Staff' security group. B) Create a model-driven app using Power Apps, connect to SharePoint via the SharePoint connector and to Microsoft Graph via the Microsoft Graph connector provided in Power Apps. Share the app with individual users. C) Create a canvas app using Power Apps, connect to SharePoint via the SharePoint connector and to Microsoft Graph via the HTTP connector with custom authentication. Share the app with individual users. D) Create a model-driven app using Power Apps, connect to SharePoint via the SharePoint connector and to Microsoft Graph via the Microsoft Graph connector provided in Power Apps. Share the app with the 'HR-Staff' security group. Choose the best option.

A.Create a canvas app using Power Apps, connect to SharePoint via the SharePoint connector and to Microsoft Graph via the HTTP connector with custom authentication. Share the app with individual users.

B.Create a canvas app using Power Apps, connect to SharePoint via the SharePoint connector and to Microsoft Graph via the HTTP connector with custom authentication. Share the app with the 'HR-Staff' security group.

C.Create a model-driven app using Power Apps, connect to SharePoint via the SharePoint connector and to Microsoft Graph via the Microsoft Graph connector provided in Power Apps. Share the app with the 'HR-Staff' security group.

D.Create a model-driven app using Power Apps, connect to SharePoint via the SharePoint connector and to Microsoft Graph via the Microsoft Graph connector provided in Power Apps. Share the app with individual users.

AnswerC

Model-driven apps support security group sharing without premium licensing and the native Microsoft Graph connector simplifies integration.

Why this answer

Option D is correct because model-driven apps support security group sharing and the Microsoft Graph connector is native. Option A uses canvas app which may not support security group sharing directly (requires premium licensing for group sharing) and uses custom HTTP connector which is more complex. Option B shares with individual users which is inefficient.

Option C shares with individual users and uses custom HTTP connector.

Practice this question →

104

MCQeasy

You have a canvas app that uses a SharePoint list as its data source. The app needs to filter records based on the current user's email. Which function should you use in the Items property of the gallery?

A.Search(SharePointList, User().Email, "Email")

B.Filter(SharePointList, Email = CurrentUser.Email)

C.Filter(SharePointList, Email = User().Email)

D.Lookup(SharePointList, Email = User().Email)

AnswerC

User().Email returns the current user's email address.

Why this answer

Option D is correct because User().Email returns the current user's email. Option A is wrong because Lookup finds a single record. Option B is wrong because Filter is correct but missing the user function.

Option C is wrong because Search is for text search.

Practice this question →

105

MCQmedium

You are creating a canvas app for expense reporting. The app must allow managers to approve or reject expenses using a dropdown. Which control should you use for the approval action?

A.Radio button

B.Dropdown

C.Text input

D.Slider

AnswerB

Dropdown works well for a short list of options.

Why this answer

Option B is correct because a dropdown is ideal for selecting from a short list. Option A is wrong because radio buttons are better for 2-3 options. Option C is wrong because text input is for free text.

Option D is wrong because slider is for numeric ranges.

Practice this question →

106

MCQmedium

Refer to the exhibit. A developer is creating a model-driven app based on a custom Dataverse table defined by this JSON. The app needs a form that shows the Approved field only when the amount is greater than 1000. Which feature should the developer use?

A.Business rule

B.Form scripting

C.Workflow process

D.Power Automate flow

AnswerA

Business rules can conditionally show fields.

Why this answer

Option D is correct because business rules can show/hide fields based on conditions without code. Option A is wrong because form scripts require JavaScript. Option B is wrong because workflows are for backend processes.

Option C is wrong because Power Automate flows are for automation, not form behavior.

Practice this question →

107

MCQhard

A healthcare organization is developing a Power Apps model-driven app for patient case management. The app uses Microsoft Dataverse as the data source and includes a custom table named 'Patient Cases' with columns: Patient Name, Case Type (choice: Consultation, Procedure, Follow-up), Assigned Doctor, Status (choice: New, In Progress, Completed), and Priority (choice: Low, Medium, High, Critical). The organization requires that when a case is created with Priority = 'Critical', an immediate notification must be sent to the Assigned Doctor via Microsoft Teams and the case must be automatically escalated to the manager if not resolved within 4 hours. Additionally, the app must use a Copilot to summarize patient history when a case is opened. The security team mandates that only doctors and managers can view cases assigned to them, and that all data access must be audited. Which combination of features should you implement to meet all requirements with minimal custom development?

A.Implement JavaScript in the form to call Power Automate for notifications, use owner teams to restrict access, add a custom Copilot page, and enable auditing via Power Apps settings.

B.Use a Dataverse business process flow to trigger Power Automate flows for notifications and escalation, configure field-level security profiles to restrict data access, enable Copilot in the model-driven app to summarize patient history, and enable audit logging on the Patient Cases table.

C.Design a Power Automate flow triggered on case creation that sends Teams notifications and waits for 4 hours before escalation, use sharing permissions to control access, and embed a Copilot AI Builder component.

D.Create business rules to send email notifications and set escalation timers, use role-based security for data access, add a Copilot chat control, and rely on Dataverse default auditing.

AnswerB

All requirements are met with minimal custom development.

Why this answer

Option A is correct because it uses out-of-the-box Dataverse business process flows to trigger Power Automate for notifications and escalation, field-level security for data access, Copilot configured in the model-driven app for summarization, and audit logging enabled in Dataverse. Option B fails because business rules cannot trigger notifications or escalations. Option C uses client-side scripting which is more custom development and less maintainable.

Option D uses Power Automate for everything but misses Copilot integration and audit logging.

Practice this question →

108

MCQmedium

A developer is creating a custom control using Power Apps Component Framework (PCF). After importing the solution, the control appears but does not show any data. What is the most likely issue based on the exhibit?

A.The display-name-key is missing a translation

B.The version number is incorrect

C.The control requires a dataset property but only a text property is defined

D.The namespace is misspelled

AnswerC

Correct: The control expects data but no dataset property is configured.

Why this answer

The 'abilities' section indicates the control expects a dataset, but the only property defined is a single line of text. The control likely needs a dataset property to receive data. The version, namespace, and display key are not causing data issues.

Practice this question →

109

Multi-Selecthard

Which THREE of the following are true about model-driven apps? (Choose THREE.)

Select 3 answers

A.They require custom formulas for business logic

B.They have built-in role-based security

C.They are built on top of Microsoft Dataverse

D.They are responsive and work on multiple devices

E.They can only be used on web browsers

AnswersB, C, D

Security is enforced through Dataverse roles.

Why this answer

Options A, C, and E are correct. Model-driven apps are responsive, built on Dataverse, and use role-based security. Option B is incorrect because they do not support custom formulas like Canvas apps.

Option D is incorrect because they are available for web and mobile (not just web).

Practice this question →

110

MCQhard

You are building a model-driven app for a healthcare organization to manage patient appointments. The app uses a Dataverse table 'Appointments' with columns: Patient (lookup to Contact), Doctor (lookup to User), AppointmentDate, Status (Scheduled, Completed, Cancelled). You need to ensure that doctors cannot view appointments of other doctors. Doctors belong to a security role 'Doctor'. Which approach should you use? A) Create a team with all doctors and share the app with the team. B) Configure field-level security to hide the Doctor field. C) Use hierarchy security to limit access based on the Doctor field. D) Create a custom role with record-level security and configure sharing to only allow doctors to see their own appointments.

A.Configure field-level security to hide the Doctor field.

B.Create a custom role with record-level security and configure sharing to only allow doctors to see their own appointments.

C.Create a team with all doctors and share the app with the team.

D.Use hierarchy security to limit access based on the Doctor field.

AnswerB

Record-level security can restrict access to records where the user is the owner or a related user.

Why this answer

Option D is correct because record-level security can be configured to restrict access to records where the doctor is the owner or related user. Option A: Sharing the app does not restrict data visibility. Option B: Field-level security hides fields but does not filter records.

Option C: Hierarchy security is for manager-subordinate relationships, not for this scenario.

Practice this question →

111

MCQeasy

A user wants to create a simple app to track personal expenses using an Excel file stored in OneDrive. Which Power Apps approach should they use?

A.Create a canvas app from the Excel file

B.Use Power Pages to display the Excel file

C.Create a model-driven app using Dataverse

D.Use Power Automate to create a mobile app

AnswerA

Correct: Canvas apps can use Excel as a data source.

Why this answer

A canvas app can be created directly from an Excel file stored in OneDrive using the Power Apps 'Start from data' option. This generates a three-screen app (browse, detail, edit) that connects to the Excel table via the OneDrive for Business connector, making it ideal for simple personal expense tracking without requiring Dataverse or custom development.

Exam trap

The trap here is confusing Power Automate's mobile app trigger (e.g., button in Power Automate mobile) with the ability to build a full mobile app interface, leading candidates to choose D instead of recognizing that only canvas apps provide a user-facing UI from Excel.

How to eliminate wrong answers

Option B is wrong because Power Pages is designed for external-facing websites with authentication and complex data sources, not for creating a simple personal app from an Excel file. Option C is wrong because model-driven apps require Dataverse, which is overkill for a single Excel file and demands a premium license and structured data modeling. Option D is wrong because Power Automate is an automation platform, not an app-building tool; it cannot create a mobile app interface—it can only trigger flows or generate notifications.

Practice this question →

112

MCQmedium

A company uses a Power App to track inventory. The app displays a gallery of items filtered by a dropdown. When the user selects 'Electronics', the gallery shows all electronics items. However, after the user clears the dropdown, the gallery remains empty. What is the most likely reason?

A.The dropdown's AllowEmptySelection property is set to false

B.The data source requires a refresh after clearing selection

C.The gallery's Items property uses a filter that references Dropdown.Selected.Value, and when the dropdown is cleared, the filter returns blank

D.The app's OnStart property is clearing the data source

AnswerC

When no selection, Dropdown.Selected.Value is blank, filter returns no items

Why this answer

Option A is correct because if the filter uses Dropdown.Selected.Value, when nothing is selected the value is blank, causing the filter to fail. Option B is wrong because the dropdown is not required to be cleared; the issue is the filter. Option C is wrong because performance is not the issue.

Option D is wrong because the data source is likely fine.

Practice this question →

113

MCQeasy

A company wants to build a Power Apps app that can be used offline by field workers. Which type of app should they choose?

A.Canvas app

B.Copilot Studio

C.Power Pages

D.Model-driven app

AnswerA

Correct: Canvas apps can be enabled for offline use.

Why this answer

Option A is correct because Canvas apps support offline use through the Offline feature. Option B is wrong because model-driven apps do not support offline. Option C is wrong because Copilot Studio is for copilots.

Option D is wrong because Power Pages are websites and do not support offline.

Practice this question →

114

Multi-Selectmedium

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

Select 2 answers

A.Power Virtual Agents

B.Power Automate

C.Common Data Model

D.Copilot integration

E.AI Builder

AnswersD, E

Copilot can be integrated into Power Apps to provide AI-powered assistance.

Why this answer

Options A and D are correct because AI Builder allows you to add AI models to Power Apps, and Copilot integration allows you to embed AI-powered copilots. Options B and C are incorrect because Power Automate is a separate product and Power Virtual Agents is a separate product for chatbots. Option E is incorrect because the Common Data Model is a data schema, not an AI feature.

Practice this question →

115

MCQmedium

A company uses Power Apps to build a leave request app. Managers must approve requests only if the employee has sufficient leave balance. Which approach ensures the balance is checked before submission?

A.Create a Power BI report to visualize leave balances and have managers manually check

B.Use the SubmitForm function with a validation formula checking leave balance

C.Configure a Power Automate flow to check balance after submission and auto-reject if insufficient

D.Set a foreign key constraint in Dataverse to limit leave requests based on balance

AnswerB

Correct: Validation can be done in the app before submission.

Why this answer

Option A is correct because Power Apps allows validation logic in the SubmitForm function to check conditions before data is submitted. Option B is wrong because Power Automate can check after submission but not prevent it. Option C is wrong because Power BI is for analytics, not validation.

Option D is wrong because Canvas apps do not enforce foreign keys.

Practice this question →

116

MCQhard

A developer is building a Canvas app that uses a custom connector to an external API. The API requires OAuth 2.0 authentication. What must the developer do to set up the connector?

A.Select 'OAuth 2.0' as the authentication type and enter the API key

B.Create the connector with a Swagger file and set authentication to 'Anonymous'

C.Use the built-in HTTP connector with Basic authentication

D.Register an application in Microsoft Entra ID and configure the custom connector with the client ID and secret

AnswerD

OAuth 2.0 requires app registration and credentials.

Why this answer

Option D is correct because custom connectors with OAuth 2.0 require registering the app in Microsoft Entra ID. Option A is not possible. Option B is for custom API, not authentication.

Option C is for API key authentication, not OAuth.

Practice this question →

117

MCQmedium

A company uses a canvas app to collect customer feedback. The app stores data in Microsoft Dataverse. Users report that some submissions are not saved when the app loses internet connection. How should the app be modified to prevent data loss?

A.Use a SharePoint list instead of Dataverse

B.Reduce the number of controls on the form

C.Increase the data row limit in Dataverse

D.Enable offline capability in the app settings

AnswerD

Correct: Offline mode caches data locally and syncs when connected.

Why this answer

Enabling offline capability with a local cache allows data to be saved locally and synced when online. Reducing controls or increasing data limit won't solve offline loss.

Practice this question →

118

MCQeasy

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?

A.Model-driven app

B.Canvas app

C.Power Automate

D.Power Pages

AnswerA

Correct: Model-driven apps auto-generate UI from the data model.

Why this answer

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.

Exam trap

The trap here is that candidates often confuse canvas apps (which require manual UI design) with model-driven apps (which auto-generate UI from data), leading them to choose canvas apps because they think 'custom app' means full control over the interface, ignoring the 'automatically generate a responsive UI' requirement.

How to eliminate wrong answers

Option B (Canvas app) is wrong because it requires manual design of the user interface from scratch, not automatically generating a responsive UI based on the data model. Option C (Power Automate) is wrong because it is a workflow automation tool, not an app for displaying and updating records with a UI. Option D (Power Pages) is wrong because it is designed for external-facing websites, not for internal custom apps that interact with Dynamics 365 Sales data and require automatic UI generation from the data model.

Practice this question →

119

MCQmedium

A user built a canvas app that uses a SharePoint list. When they add the app to a Teams channel, some users cannot see the data. The app works fine when opened directly from Power Apps. What is the most likely cause?

A.The users do not have Power Apps licenses assigned

B.The app uses a deprecated connector

C.The users do not have permissions to the underlying SharePoint list

D.The SharePoint connector requires a Premium license in Teams

AnswerC

In Teams, app users may not have direct SharePoint access; permissions must be granted separately.

Why this answer

Option D is correct because SharePoint permissions are inherited; Team members may be from outside the SharePoint group. Option A is wrong because licenses are per user, not per Teams. Option B is wrong because the app works outside Teams, so the app itself is fine.

Option C is wrong because SharePoint connector does not require premium license.

Practice this question →

120

MCQhard

A Power App uses a Patch function to update a Dataverse table. The app runs into delegation warnings for large datasets. Which approach best resolves delegation warnings while maintaining functionality?

A.Increase the data row limit in the app settings

B.Switch the data source to SharePoint for better delegation support

C.Avoid using delegable functions to reduce complexity

D.Use delegable functions such as Filter and LookUp to retrieve only necessary records before performing updates

AnswerD

Delegable functions process data on server, reducing warnings

Why this answer

Option A is correct because delegable functions like Filter, Search, and LookUp can be used to limit data before aggregation. Option B is wrong because increasing batch size does not address delegation. Option C is wrong because delegable functions reduce warnings.

Option D is wrong because switching to SharePoint may still have delegation issues.

Practice this question →

121

MCQmedium

A Power App is used by a global team. The app displays dates in US format (MM/DD/YYYY), but users in Europe expect DD/MM/YYYY. What is the best way to handle this?

A.Hardcode the date format based on the user's region in the app

B.Do nothing; Power Apps automatically formats dates based on the user's browser locale

C.Use the Language function to set the date format manually

D.Use a text input for dates instead of a date picker

AnswerB

Power Apps uses browser locale to format dates appropriately

Why this answer

Option D is correct because the app should respect the user's locale settings. Option A is wrong because hardcoding a format ignores user locale. Option B is wrong because a single format won't satisfy all.

Option C is wrong because the Language function returns the user's locale, which can be used to format dates dynamically, but the best practice is to let Power Apps handle locale automatically by not overriding format.

Practice this question →

122

Multi-Selectmedium

Which TWO of the following are valid data sources for a canvas app?

Select 2 answers

A.Power Pages form

B.SharePoint list

C.Power Virtual Agents topic

D.SQL Server database

E.Power BI dataset

AnswersB, D

Canvas apps can connect to SharePoint lists directly.

Why this answer

Options B and D are correct. SharePoint lists and SQL Server are common data sources. Option A is wrong because Power BI is not a data source; it is a visualization tool.

Option C is wrong because Power Virtual Agents is a chatbot builder. Option E is wrong because Power Pages is a website builder.

Practice this question →

123

MCQhard

A canvas app includes a gallery that shows a list of customers. The app loads slowly when the gallery displays more than 500 records. What is the best way to improve performance?

A.Use a non-delegable query

B.Convert the app to a model-driven app

C.Apply a filter to the gallery data source

D.Increase the gallery height

AnswerC

Filtering reduces the number of records fetched.

Why this answer

Option B is correct because using a filter to reduce the number of records loaded improves performance. Option A is wrong because increasing the gallery height does not affect data loading. Option C is wrong because delegable queries only work with certain data sources; for non-delegable sources, filtering is best.

Option D is wrong because moving to a model-driven app is a redesign, not a simple fix.

Practice this question →

124

MCQhard

A model-driven app uses a custom business process flow. Users report that they cannot progress beyond a stage even after completing all required fields. What should you check?

A.Whether the stage is locked by an administrator

B.Whether the required fields on the form are marked as business required

C.Whether the user has the correct security role to update the stage

D.Whether the stage has a condition that is not being met

AnswerD

Correct: Conditions must be satisfied to move to the next stage.

Why this answer

Option B is correct because business process flow stages can have conditions that must be met; if a condition is not satisfied, the stage cannot be moved. Option A is wrong because stages are not locked by default. Option C is wrong because form fields may be required but not part of the stage condition.

Option D is wrong because security roles control access, not stage progression.

Practice this question →

125

Multi-Selectmedium

A company is planning to build a Power Apps app for field service technicians to view and update work orders. The app must work offline and sync data when connected. Which TWO components are required to achieve offline capability?

Select 2 answers

A.Power Automate flow triggered on data change

B.Offline profile in Microsoft Dataverse

C.SharePoint list as data source

D.Power Apps mobile player

E.Common Data Service (Dataverse) database

AnswersB, D

An offline profile defines which tables and data are available offline.

Why this answer

An offline profile in Microsoft Dataverse defines which tables, columns, and relationships are available when the app is disconnected. It enables the Power Apps mobile player to cache data locally and synchronize changes automatically when connectivity is restored. Without an offline profile, the app cannot determine what data to store or how to resolve conflicts during sync.

Exam trap

The trap here is that candidates often assume the Dataverse database alone (Option E) is sufficient for offline capability, but the offline profile is the explicit configuration required to define what data is cached and how sync operates.

Practice this question →

126

MCQmedium

A Power Apps canvas app uses a Microsoft Entra ID group to control access. When a new user is added to the group, they cannot access the app. What is the most likely reason?

A.The group membership change takes 24 hours to propagate

B.The app share does not automatically include new group members; the app must be re-shared

C.The app is shared with individual users, not the group

D.The app has a caching issue that prevents permission updates

AnswerB

Correct: When sharing with a group, new members are automatically added, but if the app was shared with the group, it should work. The most likely reason is that the app was shared with the group, but the group itself was not assigned the correct role, or the app requires explicit sharing refresh.

Why this answer

Option D is correct because the app may have a separate permission share that is not automatically updated when the group changes. Option A is wrong because the app is shared with the group, not individual users. Option B is wrong because group membership changes usually propagate quickly.

Option C is wrong because Power Apps caches permissions, but the issue is likely share settings.

Practice this question →

127

MCQeasy

A company wants to build an app that allows external vendors to submit invoices through a web portal. The app must be accessible without signing in with a Microsoft account. Which Power Platform solution should they use?

A.Power Pages site with anonymous access enabled

B.Canvas app shared with everyone

C.Model-driven app with anonymous access

D.Power Automate portal

AnswerA

Power Pages allows anonymous external access with proper configuration.

Why this answer

Power Pages (C) is designed for external-facing websites with anonymous access. Canvas apps (A) require Power Apps licenses. Model-driven apps (B) require authenticated users.

Power Automate (D) is for workflows.

Practice this question →

128

MCQhard

A Power Apps app calls a Power Automate flow with the trigger schema shown. The app passes an email string and a score number. However, the flow fails with a validation error. What is the most likely cause?

A.The app is passing the parameters as individual strings instead of a JSON object

B.The email property is misspelled

C.The score property should be a string

D.The flow trigger is set to 'When a HTTP request is received' instead of manual

AnswerA

Correct: The trigger expects a JSON object with properties.

Why this answer

The trigger expects an object with properties 'email' and 'score'. If the app passes the parameters in a different order or as separate values instead of a JSON object, the flow fails. The schema is valid, and the types match.

Practice this question →

129

MCQeasy

A company wants to build a Power App that uses AI to extract information from uploaded invoices. Which capability should they use?

A.Power Automate with OCR actions

B.AI Builder invoice processing model

C.Power Virtual Agents

D.Copilot Studio

AnswerB

AI Builder has prebuilt models for invoice extraction.

Why this answer

Option D is correct because AI Builder provides prebuilt models for invoice processing. Option A is wrong because Power Virtual Agents is for chatbots. Option B is wrong because Copilot Studio is for custom copilots.

Option C is wrong because Power Automate can incorporate AI Builder but is not the AI capability itself.

Practice this question →

130

Multi-Selectmedium

Which TWO data sources support delegation in Power Apps? (Choose two.)

Select 2 answers

A.SharePoint lists

B.SQL Server

C.Excel workbooks

D.Text files

E.Microsoft Dataverse

AnswersA, E

Correct: SharePoint supports delegation for indexed columns.

Why this answer

Options A and C are correct because Microsoft Dataverse and SharePoint support delegation for many queries. Option B is wrong because Excel does not support delegation. Option D is wrong because SQL Server supports delegation, but the question asks for two, and Dataverse and SharePoint are common.

Option E is wrong because text files do not support delegation.

Practice this question →

131

Multi-Selecthard

Which THREE are valid ways to embed a canvas app in another application? (Choose three.)

Select 3 answers

A.Embed in a SharePoint page using the Power Apps web part

B.Embed in Microsoft Excel using a custom add-in

C.Add as a custom visual in a Power BI report

D.Add as a tab in Microsoft Teams

E.Embed in Dynamics 365 Sales Hub

AnswersA, C, D

SharePoint supports embedding canvas apps.

Why this answer

Options A, B, and D are correct because Power Apps can be embedded in SharePoint, Teams, and Power BI. Option C is wrong because Excel does not support embedding canvas apps. Option E is wrong because Dynamics 365 uses model-driven apps primarily.

Practice this question →

132

MCQmedium

A company uses Power Apps to create a canvas app for employee expense reporting. The app needs to integrate with the corporate HR system to fetch employee details such as manager email and cost center. The HR system exposes a REST API that requires an API key in the header. Which approach should the app maker use to securely connect to the HR system?

A.Store the HR data in a SharePoint list and connect the app to SharePoint.

B.Build a Power Automate flow that calls the API and returns data to the app.

C.Create a custom connector with API key authentication and use it in the app.

D.Use the HTTP action in Power Apps to call the API and include the API key in the headers as a static value.

AnswerC

Custom connectors support various authentication types and securely store credentials.

Why this answer

Option A is correct because a custom connector allows configuring authentication (e.g., API key) and can be used in the app. Option B is wrong because HTTP with manual headers exposes the API key in the app code. Option C is wrong because SharePoint is not a REST API for an external system.

Option D is wrong because Power Automate still requires a secure connection method.

Practice this question →

133

MCQmedium

A business analyst creates a canvas app connected to a SharePoint list. Users report that the app loads slowly when accessing it on their mobile phones. What is the most likely cause?

A.The app uses a non-delegable query

B.The SharePoint list has more than 500 items

C.The app retrieves all columns from the SharePoint list on startup

D.The app uses too many images and controls on the first screen

AnswerC

Correct: Retrieving unnecessary columns increases data load and slows performance.

Why this answer

Slow loading on mobile is often due to too many data source calls on startup. Using fewer columns reduces load time. The app size and delegation issues are less likely to be the primary cause here.

Practice this question →

134

MCQmedium

A company has a model-driven app for project management. Project managers need to add a custom button to the ribbon that runs a Power Automate flow to send a status report. Which tool should you use to customize the ribbon? A) Power Apps Solution Explorer B) Command bar designer in the app designer C) PCF (Power Apps Component Framework) D) Ribbon Workbench tool

A.Command bar designer in the app designer

B.PCF (Power Apps Component Framework)

C.Power Apps Solution Explorer

D.Ribbon Workbench tool

AnswerA

The command bar designer allows adding buttons that trigger Power Automate flows.

Why this answer

Option B is correct because the command bar designer in the app designer allows adding custom buttons that invoke flows. Option A: Solution Explorer is for classic customization but not recommended for modern apps. Option C: PCF is for building custom components, not simple button actions.

Option D: Ribbon Workbench is a third-party tool, not official Microsoft tool.

Practice this question →

135

MCQmedium

A retail company uses Power Apps to build a mobile app for store managers to approve discount requests. The app must work offline and sync when connected. Which type of app should the developer choose?

A.Portal

B.Model-driven app

C.Canvas app

D.Power Automate

AnswerC

Canvas apps can be built to work offline with the Power Apps mobile player.

Why this answer

Canvas apps are the correct choice because they support offline capability by leveraging the Power Apps offline sync feature, which allows data to be cached locally on the device and synchronized with the data source (e.g., Dataverse or SharePoint) when connectivity is restored. This makes them ideal for mobile scenarios like store managers approving discount requests in areas with intermittent connectivity.

Exam trap

The trap here is that candidates often confuse Model-driven apps with offline capability because they see 'mobile' in the question, but Model-driven apps require a constant connection to Dataverse and do not offer built-in offline sync like Canvas apps do.

How to eliminate wrong answers

Option A is wrong because Power Apps Portals are designed for external user access via a web browser and do not natively support offline operation or mobile app deployment. Option B is wrong because Model-driven apps are primarily web-based and rely on continuous connectivity to Dataverse; while they can be used on mobile devices, they lack native offline data caching and sync capabilities without additional custom development. Option D is wrong because Power Automate is a workflow automation tool, not an app-building platform, and cannot be used to create a standalone mobile app with offline functionality.

Practice this question →

136

MCQmedium

Fabrikam, Inc. uses Power Apps to create a canvas app for expense reporting. The app is connected to a SharePoint list named Expenses. The app allows users to submit expenses, attach receipts, and view their history. The manager wants to add a feature where users can scan a receipt using the mobile app camera and automatically extract the amount and date using AI Builder. The extracted data should be populated into the form fields. The development team needs to implement this feature. Which steps should they take?

A.Use AI Builder's receipt processing model in Power Apps

B.Create a Power Automate flow that processes the image and returns the data

C.Use the Camera control to capture the image and use a custom formula to extract text

D.Integrate Microsoft Copilot Studio to handle the receipt scanning

AnswerA

AI Builder provides a ready-to-use model for receipt scanning.

Why this answer

Option C is correct because AI Builder provides prebuilt models for receipt processing. Option A is wrong because there is no receipt scanner control in Power Apps without AI Builder. Option B is wrong because Power Automate can be used but is not required if AI Builder is used directly.

Option D is wrong because Copilot Studio is for chatbots, not receipt scanning.

Practice this question →

137

MCQeasy

A company uses Power Apps to manage expense reports. Employees submit expense reports via a canvas app that writes to a Dataverse table. Managers need to approve or reject expenses. Which Power Platform component should you use to implement the approval workflow? A) Add an approval step in the canvas app using the 'Approval' connector. B) Use Power Automate with the 'Start and wait for an approval' action. C) Create a business rule in Dataverse to send email. D) Use Power BI to notify managers.

A.Use Power BI to notify managers.

B.Use Power Automate with the 'Start and wait for an approval' action.

C.Add an approval step in the canvas app using the 'Approval' connector.

D.Create a business rule in Dataverse to send email.

AnswerB

Power Automate has built-in approval actions that can be triggered from the app.

Why this answer

Option B is correct because Power Automate provides built-in approval actions. Option A: The Approval connector works with Power Automate, not directly in canvas apps. Option C: Business rules cannot initiate approval workflows.

Option D: Power BI is for analytics, not workflow.

Practice this question →

138

Multi-Selecteasy

Which TWO capabilities does Power Apps provide? (Choose two.)

Select 2 answers

A.Creating Power BI dashboards

B.Scheduling automated workflows

C.Implementing business process flows

D.Building custom user interfaces with canvas apps

E.Training custom AI models

AnswersC, D

Model-driven apps support business process flows.

Why this answer

Option B is correct because canvas apps allow custom layouts. Option D is correct because model-driven apps provide business process flows. Option A is wrong because Power Apps does not create Power BI dashboards natively.

Option C is wrong because Power Automate handles scheduled automations. Option E is wrong because AI Builder is a separate add-on, not a core capability of Power Apps.

Practice this question →

139

MCQmedium

A company wants to create a Power App that allows employees to submit expense reports with receipts. The app must be accessible from both mobile devices and desktop browsers, and must include a workflow for approval. Which combination of Power Platform components should be used?

A.Canvas app with Power Automate flow triggered by form submission.

B.Model-driven app with embedded Power Automate flow for approval.

C.Canvas app with AI Builder to process receipts and Power Automate for approval.

D.Power Pages site with a custom workflow.

AnswerA

Canvas apps can be responsive and Power Automate handles the approval process.

Why this answer

A canvas app provides responsive design for mobile/desktop, and Power Automate handles the approval workflow. Option A is wrong because model-driven apps are less flexible for mobile. Option C is wrong because Power Pages are external.

Option D is wrong because AI Builder is not needed for approval.

Practice this question →

140

MCQmedium

A Power Apps developer created a canvas app that uses a SQL Server data source. Users report that the app is slow when navigating between screens. Which design change should the developer make to improve performance?

A.Replace the SQL data source with a SharePoint list to increase delegation limits.

B.Move all data loading logic from OnVisible to the App.OnStart property.

C.Add a Timer control to preload data for the next screen.

D.Apply delegation-compatible filters on galleries to reduce data loaded from the server.

AnswerD

Delegation pushes filtering to SQL, reducing data sent to the app.

Why this answer

Using delegation with server-side filtering (A) reduces data transfer and improves speed. B is incorrect because OnStart runs once and does not affect navigation. C is wrong as SQL supports delegation.

D is unnecessary; the issue is data volume.

Practice this question →

141

MCQhard

A company wants to use Power Apps to create a mobile app for field technicians. The app must work offline and sync data when connectivity is restored. Which feature should they use?

A.Offline capability in Dataverse (mobile offline sync)

B.Power Apps portals

C.Power Apps component framework

D.Monitor tool in Power Apps

AnswerA

Dataverse enables offline data sync for mobile apps.

Why this answer

Option B is correct because Dataverse supports offline mobile experiences. Option A is not a Power Apps feature. Option C is for debugging.

Option D is for performance optimization.

Practice this question →

142

MCQmedium

A company uses Power Apps to manage customer service cases. They want to implement a business rule that automatically sets the priority to 'High' when the customer is a VIP. Where should the business rule be defined?

A.In the SharePoint list settings

B.In a Power Automate flow

C.In the Dataverse table's business rules settings

D.In the canvas app's OnStart property

AnswerC

Business rules are defined on Dataverse tables.

Why this answer

Business rules are defined on Dataverse tables and apply to model-driven apps. Option B is correct. Option A is wrong because business rules are not defined in canvas apps.

Option C is wrong because Power Automate is for flows, not business rules. Option D is wrong because SharePoint lists do not support Power Apps business rules.

Practice this question →

143

MCQeasy

You are reviewing a Power Automate flow that uses an Office 365 Users connector. The exhibit shows a JSON definition of an action. What does this action do?

A.Updates the profile of the user who triggered the flow.

B.Deletes the user profile of the record owner.

C.Creates a new user profile in Office 365.

D.Retrieves the user profile of the record owner.

AnswerD

The operation is GetUserProfile and the User parameter is the owner.

Why this answer

The action uses the GetUserProfile operation with a User parameter taken from the trigger output. It retrieves the profile of the user who is the owner of the triggering record. Option A is wrong because there is no update.

Option B is wrong because it is not creating. Option D is wrong because it is not deleting.

Practice this question →

144

Multi-Selecteasy

Which TWO are types of apps you can create with Microsoft Power Apps?

Select 2 answers

A.Model-driven app

B.Copilot Studio bot

C.Canvas app

D.Flow app

E.Power BI report

AnswersA, C

Model-driven apps are data-centric and use Dataverse.

Why this answer

Correct: A and C. Canvas apps (A) and model-driven apps (C) are the two primary types. B is wrong because Flow is Power Automate.

D is wrong because Power BI is a separate product. E is wrong because Copilot Studio is for chatbots.

Practice this question →

145

MCQhard

Refer to the exhibit. A Power Apps administrator runs the PowerShell command shown. What is the purpose of this command?

A.To remove the user from a Power Apps environment

B.To check if the user can connect to Dataverse

C.To create a new Power Apps license for the user

D.To verify which Power Apps licenses are assigned to the user

AnswerD

The AssignedLicenses property shows license SKUs, including Power Apps.

Why this answer

Option D is correct because the administrator is checking which licenses (including Power Apps) are assigned to the user. Option A is wrong because the command is not about app permissions. Option B is wrong because it does not create anything.

Option C is wrong because it does not check connectivity.

Practice this question →

146

MCQmedium

Refer to the exhibit. A canvas app has a gallery (Gallery1) with the Items property shown. The app also has a text input (TextSearchBox1) for searching accounts. Users report that when they type a search term, the gallery does not update until they click a button. What is the most likely cause?

A.The data source is not delegable, causing the filter to fail

B.The text input's OnChange event is not set to refresh the gallery

C.The gallery's DelayOutput property on the text input is set to true

D.The gallery's Items property is set to a static value instead of using TextSearchBox1.Text

AnswerD

If the Items property is not dynamic, it won't respond to text changes

Why this answer

Option A is correct because the gallery's Items property uses the text input value, but if the formula is not set to react to changes, it won't update automatically. The default behavior is that the gallery should update as the user types, but if the TextSearchBox1 is not bound correctly or the formula is in a different context (e.g., only on button click), it may not update. However, the question implies the formula is correct but the gallery doesn't update.

The typical issue is that the formula is placed in the wrong property (e.g., OnSelect of a button). Option A is most plausible.

Practice this question →

147

MCQmedium

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?

A.Increase the data row limit in the app settings.

B.Switch to a Microsoft Dataverse data source.

C.Reduce the number of columns in the SharePoint list.

D.Use delegation-compatible functions and filters in the app.

AnswerD

Delegation pushes processing to the data source, reducing the amount of data retrieved.

Why this answer

Delegation allows queries to be processed on the data source side, reducing data transferred. Option C is correct. Option A is wrong because it doesn't address the root cause.

Option B is wrong because limiting fields might not help if delegation is not used. Option D is wrong because using a different data source may not be feasible.

Practice this question →

148

MCQeasy

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?

A.Power Virtual Agents

B.Power Apps

C.Power Automate

D.Power BI

AnswerC

Power Automate provides built-in approval actions and workflow automation.

Why this answer

Power Automate is the tool for creating approval workflows. Option D is correct. Option A is wrong because Power Apps is for building the app interface, not the workflow.

Option B is wrong because Power BI is for data visualisation. Option C is wrong because Power Virtual Agents is for chatbots.

Practice this question →

149

MCQhard

A model-driven app for inventory management uses a custom entity 'Warehouse'. The app maker added a subgrid showing 'Warehouse Items' related to the selected warehouse. However, the subgrid does not show any data even though there are items linked. What is the most likely cause?

A.The Warehouse form does not include the lookup field to Warehouse Items.

B.The user does not have read permissions on the Warehouse Items entity.

C.The relationship between Warehouse and Warehouse Items is not configured correctly or is missing.

D.The subgrid component is not supported on the main form.

AnswerC

Subgrids rely on a relationship to filter related records; without it, no data appears.

Why this answer

The subgrid must have a relationship defined between Warehouse and Warehouse Items; if the relationship is missing or incorrectly configured, the subgrid will not display related records. Option A is wrong because security roles affect visibility, not relationship. Option C is wrong because the subgrid does not require lookup field on the main form.

Option D is wrong because subgrids can be added to forms.

Practice this question →

150

MCQeasy

A business analyst wants to build an app quickly using a pre-built template. Which Power Apps capability should they use?

A.Create a Model-driven app from a Dataverse table

B.Use Power Automate to generate the app

C.Use a Power Apps template from the template gallery

D.Create a Canvas app from blank

AnswerC

Templates provide a starting point with pre-built functionality.

Why this answer

Option C is correct because Power Apps offers templates for common scenarios. Canvas apps from blank require more effort. Model-driven apps are not template-based.

Power Automate is for workflows.

Practice this question →