Courseiva

CCNA Power Apps Capabilities Questions

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

Practice these questionsExam hubAll questions
76
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

Delegable filters such as Filter() with indexed columns allow Power Apps to push filtering to the data source (SharePoint), reducing the amount of data retrieved and improving performance. Option A is incorrect because reducing columns has minimal impact on the amount of data loaded, and delegable queries are more effective. Option B is incorrect because increasing the data row limit for non-delegable queries only affects the number of records displayed, not the data retrieved from SharePoint; the query still fetches all 10,000 items.

Option C is incorrect because moving to SQL and using Power Automate introduces additional complexity and potential latency, and is not the most direct optimization for a SharePoint data source.

Practice this question →
77
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 when used on a lookup column returns a table of IDs by default, not display names. To get display names, the correct syntax is Choices([List].[Column].DisplayName). Option B is incorrect because the Choices function returns both IDs and display names; the DisplayFields property is not needed if using the correct syntax.

Option C is incorrect because lookup columns are typically text-based, not number types. Option D is incorrect because delegation is not relevant to this issue.

Practice this question →
78
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

Delegable queries process filtering on the data source server, reducing the amount of data transferred to the app and improving load time. Option A is incorrect because increasing the data row limit can actually increase the amount of data loaded, worsening performance. Option C is incorrect because disabling formula-level error checking does not affect performance and can hide issues.

Option D is incorrect because removing unused data sources helps reduce app size but may not be the most impactful action for slow loading due to excessive data retrieval.

Practice this question →
79
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

OAuth 2.0 client credentials flow is a standard OAuth flow used for server-to-server authentication where no user is involved. Option B is incorrect because Windows Authentication is not OAuth-based and does not support client credentials flow. Option C is incorrect because API Key is a simple token-based authentication, not OAuth.

Option D is incorrect because Basic Authentication sends credentials in plaintext and is not OAuth 2.0.

Practice this question →
80
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 lists are easy to set up, require minimal administration, and are often included with Microsoft 365 subscriptions. Canvas apps are low-code and easy to maintain, making this combination ideal for the business's constraints.

Why this answer

SharePoint lists are easy to set up with no extra licensing (often included with Microsoft 365) and can be used with Canvas apps, which are low-code and easy to maintain. Option A is wrong because Dataverse requires additional licensing and Model-driven apps are more complex to build and maintain. Option B is wrong because Excel on OneDrive does not support multi-user concurrent access reliably and can lead to data conflicts.

Option C is wrong because SQL Server requires dedicated infrastructure and maintenance, which is not feasible for a small business with limited budget and no IT staff.

Practice this question →
81
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

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 →
82
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 via the mobile app, allowing field technicians to view work orders and capture photos without connectivity. Option A is incorrect because Power Pages sites are public-facing websites, not designed for offline field worker scenarios. Option B is incorrect because AI Builder is a service for adding AI capabilities, not an app type; embedding it does not provide native offline support.

Option C is incorrect because model-driven apps have limited offline capabilities and are not as flexible for offline data capture as canvas apps.

Practice this question →
83
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

Server-side synchronization must be configured to automatically track sent emails in the timeline. Without this configuration, emails sent from the app may not be recorded. Option A is incorrect because the issue is not about shared mailbox; emails from shared mailboxes can still appear in the timeline if configured.

Option B is incorrect because 'Auto-track' in Outlook is a client-side setting and does not affect server-side tracking of sent emails. Option D is incorrect because the timeline control is already present and working for other activities; the problem is specifically with sent emails not appearing.

Practice this question →
84
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 D and E are correct. Dataverse provides rich relationships between tables (D) and role-based security with field-level permissions (E). Option A is incorrect because Dataverse is not a graph database and does not natively support graph data.

Option B is incorrect because automatic Excel export is not a built-in feature of Dataverse; it can be achieved through Power Apps or Power Automate. Option C is incorrect because Dataverse does not support complex SQL queries directly; it uses a Power Platform-specific query language (FetchXML or OData).

Practice this question →
85
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

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

Practice this question →
87
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 →
88
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 →
89
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 →
90
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

The correct approach is to create a Power Automate flow with a trigger 'When a record is updated' and a condition on the status change to 'Resolved'. This automates the email sending when the status is updated. Option A (PCF control) requires custom development and does not automatically trigger on status change.

