Courseiva

CCNA Demonstrate the capabilities of Power Apps Questions

31 of 256 questions · Page 4/4 · Demonstrate the capabilities of Power Apps · Answers revealed

Practice these questionsDomain overviewAll questions
226
MCQhard

A Power Apps model-driven app includes a business process flow (BPF) for order processing. After editing the BPF, some users see the old version while others see the new version. What is the most likely reason?

A.Some users have not refreshed their app session
B.Users have different security roles that show different BPF stages
C.The BPF was published to only a subset of users
D.The BPF was not activated after editing
AnswerA

Correct: BPF changes are cached; refreshing the app loads the new version.

Why this answer

BPF changes are cached and refreshed when users reload the app. Admin vs. user views can differ due to security roles, but the inconsistency is due to caching.

Practice this question →
227
MCQmedium

Refer to the exhibit. The JSON defines a business process flow for expense reports in a model-driven app. How many stages must be completed before the process is considered complete?

A.Only the Approval stage.
B.All three stages (including a hidden stage).
C.Both stages (Submit and Approval).
D.Only the Submit stage.
AnswerC

The business process flow requires all stages to be completed.

Why this answer

Both stages 'Submit' and 'Approval' must be completed because the process flow includes them. Option C is correct. Option A is wrong because the process has two stages.

Option B is wrong because the Approval stage also needs completion. Option D is wrong because the process does not have three stages.

Practice this question →
228
Multi-Selectmedium

Which TWO components are required to create a model-driven app in Power Apps? (Choose two.)

Select 2 answers
A.AI Builder model
B.Dataverse table
C.Power Automate flow
D.Power BI dashboard
E.Form
AnswersB, E

Model-driven apps require Dataverse tables to store data.

Why this answer

Dataverse tables (Option B) are the fundamental data storage structure for model-driven apps. Every model-driven app must be built on top of at least one Dataverse table to provide the data schema, relationships, and security context that the app's views, forms, and dashboards rely on. Without a Dataverse table, the app has no data source to interact with.

Exam trap

The trap here is that candidates often confuse 'required components' with 'commonly used components'—they may think Power Automate flows or Power BI dashboards are mandatory because they are frequently integrated, but the exam specifically tests the minimal structural prerequisites (Dataverse table and a form).

Practice this question →
229
MCQeasy

An app maker wants to add a button in a model-driven app that, when clicked, creates a new record of a custom entity called 'Inspection'. The maker should use which feature?

A.Custom command on the command bar
B.Power Automate flow
C.Business rule
D.Form editor
AnswerA

Custom commands allow adding buttons that run actions.

Why this answer

Option C is correct because a custom command can be added to the command bar to perform actions like creating a record. Option A is wrong because business rules are for validation and show/hide logic. Option B is wrong because the form editor is for form layout, not buttons.

Option D is wrong because Power Automate can be triggered from a button but is not the direct feature for adding a button.

Practice this question →
230
MCQmedium

Your company is migrating a legacy paper-based expense report process to Power Apps. Employees will submit expenses via a Canvas app. The app must integrate with the corporate travel system to fetch trip details (e.g., dates, destination). The travel system exposes a REST API with OAuth 2.0 authentication. Finance requires that all expense reports over $1,000 receive a second-level approval from a manager. Additionally, the app must be available on mobile devices. Which combination of technologies should you use?

A.Canvas app with custom connector to travel API, and Power Automate for conditional approval
B.Canvas app with standard connector to travel API and Power Automate
C.Canvas app with AI Builder to extract trip details and Power Automate for approval
D.Model-driven app with Dataverse and Power Automate for approval
AnswerA

Correct: Canvas app provides mobile UI, custom connector integrates API, Power Automate handles approval logic.

Why this answer

Option A is correct because a Canvas app can connect via custom connector to the REST API, and Power Automate can handle conditional approval routing. Option B is wrong because model-driven apps are not ideal for custom mobile UI. Option C is wrong because AI Builder does not handle approvals.

Option D is wrong because the travel system API needs a custom connector, not a standard one.

Practice this question →
231
Multi-Selectmedium

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

