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

226

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

Microsoft Intune can deploy app protection policies, such as preventing screen capture, to Power Apps on mobile devices. Option A is incorrect because Microsoft Entra ID is for identity and access management, not device policy enforcement. Option B is incorrect because Microsoft Defender XDR is for threat detection and response, not mobile app management.

Option D is incorrect because Microsoft Purview is for data governance and compliance, not mobile app management policies.

Practice this question →

227

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

Applying a delegable filter on the data source limits the number of records retrieved to only those that match the filter, which significantly improves performance. Option A is incorrect because increasing the delegation limit does not help if the query itself is not delegable; the app will still retrieve all 10,000 items. Option C is wrong because adding more screens does not reduce the amount of data loaded.

Option D is incorrect because disabling offline mode does not affect initial loading speed; it only impacts offline capabilities.

Practice this question →

228

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

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

229

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

(Model-driven app) is correct because model-driven apps are designed for data-centric applications with built-in relationships and navigation, making them ideal for scenarios where users need to view and interact with related records such as accounts, opportunities, and contacts. Option A (Canvas app) is wrong because canvas apps start with a blank canvas and require manual coding of relationships and navigation, which is less efficient for this use case. Option B (Power BI dashboard) is wrong because Power BI is for analytics and reporting, not for building transactional apps.

Option C (Chatbot in Power Virtual Agents) is wrong because chatbots are designed for conversational interactions, not for displaying and navigating a list of records with related data.

Practice this question →

230

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 →

231

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

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 →

232

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

The most efficient method is to use the Filter function with User().Email or User().FullName to filter records based on the current user. This approach leverages the app's built-in context without requiring additional security configuration. Option A is incorrect because removing datasource permissions undermines data security and is not a best practice.

Option B is incorrect because while security roles can restrict access, they are more complex to set up and may not be the most efficient for simply filtering by user identity. Option D is incorrect because storing user ID in a global variable is less efficient and can be less secure compared to using the User() function directly in the filter.

Practice this question →

233

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 the approved client apps as Power Apps and Power Automate. The 'approved client app' condition in a conditional access policy requires that the client app used is one of the listed apps. Therefore, this policy allows access only from Power Apps and Power Automate, blocking all other apps.

Option C is correct. Option A is incorrect because the policy does not block Power Apps and Power Automate; it allows them. Option B is incorrect because the policy does not require compliance; it only checks the app identity.

Option D is incorrect because the policy does not require multi-factor authentication; it only checks the app.

Practice this question →

234

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

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 →

235

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

The Filter function in Power Apps takes the data source as the first argument and a formula as the second argument. Option B correctly uses Filter(Accounts, Status = 'Active'). Option A is incorrect because 'Active' alone is not a valid formula.

Option C has the arguments reversed. Option D has the formula as the first argument and the source as the second, which is invalid.

Practice this question →

236

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 →

237

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

To restrict a Canvas app to licensed users only, the administrator should share the app with specific security groups that contain licensed users. Power Apps licensing is per user; sharing the app with a security group ensures that only members of that group (who must have appropriate licenses) can access it. Option A is incorrect because removing the app from the Teams catalog does not enforce licensing.

Option B is incorrect because publishing the app to everyone in the tenant would allow all users to access it regardless of license status. Option C is incorrect because there is no 'Require user license' setting in Power Apps; licensing is enforced at the user level when sharing.

Practice this question →

238

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

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 →