CCNA Demonstrate the capabilities of Power Apps Questions — Page 3 of 3

151

Multi-Selectmedium

A team is building a canvas app that must allow users to work with data from multiple sources. The app will use Microsoft Dataverse as the primary data source and also needs to display data from an on-premises SQL Server database. Which two components are required to connect the canvas app to the on-premises SQL Server data? (Choose two.)

Select 2 answers

A.A virtual table created in Microsoft Dataverse for the SQL Server data.

B.A Power Automate flow that triggers on app load.

C.An Azure Logic Apps workflow to synchronize the data.

D.An on-premises data gateway installed and configured.

E.The SQL Server connector added to the canvas app.

AnswersD, E

An on-premises data gateway is required to securely connect cloud services like Power Apps to on-premises data sources such as SQL Server. It acts as a bridge, allowing the canvas app to query and write data without exposing the database directly to the internet.

Why this answer

To connect a canvas app to an on-premises SQL Server database, the maker must install and configure an on-premises data gateway to bridge the cloud and local network, and then add the SQL Server connector to the app. These two components together enable secure, direct data access from the canvas app without additional workflows or virtual tables.

Exam trap

The trap here is thinking that a Power Automate flow or virtual table is needed to access on-premises data, when the gateway and connector alone are sufficient for canvas apps.

Practice this question →

152

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

The SharePoint connector provides native read and write operations against SharePoint lists, so it satisfies the requirement to display current stock levels and update quantities through a form. It authenticates via Microsoft Entra ID and exposes list items directly, avoiding custom API development.

Why this answer

The SharePoint connector is the correct choice because it provides native, bidirectional access to SharePoint lists, which are the data source described in the scenario. It supports both reading current stock levels (via Get items) and writing updates (via Create item or Update item) directly from a canvas app. Since the inventory data already resides in a SharePoint list, this connector is the most direct and appropriate integration point.

Other connectors either serve different services or are not designed for direct data manipulation in this context.

Exam trap

PL-900 often tests the confusion between data sources and automation tools, leading candidates to pick Power Automate when direct data access is needed, or to overcomplicate by choosing Dataverse when the data is already in SharePoint.

How to eliminate wrong answers

Option A is wrong because Power Automate is a workflow automation service, not a data connector for canvas apps; while you can trigger flows from an app, it is not used to directly read/write SharePoint data in the app's data layer. Option C is wrong because Microsoft Dataverse is a different data storage platform; while it can store inventory data, the scenario explicitly states the data is in a SharePoint list, so using Dataverse would require data migration or duplication. Option D is wrong because Microsoft Teams is a collaboration hub, not a data source for inventory records; it lacks native capabilities to read/write SharePoint list items directly.

Practice this question →

153

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 only records meeting the predicate, so the gallery shows accounts whose City column equals Seattle. The delegate-friendly syntax matches Dataverse column names directly, satisfying the requirement to restrict the gallery's Items to Seattle accounts rather than all accounts.

Why this answer

The Filter function in Power Apps returns a table of records that satisfy a Boolean condition, which is exactly what the gallery's Items property requires. Filter(Accounts, City = "Seattle") evaluates each record in the Accounts table and returns only those where the City column equals 'Seattle'. This is the canonical delegation-friendly pattern for Dataverse-backed galleries.

Exam trap

PL-900 often tests the confusion between Filter (returns a table), LookUp (returns one record), and Search (substring match) — candidates pick LookUp or Search because they sound like filtering, but only Filter returns the table shape a gallery requires.

How to eliminate wrong answers

Option A is wrong because Accounts(City = "Seattle") is not valid Power Apps syntax — tables are not called like functions with filter predicates. Option C is wrong because LookUp returns a single record (the first match), not a table, so the gallery would display only one account. Option D is wrong because Search performs a substring/text match across specified columns and does not support exact equality comparisons like City = "Seattle".

Practice this question →

154

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

Microsoft Intune app protection policies enforce mobile app management restrictions such as blocking screen capture on enrolled or unenrolled devices. Power Apps platform settings and Dataverse security roles govern data access, not device-level app behaviour, so Intune is required here.

Why this answer

Microsoft Intune is the mobile device and application management (MDM/MAM) service in the Microsoft 365 stack, and it is where app protection policies are configured. An Intune app protection policy can enforce data-loss-prevention controls such as blocking screen capture, preventing copy/paste to unmanaged apps, and requiring a PIN, specifically for mobile apps like Power Apps on iOS and Android. This is the correct service to deploy the policy described.

Exam trap

PL-900 often tests the confusion between Intune (device/app management) and Purview (data compliance) — candidates pick Purview for anything involving 'policy' or 'protection' even when the control is a mobile app runtime restriction.

How to eliminate wrong answers

Option A is wrong because Microsoft Entra ID handles identity, authentication, conditional access, and directory services — it does not manage mobile app policies such as screen-capture blocking. Option B is wrong because Microsoft Defender XDR is a threat detection and response suite (Defender for Endpoint, Identity, Office 365, Cloud Apps) and does not deploy app protection policies. Option D is wrong because Microsoft Purview focuses on data governance, compliance, and information protection (sensitivity labels, DLP for data at rest/in motion), not on mobile app runtime controls like screen capture prevention.

Practice this question →

155

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

Delegation pushes filtering to SharePoint rather than pulling all 10,000+ items to the client, so only matching records cross the network. This directly addresses the large-list constraint causing slow loading, whereas non-delegable filters retrieve the full dataset first and process it locally.

Why this answer