Select 2 answers
A.Build interactive dashboards with visualizations.
B.Create a chatbot to answer common questions.
C.Automate a business process to send email notifications.
D.Create a mobile app to capture customer feedback.
E.Build a custom portal for external users to submit support tickets.
AnswersD, E

Power Apps creates custom mobile and web apps.

Why this answer

Power Apps is used to build custom apps. Option A and D are correct; B is Power Automate, C is Power BI, E is Power Virtual Agents.

Practice this question →
232
Multi-Selectmedium

Which THREE are valid data sources for canvas apps in Power Apps?

Select 3 answers
A.SQL Server database
B.Local Excel file
C.SharePoint list
D.Microsoft Dataverse
E.Oracle Database
AnswersA, C, D

SQL Server is supported via the SQL Server connector.

Why this answer

Correct: A, C, and E. SharePoint (A), SQL Server (C), and Microsoft Dataverse (E) are all supported. B is wrong because Excel workbooks are not supported directly as a data source (must be in OneDrive or SharePoint).

D is wrong because Oracle Database is not a built-in connector.

Practice this question →
233
MCQmedium

Refer to the exhibit. The following JSON shows a Power Apps component (canvas app) manifest snippet: { "properties": { "dataSources": [ { "name": "SalesData", "type": "Microsoft Dataverse", "entity": "accounts" } ], "screens": [ { "name": "MainScreen", "controls": [ { "name": "AccountGallery", "type": "Gallery", "items": "Filter(SalesData, status = 'Active')" } ] } ] } } What is the data source for the gallery named AccountGallery?

A.The filtered Dataverse Accounts data source
B.A SQL Server table named Accounts
C.A SharePoint list named SalesData
D.The raw Dataverse Accounts entity
AnswerA

The Items property applies a filter to the data source.

Why this answer

Option B is correct because the gallery's Items property uses Filter(SalesData, ...), and SalesData is defined as a Dataverse entity 'accounts'. Option A is wrong because the gallery uses a filtered set, not the raw entity. Option C is wrong because the data source is Dataverse, not SharePoint.

Option D is wrong because SQL Server is not referenced.

Practice this question →
234
MCQhard

A model-driven app uses a custom button that runs a Power Automate flow to send an email notification. Users report that the button sometimes does not appear on the command bar. The app maker checks the form customizations and confirms the button is configured correctly. What is the most likely cause?

A.The user's browser does not support the Power Apps client.
B.The app is opened in the phone form factor, and the button is only shown on web.
C.The custom button is configured with visibility rules that hide it for certain security roles.
D.The Power Automate flow is disabled or not shared with the user.
AnswerC

Command bar customization allows role-based visibility; the user may be in a restricted role.

Why this answer

Option B is correct because custom commands can be hidden based on security roles using modern command bar customization. Option A is wrong because browser compatibility does not affect button visibility for modern apps. Option C is wrong because flow permissions affect execution, not button visibility.

Option D is wrong because form factors are not the issue if the button is configured for all form factors.

Practice this question →
235
MCQhard

Your organization is a multi-national corporation using Microsoft Power Platform. The compliance team requires that all Power Apps apps be auditable: every data modification (create, update, delete) must be logged with the user, timestamp, and old/new values. Additionally, the app must enforce that only users from the same business unit can view each other's records. The app uses Dataverse as the data source. You need to design the solution. Which approach should you take?

A.Enable Dataverse auditing for the entity and configure business unit security to restrict access
B.Enable Dataverse auditing and use hierarchy security with business units
C.Use Power Automate to create custom logs and use field-level security to restrict visibility
D.Create a separate audit table and use Power Automate to write logs, and use role-based security
AnswerA

Correct: Dataverse auditing logs all changes, and business unit security limits record visibility.

Why this answer

Option D is correct because Dataverse auditing logs changes, and business unit security can restrict record visibility. Option A is wrong because Power Automate flows can be used for logging but are not native; auditing is built-in. Option B is wrong because Canvas apps cannot enforce business unit security directly; that is a Dataverse feature.

Option C is wrong because Power Automate flows for logging are possible but not required; auditing is simpler.