Option C (manual button) requires user interaction and does not trigger automatically. Option D (business rule) cannot send emails directly; business rules only modify fields or show messages.

Practice this question →
91
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

Dataverse tables provide the data foundation for model-driven apps. Option C is correct because views define which records to display and in what format. Option D is correct because forms define how data is presented for viewing or editing.

Option B is incorrect because Power Automate flows are automations, not core components of a model-driven app. Option E is incorrect because canvas app screens belong to canvas apps, not model-driven apps.

Practice this question →
92
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 →
93
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

The HTTP with Azure AD connector can call any REST API and supports authentication, making it suitable for integrating with a legacy system that exposes a REST API. Option B is wrong because the Office 365 Users connector is designed for retrieving user profiles from Microsoft 365, not for calling custom REST APIs. Option C is wrong because the SQL Server connector is used to connect to SQL databases, not REST APIs.

Option D is wrong because the SharePoint connector is intended for interacting with SharePoint lists and documents, not for consuming REST APIs.

Practice this question →
94
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

Power Virtual Agents uses Topics to define conversation flows, Entities to extract data, Actions to interact with external systems, and Triggers to initiate topics based on user keywords. Common confusions include swapping the roles of Topics and Entities, or Entities and Actions.

Practice this question →
95
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

Incorrect. This is a canvas app with HTTP connector and individual user sharing, which is inefficient and complex. The Microsoft Graph connector is not used.

Why this answer

Model-driven apps support sharing with security groups natively, simplifying access management for the 50 HR staff members. The Microsoft Graph connector provided in Power Apps offers a simpler and more secure integration than the HTTP connector with custom authentication. Option C (model-driven app with Microsoft Graph connector and security group sharing) meets both requirements efficiently.

Option D (model-driven app with individual sharing) is less efficient for managing 50 users. Option A (canvas app with HTTP connector and individual users) introduces complexity and lacks native group sharing. Option B (canvas app with HTTP connector and security group) requires premium licensing for group sharing and uses a custom connector, increasing cost and complexity.

Exam trap

Candidates may be tempted to choose a model-driven app with individual sharing (Option D) thinking that model-driven is sufficient, but the requirement for simplifying access management for 50 users makes sharing with the HR-Staff security group essential. Option C is the best practice.

Practice this question →
96
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

The User() function returns a record with the current user's details, including Email. Option A is incorrect because the Search function is used for searching text across multiple columns, not for filtering by exact match. Option B is incorrect because CurrentUser is not a valid function; the correct syntax is User().Email.

Option D is incorrect because Lookup returns a single record, not a filtered set of records.

Practice this question →
97
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

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 →
98
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

Correct. Business rules allow showing/hiding fields based on conditions without code.

Why this answer

Business rules can show or hide fields based on conditions without requiring code. Option A is correct because business rules are designed for declarative logic in model-driven apps, such as showing the Approved field only when Amount > 1000. Option B is incorrect because form scripting requires JavaScript, which is not necessary here.

Option C is incorrect because workflow processes handle backend logic, not form behavior. Option D is incorrect because Power Automate flows are for automation outside of forms.

Practice this question →
99
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.
AnswerA

Correct: Owner teams restrict access to assigned records, JavaScript calls Power Automate for notifications/escalation, custom Copilot page provides summarization, and auditing is enabled via settings. This uses minimal custom development.

Why this answer

It uses owner teams to provide record-level security, ensuring that doctors and managers only see cases assigned to them. JavaScript can call a Power Automate flow to send immediate Teams notifications when Priority is Critical, and the flow can implement a 4-hour escalation timer. Adding a custom Copilot page provides patient history summarization.

Auditing can be enabled via Power Apps settings. This combination meets all requirements with minimal custom development. Option B is incorrect because field-level security profiles control access to specific fields, not record visibility; they cannot restrict users to only seeing records assigned to them.

Option C is incorrect because sharing permissions are not designed for role-based, record-level access control; they are for ad-hoc sharing. Option D is incorrect because business rules cannot trigger notifications or set timers; they are for simple logic within forms.

Practice this question →
100
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 →
101
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 B, C, and D are correct. Model-driven apps are built on Microsoft Dataverse, have built-in role-based security, and are responsive across devices. Option A is incorrect because model-driven apps do not require custom formulas; they use declarative logic and business rules.

Option E is incorrect because model-driven apps work on both web browsers and mobile devices.