The correct answer is B because delegation is the key to performance with large data sources. When a canvas app connects to SharePoint, operations that can be translated into a query (delegable) are processed server-side, returning only the necessary records. Applying a delegable filter (e.g., using '=' or 'StartsWith' on indexed columns) reduces the amount of data transferred and processed by the app, directly improving load time.

Non-delegable operations force Power Apps to fetch the first 500 (or up to 2000) records and process them locally, which is slow and may miss data.

Exam trap

PL-900 often tests the misconception that increasing the delegation limit solves performance issues, when in fact it only masks the problem by allowing more records to be processed locally, which can degrade performance further.

How to eliminate wrong answers

Option A is wrong because increasing the delegation limit does not make non-delegable queries efficient; it only allows more records to be retrieved and processed locally, which can worsen performance and memory usage. Option C is wrong because adding more screens does not reduce the data load; it may even increase app size and complexity, slowing down initial load. Option D is wrong because disabling offline mode does not affect the performance of data retrieval from SharePoint; offline mode is about caching for offline use, not about query efficiency.

Practice this question →

156

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 give pixel-level control over the user interface, so barcode scanning can be wired to the device camera and connected directly to SQL Server through a data connector. This satisfies the requirement for a custom inventory interface with live stock updates.

Why this answer

(Canvas app) 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 →

157

Multi-Selectmedium

A maker is building a canvas app that will be used by employees to submit expense reports. The app must allow users to enter multiple line items for each expense report, and the maker wants to store the data in Microsoft Dataverse. The maker needs to choose appropriate controls for the app. Which two controls should the maker use to allow users to enter and manage multiple line items? (Choose two.)

Select 2 answers

A.Gallery control

B.Form control in Edit mode

C.Text input control

D.Data table control

E.Timer control

AnswersA, D

A Gallery control is used to display and manage multiple records, such as expense line items. It can be bound to a collection or a Dataverse table and allows users to view, select, and edit multiple items. For expense reports, a gallery can show each line item and provide a way to add, edit, or remove items, making it ideal for managing multiple entries.

Why this answer

To manage multiple line items, the maker should use a Gallery control or a Data table control. Both allow users to view and edit multiple records in a structured way. A gallery provides flexibility in layout and can contain various controls for each item, while a data table offers a compact grid for inline editing.

These controls enable efficient entry and management of multiple expense line items within the canvas app.

Exam trap

The trap here is thinking that a Form control can handle multiple line items, but it is designed for a single record and cannot natively display or edit a collection of items.

Practice this question →

158

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 generate UI directly from the Dataverse data model, so defining relationships between accounts, opportunities and contacts produces the list-and-related-records navigation automatically, with no manual screen wiring. This satisfies the requirement to show related opportunities and contacts when an account is selected.

Why this answer

Model-driven apps are ideal for complex, data-centric scenarios where the app is built on top of Microsoft Dataverse. They automatically generate a UI based on the data model, including relationships between entities like Account, Opportunity, and Contact. When an account is selected, the app can display related records through built-in navigation and subgrids, exactly as required.

This makes model-driven apps the best fit for tracking customer interactions with linked entities.

Exam trap

PL-900 often tests the distinction between canvas apps (for custom UI and task-specific apps) and model-driven apps (for data-centric, relationship-based apps), so candidates may incorrectly choose canvas apps when the requirement emphasizes automatic relationship navigation.

How to eliminate wrong answers

Option A is wrong because canvas apps are designed for pixel-perfect, task-specific interfaces and do not automatically generate UI from data relationships; building the required linked views would require manual configuration. Option B is wrong because Power BI is a business analytics service for visualizing data, not for creating interactive data-entry or relationship-navigation apps. Option C is wrong because Power Virtual Agents is used to build chatbots for conversational interactions, not for displaying and navigating relational business data.

Practice this question →

159

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

Filter returns a table of records matching the condition, and Status = 'Active' selects only rows where the Status column equals Active. This satisfies the requirement to return a table filtered by that column value.

Why this answer

The Filter function in Power Apps takes a data source as the first argument and a logical expression as the second argument. The correct syntax is Filter(Accounts, Status = 'Active'), which returns records where the Status column equals 'Active'.

Exam trap

PL-900 often tests the correct argument order and syntax of the Filter function, causing candidates to reverse the arguments or misuse quotes around column names.

How to eliminate wrong answers

Option A is wrong because Filter(Accounts, 'Active') passes a string literal as the condition, which is not a valid logical expression. Option C is wrong because it reverses the arguments, using 'Active' as the data source and Accounts as the condition. Option D is wrong because it also reverses the arguments, placing the condition first and the data source second.

Practice this question →

160

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

SharePoint enforces its own item-level permissions independently of the Power Apps canvas app. Users without Contribute or Edit rights on the underlying list can read data but cannot create items, producing the generic 'Access denied' error on submit. Granting write permissions on the list resolves the constraint.

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 →

161

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 provide drag-and-drop controls and prebuilt templates, letting the analyst build a mobile-responsive inventory form without writing code. This directly satisfies the no-code constraint, and the responsive canvas layout ensures the form renders correctly on mobile devices.

Why this answer

Canvas apps allow drag-and-drop design without code, enabling the creation of mobile-friendly custom forms. Option B (model-driven app) is less flexible for custom form design and requires more configuration. Option C (Power Apps portal) is designed for external user-facing websites, not internal inventory tracking.

Option D (customize SharePoint list form) is limited in mobile optimization and customization compared to a canvas app.

Practice this question →