Practice this question →
236
Multi-Selecteasy

Which TWO data sources can be directly connected to a canvas app without using an on-premises data gateway?

Select 2 answers
A.SQL Server on-premises
B.SAP ERP on-premises
C.SharePoint Online
D.Oracle database on-premises
E.Microsoft Dataverse
AnswersC, E

Cloud-based, no gateway needed.

Why this answer

Option A is correct because SharePoint is a cloud data source. Option B is correct because Dataverse is cloud-based. Option C is wrong because SQL Server on-premises requires a gateway.

Option D is wrong because Oracle on-premises requires a gateway. Option E is wrong because SAP on-premises requires a gateway.

Practice this question →
237
Multi-Selecteasy

Northwind Traders uses Power Apps to build a simple help desk ticketing system. The app uses Microsoft Dataverse as the data source. The help desk team wants to ensure that only members of the 'Help Desk Agents' security role can edit tickets, while all employees can view tickets. The app is a model-driven app. The administrator needs to configure the appropriate security. Which two actions should the administrator take? (Choose two.)

Select 2 answers
A.Create a new Dataverse table for ticket views
B.Create a business rule to restrict editing to certain users
C.Assign the 'Help Desk Agents' security role to the help desk team
D.Share the app with all employees using the Power Apps sharing feature
E.Ensure the 'Employees' security role has read privilege on the ticket table
AnswersC, E

This role should have write privileges on the ticket table.

Why this answer

Option A is correct because assigning the 'Help Desk Agents' role to agents grants them edit permissions. Option C is correct because granting read privilege to the 'Employees' role allows view access. Option B is wrong because sharing the app does not control data permissions.

Option D is wrong because business rules do not control security. Option E is wrong because creating a new table is unnecessary.

Practice this question →
238
Multi-Selecteasy

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

Select 2 answers
A.Power Automate
B.Portal app
C.Web app
D.Canvas app
E.Model-driven app
AnswersD, E

Canvas apps allow free-form design.

Why this answer

Canvas apps allow you to design a custom user interface by dragging and dropping elements onto a blank canvas, giving you full control over the layout and appearance. They connect to a wide range of data sources, such as SharePoint, Excel, or SQL Server, and are ideal for building task-specific or role-specific applications quickly.

Exam trap

The trap here is that candidates may confuse the broader Power Platform components (like Power Automate) or generic app categories (like web apps) with the two specific app types—canvas and model-driven—that Microsoft officially recognizes in Power Apps.

Practice this question →
239
MCQmedium

A company is building a canvas app to track inventory. The app needs to display the current stock level from a SharePoint list and allow users to update quantities via a form. Which connector should be used to read and write data?

A.Power Automate connector
B.SharePoint connector
C.Microsoft Dataverse connector
D.Microsoft Teams connector
AnswerB

SharePoint connector allows reading and writing to SharePoint lists.

Why this answer

The correct answer is the SharePoint connector, which provides read/write access to SharePoint lists. The Teams connector is for messaging, Power Automate is for workflows, and Microsoft Dataverse is a different data source.

Practice this question →
240
MCQhard

You are developing a canvas app that uses a SQL Server database as a data source. The app needs to display a list of orders and allow users to filter by date range. The SQL table has millions of rows. To ensure optimal performance, which approach should you use? A) Use the 'Filter' function in Power Apps to filter the data on the client side. B) Use a SQL view that filters data server-side and call it via the SQL connector. C) Use Power Automate to retrieve data and pass it to the app. D) Use the 'Search' function on the gallery.

A.Use Power Automate to retrieve data and pass it to the app.
B.Use the 'Filter' function in Power Apps to filter the data on the client side.
C.Use a SQL view that filters data server-side and call it via the SQL connector.
D.Use the 'Search' function on the gallery.
AnswerC

Server-side filtering reduces data transfer and improves performance.

Why this answer

Option B is correct because filtering at the SQL server level reduces data transfer. Option A: Filter function retrieves all data and filters client-side, causing performance issues. Option C: Power Automate adds latency.

Option D: Search function also works on client-side data.

Practice this question →
241
MCQhard