Practice this question →
102
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

By creating a custom security role with record-level security, you can configure sharing so that doctors only see appointments where the Doctor field equals themselves. Option A: Field-level security hides the Doctor field from the form but does not filter records; doctors could still see all appointments. Option C: Creating a team and sharing the app provides app access but does not restrict data visibility; all doctors would see all appointments.

Option D: Hierarchy security is for manager-subordinate relationships, not for filtering by a specific field like Doctor.

Practice this question →
103
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 →
104
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

When the dropdown is cleared, Dropdown.Selected.Value becomes blank. The gallery's Items property uses a filter that references this value, so the filter returns blank (no items), causing the gallery to be empty. Option A is incorrect because AllowEmptySelection set to false would prevent clearing, not cause emptiness after clearing.

Option B is incorrect because the data source does not require a refresh; the issue is the filter logic. Option D is incorrect because OnStart is not involved in the clearing behavior.

Practice this question →
105
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 D and E are correct because AI Builder allows you to add AI models directly to Power Apps, and Copilot integration enables embedding AI-powered copilots. Option A (Power Virtual Agents) is a standalone product for chatbots, not a feature within Power Apps. Option B (Power Automate) is a separate automation product.

Option C (Common Data Model) is a data schema, not an AI-capability feature.

Practice this question →
106
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

The SubmitForm function in Power Apps can include a validation formula in the Items property or via the OnSelect property to check the leave balance before the form is submitted, preventing submission if the balance is insufficient. Option A is wrong because Power BI is for analytics, not validation. Option C is wrong while it can auto-reject, it does not prevent submission, and the requirement is to check before submission.

Option D is wrong because foreign key constraints in Dataverse cannot dynamically check leave balance based on current data.

Practice this question →
107
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

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 →
108
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 →
109
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 →
110
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

The most likely cause is that users do not have permissions to the underlying SharePoint list. When the app is accessed via Teams, the app runs in the context of the user, and SharePoint permissions are enforced. Even though the app works when opened directly from Power Apps (if the user has permissions), adding it to a Teams channel may expose users who lack access to the list.

Option A is incorrect because licenses are per user and not specific to Teams; if users have Power Apps licenses, they can use the app. Option B is incorrect because the app works outside Teams, so the connector is not deprecated. Option D is incorrect because the SharePoint connector does not require a Premium license in Teams.

Practice this question →
111
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

Using delegable functions like Filter and LookUp allows the app to process only the necessary subset of records from Dataverse, avoiding delegation warnings by keeping data operations within the server's capacity. Option A is wrong because increasing the data row limit only changes the number of records fetched, but does not resolve delegation warnings; it may even exacerbate performance issues. Option B is wrong because switching to SharePoint does not inherently fix delegation problems—SharePoint has different delegation limits and may still trigger warnings.

Option C is wrong because avoiding delegable functions would likely make delegation warnings worse, as non-delegable functions force the app to load all data locally.

Practice this question →
112
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

Power Apps automatically formats dates based on the user's browser locale, respecting regional preferences without custom code. Option A is wrong because hardcoding a format ignores the user's locale and requires manual detection. Option C is wrong because the Language function returns locale information, but Power Apps already handles locale automatically; manually setting the format is unnecessary and can override the automatic behavior.

Option D is wrong because using a text input for dates loses the validation and user experience benefits of a date picker and still requires locale-specific formatting.

Practice this question →
113
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

Applying a filter to the gallery data source reduces the number of records loaded into the gallery, which improves performance because fewer records need to be transferred and rendered. Option A (non-delegable query) would actually worsen performance by loading all records locally. Option B (converting to a model-driven app) is a significant redesign and not a simple performance fix.

Option D (increasing gallery height) does not affect the amount of data loaded; it only changes the display area.

Practice this question →
114
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

This is correct. A stage condition that is not being satisfied prevents progression.

Why this answer

Business process flow stages can have conditions that must be satisfied before progressing. If a condition is not met, the user cannot move to the next stage. Option A is incorrect because stages are not locked by administrators in standard configurations.

Option B is incorrect because required fields on the form may not be part of the stage condition; the condition could involve other criteria. Option C is incorrect because security roles control access to records, not the progression within a business process flow.

Practice this question →
115
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 →
116
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 (option A) is the correct solution because it enables external-facing websites that can be accessed by anonymous users without requiring a Microsoft account or license. Canvas apps and model-driven apps require authenticated users with appropriate licenses, and Power Automate is an automation service, not a portal for external submissions.

Practice this question →
117
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 →
118
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

I Builder invoice processing model. AI Builder provides a prebuilt model specifically for extracting information from invoices. Option A (Power Automate with OCR actions) can be used but is not a dedicated AI capability for invoice processing.

Option C (Power Virtual Agents) is for chatbots, and Option D (Copilot Studio) is for custom copilots, neither of which is designed for invoice data extraction.

Practice this question →
119
Multi-Selectmedium

Which THREE data sources support delegation in Power Apps? (Choose three.)

Select 3 answers
A.SharePoint lists
B.SQL Server
C.Excel workbooks
D.Text files
E.Microsoft Dataverse
AnswersA, B, E

Correct. SharePoint lists support delegation through REST API queries executed server-side.

Why this answer

SharePoint lists, SQL Server, and Microsoft Dataverse all support delegation in Power Apps. Since the question asks for three, all three are correct. SharePoint uses its OData endpoint for server-side queries.

SQL Server supports delegation for most operations, though with limitations. Dataverse uses its own query engine for full delegation. Excel workbooks and text files lack server-side processing and do not support delegation.

Exam trap

Candidates may be misled by the 'choose three' instruction and think they need to pick exactly three, but all three listed (SharePoint, SQL Server, Dataverse) are correct. They might incorrectly assume SQL Server does not support delegation or overlook Dataverse as a delegable source.

Practice this question →
120
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, C, and D are correct because Power Apps canvas apps can be embedded in SharePoint using the Power Apps web part, as a custom visual in Power BI reports, and as a tab in Microsoft Teams. Option B is incorrect because embedding in Excel requires a custom add-in, which is not a standard embedding method for canvas apps. Option E is incorrect because Dynamics 365 Sales Hub primarily uses model-driven apps, not embedding canvas apps directly via the standard embedding options.

Practice this question →
121
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

The correct approach is to create a custom connector with API key authentication. This securely stores the API key in the connector definition and allows the canvas app to call the HR system's REST API without exposing the key in the app code. Option A is wrong because a SharePoint list is not a REST API and cannot integrate with an external HR system.

Option B is wrong because although Power Automate can call the API, it does not inherently provide a more secure way to handle the API key than a custom connector; the custom connector is specifically designed for this purpose within Power Apps. Option D is wrong because hardcoding the API key in the app's HTTP action headers exposes the key in the app code, which is not secure.

Practice this question →
122
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 →
123
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

Correct: The command bar designer in the app designer allows adding custom buttons that trigger Power Automate flows.

Why this answer

The command bar designer in the app designer allows adding custom buttons that invoke flows, offering a modern and supported method for customizing the ribbon in model-driven apps. Option B: PCF is used for building custom components, not simple button actions. Option C: Solution Explorer is for classic customizations but is not recommended for modern apps.

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

Practice this question →
124
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 →
125
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

AI Builder provides a prebuilt receipt processing model that can be directly integrated into a Power Apps canvas app. This model allows users to scan a receipt using the camera, automatically extract the amount and date, and populate those values into form fields. Option B is incorrect because while a Power Automate flow could also process the image, it is an unnecessary extra step when AI Builder can be used directly within Power Apps.

Option C is incorrect because the Camera control alone cannot extract text from an image; it requires additional processing like AI Builder. Option D is incorrect because Microsoft Copilot Studio is designed for building chatbots, not for receipt scanning and data extraction.

Exam trap

Candidates may incorrectly think that a Power Automate flow is required to process the receipt image, but AI Builder's receipt processing model can be directly added to Power Apps without additional flows.

Practice this question →
126
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

Power Apps provides capabilities for building custom user interfaces with canvas apps and implementing business process flows through model-driven apps. Option C is correct because model-driven apps include business process flows to guide users through processes. Option D is correct because canvas apps allow custom UI layouts.

Option A is incorrect because creating Power BI dashboards is a Power BI capability, not Power Apps. Option B is incorrect because scheduling automated workflows is handled by Power Automate. Option E is incorrect because training custom AI models is done with AI Builder, which is an add-on, not a core Power Apps capability.