A developer is troubleshooting a canvas app that uses a SharePoint list as a data source. The app works for some users but fails for others with the error 'Access denied.' All users have read access to the SharePoint list. What could be the issue?

A.The users do not have permissions to the SharePoint list
B.The SharePoint list is set to private
C.The users do not have Power Apps licenses
D.The app is in a different environment than the users
AnswerA

Power Apps inherits SharePoint permissions; users need read access to the list.

Why this answer

Option D is correct because Power Apps uses the user's own permissions to access SharePoint. Even if the app is shared, the underlying data permissions must be correct. Option A is wrong because licenses are not the issue here.

Option B is wrong because the user environment is the same for all. Option C is wrong because the list is not set to private if users have read access.

Practice this question →
242
MCQeasy

A business analyst creates a model-driven app to manage customer service cases. The app includes a custom form with a field called 'Priority' that has three options: Low, Medium, High. The analyst wants to ensure that only users in the 'Service Managers' security role can change the priority of a case. What should the analyst do?

A.Configure a field security profile for the Priority field and grant read-only access to other roles.
B.Edit the Service Manager security role to include write privileges for the Case entity.
C.Set the Priority field to 'Read-Only' in the form editor.
D.Create a business rule to hide the field when the user is not a Service Manager.
AnswerA

Field security profiles control read and write access per field per role.

Why this answer

Option B is correct because field-level security profiles allow restricting write access to specific fields based on user roles. Option A is wrong because business rules apply to all users. Option C is wrong because the security role itself controls entity-level access, not field-level.

Option D is wrong because the custom field's properties do not include role-based restrictions.

Practice this question →
243
MCQeasy

An app maker creates a canvas app that uses Microsoft Dataverse as the data source. The app includes a gallery that displays all accounts. The app maker wants to filter the gallery to show only accounts where the 'City' field equals 'Seattle'. Which formula should be used in the Items property of the gallery?

A.Accounts(City = "Seattle")
B.Filter(Accounts, City = "Seattle")
C.LookUp(Accounts, City = "Seattle")
D.Search(Accounts, "Seattle", "City")
AnswerB

Filter returns all records that satisfy the condition.

Why this answer

Option C is correct because the Filter function filters records based on a condition. Option A is wrong because LookUp returns a single record, not a collection. Option B is wrong because Search is for string matching across multiple fields.

Option D is wrong because the syntax is incorrect: the condition should be City = "Seattle".

Practice this question →
244
MCQhard

Refer to the exhibit. An administrator wants to enforce a mobile app management policy that prevents screen capture in Power Apps. Which Microsoft service should the administrator use to deploy this policy?

A.Microsoft Entra ID
B.Microsoft Defender XDR
C.Microsoft Intune
D.Microsoft Purview
AnswerC

Intune manages mobile app protection policies.

Why this answer

Option B is correct because Microsoft Intune can deploy app protection policies to Power Apps mobile app. Option A is wrong because Microsoft Defender XDR is for threat protection. Option C is wrong because Microsoft Purview is for data governance.

Option D is wrong because Microsoft Entra ID is for identity.

Practice this question →
245
MCQeasy

A user reports that a canvas app is loading slowly. The app connects to a large SharePoint list with over 10,000 items. Which change would most improve performance?

A.Increase the delegation limit to 10,000.
B.Apply a delegable filter on the data source to limit records returned.
C.Add more screens to distribute the data.
D.Disable offline mode.
AnswerB

Filtering at the data source reduces the data transferred and improves performance.

Why this answer

Using a filter on the data source reduces the number of records retrieved, improving performance. Option A is wrong because adding more screens doesn't help. Option B is wrong because disabling offline doesn't affect loading speed.

Option D is wrong because increasing delegation limit doesn't improve performance when the query is not delegable.

Practice this question →
246
MCQeasy

A company wants to create a custom app to track inventory in their warehouse. The app needs to integrate with their existing SQL Server database and allow users to scan barcodes to update stock levels. Which type of Power Apps should they use?

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

Canvas apps provide custom UI and device integration like barcode scanning.

Why this answer

Option A is correct because Canvas apps allow custom integration with SQL Server and barcode scanning via device capabilities. Model-driven apps are more for data management but not as flexible for custom scanning. Power Pages is for external websites, not scanning.

Power Automate is for workflows, not app building.

Practice this question →
247
MCQeasy

A sales team needs an app to track customer interactions. The app should display a list of accounts, and when an account is selected, show related opportunities and contacts. Which type of app is best suited?

A.Canvas app
B.Power BI dashboard
C.Chatbot in Power Virtual Agents
D.Model-driven app
AnswerD

Model-driven apps automatically handle one-to-many relationships between tables.

Why this answer

Option C is correct because model-driven apps have built-in relationships and navigation. Option A is wrong because canvas apps require manual coding of relationships. Option B is wrong because Power BI is for analytics.

Option D is wrong because Power Virtual Agents is for chatbots.

Practice this question →
248
MCQhard

A Power Apps canvas app that uses Dataverse is being migrated from a development environment to a production environment. After migration, the app fails to load data. The developer checks the connection and finds that the Dataverse connector is pointing to the development environment. What should the developer do?

A.Re-import the solution into the production environment
B.Update the connection reference in the app to use production Dataverse
C.Delete the app and recreate it in production
D.Modify the environment variable values for the connection
AnswerB

Connection references must be updated to the target environment.

Why this answer

The app's connection references must be updated to point to the production Dataverse environment. Option B is correct. Option A is wrong because re-importing the solution alone does not update connection references.

Option C is wrong because the app is already in production. Option D is wrong because changing environment variables is not the direct fix for hard-coded connections.

Practice this question →
249
MCQeasy

You are creating a canvas app for a small business to manage customer orders. The orders are stored in an Excel file on OneDrive for Business. The app needs to display a list of orders and allow users to add new orders. Which data source should you use? A) Import Excel data into Dataverse. B) Connect to the Excel file stored on OneDrive using the OneDrive for Business connector. C) Create a SharePoint list and import the Excel data. D) Use the Excel connector with a SharePoint document library.

A.Import Excel data into Dataverse.
B.Connect to the Excel file stored on OneDrive using the OneDrive for Business connector.
C.Use the Excel connector with a SharePoint document library.
D.Create a SharePoint list and import the Excel data.
AnswerB

The OneDrive for Business connector allows direct read/write to Excel files.

Why this answer

Option B is correct because the OneDrive for Business connector allows direct connection to Excel files. Option A: Importing to Dataverse is unnecessary for a small business. Option C: Creating a SharePoint list is extra work.

Option D: Excel connector requires SharePoint, not OneDrive.

Practice this question →
250
MCQmedium

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

A.Remove the datasource permissions and let the app handle all security.
B.Set up Dataverse security roles and assign them to users.
C.Use the Filter function with User().Email or User().FullName.
D.Store the user ID in a global variable and use it in queries.
AnswerC

This leverages Power Apps built-in user context to filter records.

Why this answer

Using the Filter function with the User() function retrieves only relevant records. Option A is correct. Option B is wrong because security roles apply at the data source level but may require additional configuration.

Option C is wrong because it removes the ability to see own records. Option D is wrong because storing User ID in the app is not secure.

Practice this question →
251
MCQmedium

Refer to the exhibit. You are configuring a conditional access policy in Microsoft Entra ID to restrict access to Microsoft 365 services. The policy uses the 'approved client app' condition with the above JSON. What will this policy enforce?

A.Block access from Power Apps and Power Automate.
B.Allow access from any app but require compliance.
C.Only allow access from Power Apps and Power Automate apps.
D.Require multi-factor authentication for Power Apps and Power Automate.
AnswerC

The policy restricts access to only the listed apps.

Why this answer

The JSON lists approved apps: Power Apps and Power Automate. The policy will block access from other apps. Option B is correct.

Option A is wrong because it does not require MFA. Option C is wrong because there is no block for Power Apps. Option D is wrong because it targets all apps.

Practice this question →
252
MCQeasy

A company wants to use Power Apps to digitize a paper-based approval process. Managers will review and approve requests through a mobile-friendly interface. Which feature should be used to notify managers of pending approvals?