Practice this question →
127
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 is designed for responsive UI across mobile and desktop, making it suitable for both devices. Power Automate can be triggered from the canvas app (e.g., on form submission) to handle the approval workflow. Option B is incorrect because model-driven apps are not as flexible for custom mobile layouts.

Option C is incorrect because AI Builder is not required for receipt processing in this scenario; while it could be used, it is not necessary. Option D is incorrect because Power Pages is for external-facing websites, not internal apps with approval workflows.

Practice this question →
128
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

To improve performance in a canvas app with a SQL Server data source, the most effective design change is to apply delegation-compatible filters on galleries (option D). Delegation allows the server to process the filtering, reducing the amount of data transferred to the app and speeding up screen navigation. Option A is incorrect because replacing SQL Server with SharePoint does not inherently improve delegation; both support delegation, but the root cause is unfiltered data loads.

Option B is wrong because moving logic to App.OnStart preloads data only once, not per screen, and doesn't address data volume during navigation. Option C is incorrect because preloading with a Timer control adds complexity and does not reduce the data transferred; delegation is the proper solution.

Practice this question →
129
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

Dataverse provides offline capability for mobile apps, allowing field technicians to work without connectivity and sync data when reconnected. Option B, Power Apps portals, is for external-facing websites, not offline mobile apps. Option C, Power Apps component framework, is for building custom controls, not offline sync.

Option D, Monitor tool, is for debugging and performance monitoring, not offline functionality.

Practice this question →
130
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 C is correct because business rules are created in the Power Apps portal under the Dataverse table settings. Option A is incorrect because SharePoint lists do not support Power Apps business rules; they rely on SharePoint's own workflows or Power Automate.

Option B is incorrect because Power Automate is for creating automated workflows, not business rules that apply directly to table records in Dataverse. Option D is incorrect because the canvas app's OnStart property handles app initialization logic, not data validation or business rules that should enforce behavior at the data layer.

Practice this question →
131
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 incorrect because the action does not perform an update; it only retrieves data.

Option B is incorrect because the action does not delete a profile. Option C is incorrect because the action does not create a new profile. Therefore, option D is correct.

Practice this question →
132
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

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 →
133
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

The gallery's Items property is set to a static value instead of using TextSearchBox1.Text. In canvas apps, the Items property of a gallery must dynamically reference the text input's Text property to update as the user types. If it's set to a static collection or a value that doesn't change, the gallery won't reflect search input until it's manually refreshed (e.g., by a button).

Option D directly addresses this issue.

Practice this question →
134
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 the amount of data transferred and improving performance. Option D is correct because delegation-compatible functions (e.g., Filter, LookUp) ensure only relevant data is retrieved. Option A is wrong because increasing the data row limit loads more data, worsening performance.

Option B is wrong because switching to Dataverse might help but is not the best approach—it requires migration and may not always be feasible. Option C is wrong because reducing columns only marginally reduces data size, but without delegation, performance issues persist due to large row counts.

Practice this question →
135
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 C (Power Automate) is correct. Option A (Power Virtual Agents) is wrong because it is for chatbots.

Option B (Power Apps) is wrong because it is for building the app interface, not the workflow. Option D (Power BI) is wrong because it is for data visualization.

Practice this question →
136
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 most likely cause is that the relationship between Warehouse and Warehouse Items is not configured correctly or is missing (Option C). Without a proper one-to-many relationship defined, the subgrid cannot retrieve the related records. Option A is incorrect because the lookup field belongs on the Warehouse Items entity, not on the Warehouse form; the subgrid relies on the relationship, not a lookup on the main form.

Option B is incorrect because read permissions would affect all views of the entity, not just the subgrid; given that items are linked, permissions are likely sufficient. Option D is incorrect because subgrids are fully supported on main forms in model-driven apps.

Practice this question →
137
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

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 →
138
MCQmedium

A company wants to build a Power Apps canvas app for field technicians to report equipment issues. The app must allow offline data entry and sync when connectivity is restored. Which feature should the developer enable?

A.Use a Power Automate flow to queue data submissions
B.Configure the app to store data in a SharePoint list
C.Use the Common Data Service (Dataverse) offline sync
D.Enable the 'Offline' feature in the app settings
AnswerD

Power Apps canvas apps have an Offline feature that caches data for offline use and syncs later.

Why this answer

Power Apps mobile app supports offline capabilities by enabling the 'Offline' feature, which allows data to be cached and synced later. Option D is correct. Option A is wrong because Power Automate flows can be triggered online but do not provide offline data caching.

Option B is wrong because SharePoint lists require network connectivity unless using a third-party sync tool. Option C is wrong because the Common Data Service (Microsoft Dataverse) supports offline sync only when the app is explicitly configured for offline use, but the question asks about the feature to enable in the app.

Practice this question →
139
MCQhard

Refer to the exhibit. The JSON describes a Power Apps function. What is the correct usage of this function to return a date 7 days from today?

A.AddDays(7; Today())
B.AddDays(Today(), 7)
C.AddDays(7, Today())
D.AddDays('7', Today())
AnswerB

Correct. Follows the proper Power Fx syntax: AddDays(DateTime, NumberOfDays) with Today() as the date and 7 as the number of days.

Why this answer

The AddDays function in Power Apps (Power Fx) uses the syntax AddDays(DateTime, NumberOfDays). So AddDays(Today(), 7) returns the date 7 days from today. Option A uses a semicolon and has the arguments reversed.

Option C also reverses the arguments (days first, then date). Option D uses a string for the number of days, which is invalid.

Practice this question →
140
MCQhard

An app maker creates a canvas app that uses a Dataverse table with 100,000 records. The app includes a gallery that displays all records. Users experience long load times. What should the app maker do to improve performance without changing the data source?

A.Use delegable functions in the gallery's Items property
B.Switch to a SharePoint list as the data source
C.Increase the data row limit in Dataverse settings
D.Remove all filters from the gallery
AnswerA

Delegable filters push processing to the server, improving performance.

Why this answer

Using delegable functions (such as Filter, Sort, LookUp) in the gallery's Items property allows the query to be processed on the Dataverse server, returning only the necessary subset of records. This significantly reduces the amount of data transferred and improves performance for large datasets like 100,000 records. Option B is incorrect because it involves changing the data source, which is not allowed per the question.

Option C is incorrect because increasing the data row limit in Dataverse settings does not address the delegation issue and may even worsen performance. Option D is incorrect because removing filters would cause the entire dataset to be loaded, making load times even longer.

Practice this question →
141
Multi-Selecthard

Which THREE actions can be performed by using Power Apps component framework (PCF) in a model-driven app?

Select 3 answers
A.Add a client-side script that runs on field change
B.Implement data validation using Dataverse Web API
C.Build a custom input control with complex UI elements
D.Change the layout of the main form using drag and drop
E.Configure a business rule to set field values
.Create a custom visualization that calls an external API
AnswersB, C

PCF controls can interact with Dataverse Web API.

Why this answer

All three correct options utilize Power Apps component framework (PCF) to create custom components. The null option involves building a custom visualization component that can call external APIs, such as REST endpoints, to display data from external sources. Option B is correct because PCF components can use the `context.webAPI` methods to interact with Dataverse Web API for data validation beyond simple client-side scripting.

Option C is correct because PCF allows building custom input controls with complex UI elements like sliders or maps, which are not possible with out-of-the-box form controls. In contrast, options A, D, and E are incorrect: A uses client-side scripts (JavaScript) not PCF, D is done via form editor layout, and E uses business rules, which are separate features.

Exam trap

Candidates often confuse PCF with traditional client-side scripting (option A) or business rules (option E). However, PCF is specifically for building reusable custom components that can include complex UI, external API calls, and Dataverse Web API integration. The trap is that options A, D, and E are valid customization techniques but are not part of PCF.

Practice this question →
142
MCQmedium

A canvas app uses the formula shown in the exhibit to display the name of the most recently created account named 'Contoso'. The formula always shows 'No records found' even though there are accounts named 'Contoso'. What is the likely issue?

A.The SortByColumns function is used incorrectly.
B.The First function cannot be used on a filtered result.
C.The formula is not delegable and returns incomplete data.
D.The column name in the formula uses a space and may be incorrect.
AnswerD

If the actual column is 'AccountName', the filter fails.

Why this answer

The formula references a column name with a space ('Account Name') without using single-quote delimiters. In Power Apps, when a column name contains a space, it must be enclosed in single quotes (e.g., 'Account Name') to be parsed correctly. Without the quotes, Power Apps interprets the space as a separator, causing the lookup to fail and the condition to evaluate as false, always falling back to 'No records found'.

Exam trap