A.Power Automate flow triggered on record creation
B.Power BI dashboard
C.Power Pages site
D.AI Builder object detection
AnswerA

Power Automate can send email or push notifications when a new approval request is created.

Why this answer

Option A is correct because Power Automate can send notifications when a record is created or updated. Option B is wrong because Power BI is for analytics. Option C is wrong because AI Builder is for AI models.

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

Practice this question →
253
MCQeasy

Refer to the exhibit. The JSON describes a Power Apps function. Which call to this function will return a table of records where the 'Status' column equals 'Active'?

A.Filter(Accounts, 'Active')
B.Filter(Accounts, Status = 'Active')
C.Filter('Active', Accounts)
D.Filter(Status = 'Active', Accounts)
AnswerB

Correct syntax: source then boolean formula.

Why this answer

Option A is correct because the Filter function takes the source first, then the formula. Option B has the parameters reversed. Option C uses incorrect syntax.

Option D is not a valid call.

Practice this question →
254
MCQhard

A company has a canvas app that uses a SharePoint list as its data source. The app works fine for most users but a few users report that they cannot submit new items. They receive a generic 'Access denied' error. What is the most likely cause?

A.The connection reference is not shared with the users.
B.The SharePoint list has exceeded its item limit.
C.The users lack write permissions on the SharePoint list.
D.The app is shared with 'Can edit' permission but not 'Can view'.
AnswerC

Power Apps uses the user's credentials to access SharePoint; they need write permission on the list.

Why this answer

The 'Access denied' error when submitting new items in a canvas app connected to a SharePoint list indicates that the user lacks write permissions on the underlying data source. Even though the app is shared with the user, the SharePoint list itself enforces its own permission model. Without Contribute or Edit permissions on the list, the user cannot create new items, resulting in the generic access denied error.

Exam trap

The trap here is that candidates often confuse app-level sharing permissions (Can view/Can edit) with data source permissions, assuming that sharing the app with 'Can edit' automatically grants write access to the underlying SharePoint list.

How to eliminate wrong answers

Option A is wrong because connection references are used in solution packaging and environment lifecycle management, not for runtime data access; sharing the app with users automatically shares the underlying connector as long as the user has appropriate permissions on the data source. Option B is wrong because SharePoint list item limits (default 5,000 items in a view, 30 million total) cause performance issues or throttling, not a generic 'Access denied' error; exceeding the limit would produce a different error message related to list view threshold or item count. Option D is wrong because 'Can edit' permission on the app actually grants the user the ability to modify the app itself, not to submit data; the error is about data submission, not app editing, and 'Can view' would be even more restrictive but still unrelated to the data source permissions.

Practice this question →
255
MCQmedium

An administrator needs to ensure that a Canvas app can only be used by licensed users within the organization. What should they configure?

A.Remove the app from the Microsoft Teams app catalog
B.Publish the app to everyone in the tenant
C.Set the app to 'Require user license' in the app settings
D.Share the app with specific security groups that contain licensed users
AnswerD

Sharing with security groups restricts access to group members.

Why this answer

Option C is correct because sharing the app with security groups ensures only licensed members can access it. Option A is not a licensing feature. Option B is for sharing outside the organization.

Option D would block all users.

Practice this question →
256
MCQeasy

A business analyst wants to create a Power App without writing code. They need to build a mobile-friendly form for inventory tracking. Which approach should they use?

A.Create a canvas app from a template or blank, using drag-and-drop controls
B.Create a model-driven app using Dataverse
C.Create a Power Apps portal
D.Customize a SharePoint list form
AnswerA

Canvas apps are designed for no-code custom interfaces.

Why this answer

Option C is correct because canvas apps allow drag-and-drop design without code. Option A is wrong because model-driven apps require some configuration but are not as flexible for custom forms. Option B is wrong because portals are for external users.

Option D is wrong because SharePoint customizations are limited and not mobile-friendly by default.

Practice this question →
← PreviousPage 4 of 4 · 256 questions total

Ready to test yourself?

Try a timed practice session using only Demonstrate the capabilities of Power Apps questions.

Start 20-question session