The trap here is that candidates often assume the issue is delegation (Option C) because 'No records found' suggests a data limit, but the real problem is a syntax error in referencing a column with a space, which is a subtle and easily overlooked detail in Power Apps formulas.

How to eliminate wrong answers

Option A is wrong because the SortByColumns function is used correctly here; it sorts the filtered table by the 'Created On' column in descending order, which is syntactically valid and not the cause of the issue. Option B is wrong because the First function can absolutely be used on a filtered result; it returns the first record of a table, and there is no restriction preventing its use after a Filter or SortByColumns. Option C is wrong because the formula is fully delegable—Filter, SortByColumns, and First are all delegable operations in Power Apps for supported data sources like Dataverse or SQL Server—so incomplete data due to delegation limits is not the problem here.

Practice this question →
143
MCQmedium

A model-driven app includes a custom entity 'Project' with a lookup to 'Account'. Users need to see the account name and phone number on the Project form. What is the best way to display these fields?

A.Use a calculated field on the Project entity
B.Create a new main form for the Project entity
C.Add the account fields directly to the Project entity
D.Add a quick view form for the Account entity
AnswerD

Quick view form shows related data inline.

Why this answer

A quick view form displays related data from the lookup entity (Account) directly on the Project form without storing duplicate fields. Option A is incorrect because calculated fields only compute values from existing fields within the same entity, not from related entities. Option B is incorrect because creating a new main form for the Project entity does not automatically show related Account fields.

Option C is incorrect because adding account fields directly to the Project entity would duplicate data and violate normalization.

Practice this question →
144
MCQhard

A Power Apps developer needs to create an app that uses AI Builder to extract information from invoices. The app should allow users to upload an image and then display extracted fields. Which control should be used to capture the image?

A.Camera control
B.Add picture control
C.Image control
D.Button control
AnswerB

Allows users to upload an image.

Why this answer

The Add picture control is the correct choice because it provides functionality for users to either take a photo using their device's camera or upload an existing image file. This is essential for the app's requirement to capture an invoice image and then use AI Builder to extract information from it. Option A (Camera control) is incorrect because it only allows real-time video capture and does not support file upload.

Option C (Image control) is used solely to display images, not to capture them. Option D (Button control) can trigger actions but cannot directly capture images. Therefore, the Add picture control (B) is the only control that enables both photo capture and image upload, meeting the user's needs.

Practice this question →
145
MCQmedium

An organization uses a Canvas app to capture customer feedback. The app writes data to a Dataverse table. Recently, users have been submitting duplicate records due to double-clicking the submit button. What is the best way to prevent duplicates?

A.Set the form to require a unique ID before submission
B.Disable the submit button after the first click using the DisplayMode property
C.Add a business rule to check for duplicates before saving
D.Use a Power Automate flow to delete duplicates after creation
AnswerB

Setting DisplayMode to Disabled immediately after click prevents further submissions.

Why this answer

Disabling the submit button after the first click using the DisplayMode property prevents duplicate submissions by ensuring the button cannot be clicked again. Option A is not feasible because requiring a unique ID before submission would change the data entry process and does not address the double-click issue directly. Option C is incorrect because a business rule in Dataverse runs after submission, so it would not prevent duplicates from the same double-click.

Option D is incorrect because a Power Automate flow to delete duplicates after creation does not prevent the duplicates from being submitted in the first place.

Practice this question →
146
Multi-Selecteasy

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

Select 2 answers
A.Salesforce
B.Microsoft Dataverse
C.Excel Online (Business)
D.SQL Server
E.SharePoint
AnswersB, E

Microsoft Dataverse requires a premium connector.

Why this answer

Microsoft Dataverse and SharePoint are standard connectors that can be used without a premium license. Salesforce requires a premium connector. Excel Online (Business) is also a standard connector, but the correct answers for this question are Dataverse and SharePoint.

SQL Server requires a premium connector.

Practice this question →
147
MCQeasy

A sales manager wants a mobile app to view customer details and open orders. The app should be built quickly without custom code. Which approach should they use?

A.Create a model-driven app from Dataverse
B.Build a canvas app from scratch
C.Use Power BI to create a mobile dashboard
D.Use Power Automate to create a mobile flow
AnswerA

Model-driven apps are generated automatically from data models.

Why this answer

A model-driven app built from Dataverse (formerly Common Data Service) is the best choice because it is generated automatically from the data model, requiring minimal customization and no custom code. This allows the sales manager to quickly create a mobile app that displays customer details and open orders. Canvas apps (B) require manual design and custom code.

Power BI (C) is for analytics dashboards, not interactive apps. Power Automate (D) is for workflow automation, not app creation.

Practice this question →
148
MCQmedium

A manufacturing company uses Power Apps to manage inventory tracking. The current app is a canvas app connected to a SharePoint list. The operations team needs to add a new feature that allows warehouse staff to scan barcodes using a mobile device camera to look up product details. Additionally, the app must work offline in areas with no internet connectivity and sync data when connectivity is restored. The app should also incorporate a Copilot assistant to help staff quickly find product information using natural language queries. The IT department requires that the app be deployed to all warehouse staff without requiring manual installation. Which approach should you take to meet all requirements?

A.Add a Text input control for manual barcode entry, use Power Automate flows to fetch product details, enable offline by storing data locally in collections, and deploy by sending a deep link.
B.Use a Power Fx formula with the Camera control to decode barcodes, enable offline data in SharePoint lists, add a Copilot chat box, and deploy via Microsoft Intune as a required app.
C.Add the Barcode scanner control to the canvas app, enable offline mode in app settings, integrate Copilot using the Copilot control, and deploy the app by sharing it via email link.
D.Add the Barcode scanner control, configure the app for offline use with sync, integrate Copilot using the AI Builder 'Ask a question' component, and deploy the app via Power Apps mobile app with a managed solution and installation policy.
AnswerD

All requirements are met: barcode scanning, offline sync, Copilot, and automatic deployment.

Why this answer

It combines the Barcode scanner control for camera-based scanning, offline capabilities via Power Apps mobile app with offline sync, Copilot in Power Apps for natural language queries, and automatic deployment using a managed solution and Power Apps mobile app installation policy. Option A fails to address offline and Copilot requirements. Option B uses Power Fx formula, which is not a native barcode scanning method.

Option C uses Power Automate flows, which are not suitable for real-time offline scanning.

Practice this question →
149
MCQeasy

A company wants to build a custom app that allows employees to submit expense reports from their mobile devices. The app must be easy to customize and deploy without writing code. Which type of Power App should they use?

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

Correct: Canvas apps enable code-free, custom mobile app creation.

Why this answer

Canvas apps allow building custom, code-free apps that can run on mobile devices. Model-driven apps are more data-centric and require more configuration, while Power Pages is for external websites and Power Automate is for workflows.

Practice this question →
150
MCQhard

A developer is trying to create a business process flow (BPF) for the 'Opportunity' table in a model-driven app. When activating the BPF, the developer receives the error shown in the exhibit. What is the most likely cause?

A.The developer does not have sufficient security role permissions to activate BPFs.
B.The BPF has no stages defined.
C.The BPF is trying to use a table that is not enabled for business process flows.
D.The Opportunity table does not exist.
AnswerC

Only certain tables can be used in BPFs; Opportunity is enabled by default, but if it's a custom table, it might not be enabled.

Why this answer

The error shown in the exhibit indicates that the business process flow (BPF) references a table that is not enabled for business process flows. In Power Apps, only tables that have the 'Business process flows' option enabled in their table settings can be used as the primary entity for a BPF. The 'Opportunity' table is a standard table that is enabled by default, but if it has been disabled or the BPF is referencing a custom table that lacks this setting, activation will fail with this error.

Option C correctly identifies this root cause.

Exam trap

The trap here is that candidates often assume the error is due to missing permissions (Option A) or an incomplete BPF (Option B), but the exhibit's error message specifically references the table not being enabled for business process flows, which is a distinct configuration requirement in Dataverse.

How to eliminate wrong answers

Option A is wrong because security role permissions affect the ability to create or activate BPFs only if the user lacks 'Activate Business Process Flow' privilege, but the error message in the exhibit specifically points to a table configuration issue, not a permissions error. Option B is wrong because a BPF with no stages defined would still activate (though it would be non-functional) and would not produce this specific error; the error is about table enablement, not stage count. Option D is wrong because the 'Opportunity' table is a standard table in Dataverse and always exists; if it didn't, the developer would receive a 'table not found' error during BPF creation, not during activation.

Practice this question →
← PreviousPage 2 of 4 · 238 questions totalNext →

Ready to test yourself?

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

Start 20-question session