CCNA Identify foundational components of Microsoft Power Platform Questions

MCQhard

A Power Automate flow uses the trigger shown. Users report that the flow does not trigger for emails with attachments. What is the most likely cause?

A.The path should include '/attachments'

B.The connection name is incorrect

C.The trigger does not check for attachments by default

D.The method should be 'post' instead of 'get'

AnswerC

Need to add condition to filter emails with attachments.

Why this answer

Option C is correct because the trigger shown in the question is likely a 'When a new email arrives' trigger, which by default does not include attachments. To process emails with attachments, you must explicitly configure the trigger to include attachments by enabling the 'Include Attachments' option or by using the 'Get attachments' action. Without this, the flow will not trigger for emails that have attachments.

Exam trap

The trap here is that candidates often assume the trigger automatically includes all email content, including attachments, when in reality the default behavior excludes attachments to optimize performance and avoid unnecessary data processing.

How to eliminate wrong answers

Option A is wrong because the path '/attachments' is not a valid trigger path; attachments are accessed via the 'Get attachments' action or by enabling the 'Include Attachments' property on the trigger, not by modifying the trigger path. Option B is wrong because the connection name being incorrect would cause a connection error at runtime, not a failure to trigger specifically for emails with attachments; the trigger would fail for all emails, not just those with attachments. Option D is wrong because the HTTP method (GET vs POST) is irrelevant to the trigger; Power Automate triggers for email are based on the email service's event model, not HTTP methods.

Practice this question →

Multi-Selecthard

Which THREE are common uses of connectors in Power Automate? (Choose three.)

Select 3 answers

A.Build a custom user interface

B.Create a record in Dataverse

C.Post a message to Microsoft Teams

D.Create a real-time dashboard

E.Send an email when a new record is created

AnswersB, C, E

Common data operation.

Why this answer

Option B is correct because connectors in Power Automate provide pre-built actions and triggers to interact with external services. The Dataverse connector includes a 'Create a new record' action, enabling automated creation of rows in Dataverse tables without custom code, directly from a flow.

Exam trap

The trap here is that candidates may confuse connectors with other Power Platform components, mistakenly thinking connectors can build UIs (Power Apps) or create dashboards (Power BI), when connectors are strictly for integration and automation.

Practice this question →

Drag & Dropmedium

Drag and drop the steps to set up a Microsoft Dataverse environment in the correct order.

Drag steps to the numbered slots on the right, or tap a step then tap a slot.

Steps

Order

Why this order

The admin center is used to create environments, specifying type, region, name, and database.

Practice this question →

MCQeasy

You work for a retail company that uses Microsoft Power Platform to manage inventory. The company has a Power Apps canvas app that allows store managers to update stock levels. Recently, the app has been slow to load and sometimes times out when multiple managers use it simultaneously. You need to recommend a solution to improve performance. What should you do?

A.Reduce the number of fields in the SharePoint list.

B.Instruct managers to use a wired network connection instead of Wi-Fi.

C.Implement a custom API to handle updates.

D.Migrate the app to use a Microsoft Dataverse database.

AnswerD

Dataverse is optimized for Power Platform and can handle concurrent users better.

Why this answer

Option B is correct because using a Dataverse database instead of SharePoint provides better performance and scalability for concurrent users. Option A is wrong because it only addresses connectivity, not server-side performance. Option C is wrong because it reduces functionality.

Option D is wrong because it adds complexity without addressing the root cause.

Practice this question →

MCQmedium

A company uses Microsoft Power Platform to manage customer support tickets. The support team wants to automatically categorize incoming emails as 'Complaint', 'Request', or 'Other' before creating a ticket. Which component should be used?

A.Power Automate with a trigger

B.Power Apps with a dropdown

C.Power BI with a report

D.AI Builder

AnswerD

Provides prebuilt or custom AI models for classification.

Why this answer

AI Builder provides prebuilt models for text classification, enabling automatic categorization of incoming emails into categories like 'Complaint', 'Request', or 'Other' without manual coding. This component integrates directly with Power Automate to process emails and create tickets based on the classification result.

Exam trap

The trap here is that candidates often assume Power Automate alone can perform intelligent classification, but it requires AI Builder for AI-based text analysis, as Power Automate is a workflow automation tool without built-in NLP capabilities.

How to eliminate wrong answers

Option A is wrong because Power Automate with a trigger can initiate a flow when an email arrives, but it cannot perform text classification on its own; it requires AI Builder or a custom model to categorize the content. Option B is wrong because Power Apps with a dropdown is a user interface control for manual selection, not an automated classification solution. Option C is wrong because Power BI with a report is used for data visualization and analytics, not for real-time email categorization or ticket creation.

Practice this question →

MCQhard

You are the Power Platform administrator for Contoso Ltd., a retail company with 500 employees. The company uses Microsoft 365 and has recently adopted Power Platform. The IT department manages a Power Apps canvas app used by the sales team to track customer interactions. The app connects to a Microsoft Dataverse table named 'Customer Interactions' with columns: CustomerID (text), InteractionDate (date), Notes (text), and SalesPerson (text). The app was working fine for three months, but starting last week, users report that the app loads slowly, sometimes timing out, and the 'Customer Interactions' table shows duplicate records. Upon investigation, you find that the app uses a 'Patch' function to create records, and the 'OnStart' property loads all records from the table using 'Filter(Customer Interactions, SalesPerson = User().FullName)' to show only the current user's records. The Dataverse table has grown to 50,000 rows. Additionally, some users have accidentally created multiple submissions by double-clicking the submit button. You need to resolve the performance and duplicate issues with minimal disruption. What should you do?

A.Replace the 'Patch' function with 'Collect' in the app and use the 'Distinct' function to remove duplicates from the table every night via a Power Automate flow.

B.Increase the 'Data row limit' for the 'Customer Interactions' table in the app settings to 500 and add a 'Remove duplicates' step in the app's 'OnStart'.

C.Remove the 'Filter' from 'OnStart' and load all records into a collection, then use 'Filter' on the collection to show current user's records.

D.Modify the 'Submit' button to set its 'DisplayMode' to 'Disabled' after the first click to prevent double submission, and change the 'OnStart' filter to delegate by ensuring the 'SalesPerson' column is indexed in Dataverse and using 'Filter(Customer Interactions, SalesPerson = User().FullName)' with delegation enabled.

AnswerD

This directly addresses both issues: disabling the button prevents duplicates, and delegated filtering improves performance by only loading relevant records.

Why this answer

Option D is correct because it addresses both performance and duplicate issues directly. Disabling the submit button after the first click prevents double submissions, a common cause of duplicates in canvas apps. Indexing the SalesPerson column in Dataverse ensures the Filter function delegates, meaning the query runs on the server side and only returns relevant rows, drastically reducing data transfer and load times compared to pulling all 50,000 rows client-side.

Exam trap

The trap here is that candidates often think loading all data into a collection (Option C) or using a nightly cleanup flow (Option A) is acceptable, but they miss that delegation and preventing duplicates at the source are the correct, minimal-disruption solutions for performance and data integrity.

How to eliminate wrong answers

Option A is wrong because using Collect to replace Patch does not solve the delegation or performance issue; Collect still loads all rows client-side, and running a nightly Power Automate flow to remove duplicates is a reactive workaround that does not prevent the root cause of double submissions. Option B is wrong because increasing the Data row limit to 500 does not help when the table has 50,000 rows; the app would still need to load all rows to apply the filter, and adding a 'Remove duplicates' step in OnStart does not prevent duplicates from being created. Option C is wrong because loading all records into a collection in OnStart defeats delegation entirely; the app would still retrieve all 50,000 rows over the network, causing the same slow load and timeout issues.

Practice this question →

Multi-Selecthard

Which TWO components of Microsoft Power Platform are primarily used to create and deploy custom business applications without writing code?

Select 2 answers

A.Power BI

B.AI Builder

C.Power Apps

D.Power Automate

E.Power Pages

AnswersC, D

Power Apps allows you to create custom apps with low-code.

Why this answer

Power Apps is a low-code platform that enables users to build custom business applications through a visual drag-and-drop interface, connecting to various data sources without writing traditional code. It directly addresses the requirement of creating and deploying custom business applications without coding.

Exam trap

The trap here is that candidates may confuse Power Automate (a workflow automation tool) with an application development platform, but Power Automate is used for automating processes and flows, not for building the application interface itself.

Practice this question →

MCQmedium

A company wants to use Power Automate to automate a business process that involves manual data entry from emails into a SharePoint list. Which component of Power Platform should be used to extract the relevant data from the email body?

A.Power Apps

B.Power BI

C.AI Builder

D.Power Virtual Agents

AnswerC

AI Builder can be used to extract information from emails using AI models.

Why this answer

AI Builder is the correct component because it provides prebuilt models for extracting structured data from unstructured text, such as email bodies. The 'Key Phrase Extraction' or 'Entity Extraction' models can parse email content and map relevant fields directly into a SharePoint list, eliminating manual data entry.

Exam trap

The trap here is that candidates confuse Power Automate's built-in 'Parse JSON' action with AI Builder's extraction capabilities, but 'Parse JSON' requires a predefined schema and cannot handle unstructured email text without prior transformation.

How to eliminate wrong answers

Option A is wrong because Power Apps is a low-code app development platform for building custom user interfaces, not for extracting data from email bodies. Option B is wrong because Power BI is a data visualization and analytics tool, not designed for data extraction from emails. Option D is wrong because Power Virtual Agents is a chatbot creation service for conversational interactions, not for parsing email content.

Practice this question →

Multi-Selectmedium

Which TWO components are part of the Microsoft Power Platform? (Choose two.)

Select 2 answers

A.Power Virtual Agents

B.Azure DevOps

C.Power Apps

D.Microsoft 365

E.Dynamics 365

AnswersA, C

Core component for chatbots.

Why this answer

Power Virtual Agents (A) is a component of the Microsoft Power Platform that enables users to create intelligent chatbots using a no-code graphical interface, without requiring developers or data scientists. It integrates with Power Automate and Power Apps to extend bot capabilities, making it a core part of the platform's low-code AI offerings.

Exam trap

The trap here is that candidates often confuse Dynamics 365 (a business application built on the Power Platform) with a foundational component, or mistakenly include Microsoft 365 as a Power Platform component due to its tight integration, but the exam specifically tests the four core components listed in official Microsoft documentation.

Practice this question →

MCQeasy

A company wants to automate a business process that requires approval from a manager before an expense report is submitted. Which Microsoft Power Platform component should be used?

A.Power BI

B.Power Apps

C.Power Automate

D.Power Virtual Agents

AnswerC

Automates workflows with approvals.

Why this answer

Power Automate is the correct component because it is designed to create automated workflows that can include approval steps. In this scenario, a Power Automate flow can be triggered when an expense report is submitted, route the request to the manager for approval, and then proceed with submission only after approval is granted.

Exam trap

The trap here is that candidates often confuse Power Apps (which can build a custom app for expense submission) with Power Automate (which handles the actual approval workflow automation), leading them to choose Power Apps because they think 'building an app' is required for the process.

How to eliminate wrong answers

Option A is wrong because Power BI is a business analytics tool for visualizing data and creating reports, not for automating business processes or managing approvals. Option B is wrong because Power Apps is a low-code platform for building custom applications; while it can integrate with approval workflows, it is not the primary tool for automating the approval process itself. Option D is wrong because Power Virtual Agents is used to create conversational AI chatbots, not to automate backend business processes like expense report approvals.

Practice this question →

MCQhard

An organization uses Dataverse as a data source for multiple Power Apps. They notice that records created in one app do not appear in another app until the page is refreshed. Which concept explains this behavior?

A.Caching of data by Power Apps

B.Different Dataverse environments used

C.Delegation limitations of the data source

D.Use of Patch mode instead of SubmitForm

AnswerA

Power Apps caches data to improve performance, leading to delays in seeing updates.

Why this answer

Power Apps caches data from Dataverse locally to improve performance and reduce network calls. When a record is created in one app, the cache in another app is not automatically invalidated, so the new record does not appear until the user manually refreshes the page or triggers a re-query. This caching behavior is by design to minimize latency and is controlled by the 'Enable data caching' setting in the app's advanced settings.

Exam trap

Microsoft often tests the misconception that data synchronization across apps is automatic in Dataverse, leading candidates to incorrectly choose delegation or environment differences, when the real issue is the client-side caching behavior that requires a manual or programmatic refresh.

How to eliminate wrong answers

Option B is wrong because if the apps were using different Dataverse environments, they would not share any data at all, not just require a refresh to see new records. Option C is wrong because delegation limitations affect how many rows can be processed server-side, not the visibility of newly created records across apps. Option D is wrong because Patch mode and SubmitForm are methods for writing data, not for reading or refreshing cached data; the issue is about data retrieval, not submission.

Practice this question →

Matchingmedium

Match each Power BI component to its description.

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

Concepts

Matches

Single page of visualizations from one or more reports

Multi-page collection of visualizations

Collection of data used to create visuals

Single visualization pinned to a dashboard

Container for dashboards, reports, and datasets

Why these pairings

These are the building blocks of Power BI.

Practice this question →

MCQmedium

A sales team uses a Canvas app to track leads. Users report that the app loads slowly when accessing on mobile devices. Which component should be optimized to improve performance?

A.Update the app version number

B.Optimize data source connections and queries

C.Increase the app icon size

D.Change the app's background color

AnswerB

Reduces data transfer and speeds up app.

Why this answer

Optimizing data source connections and queries directly reduces the amount of data transferred and the number of round trips between the Canvas app and its data source (e.g., Dataverse, SharePoint, SQL). On mobile devices, network latency and bandwidth are often constrained, so inefficient queries (e.g., loading all records instead of using filters) cause significant slowdowns. This is the primary performance lever for Canvas apps, as per Microsoft's guidance on app optimization.

Exam trap

The trap here is that candidates confuse cosmetic or metadata changes (version, icon, color) with performance optimizations, overlooking that data source efficiency is the root cause of slow loading in Canvas apps on mobile devices.

How to eliminate wrong answers

Option A is wrong because updating the app version number does not affect runtime performance; it only changes the version metadata and may trigger a re-publish, but does not optimize data retrieval or rendering. Option C is wrong because increasing the app icon size has no impact on load time; it only changes the visual asset displayed on the device home screen, not the app's internal data flow. Option D is wrong because changing the app's background color is a purely cosmetic change that does not influence network requests, data caching, or rendering performance.

Practice this question →

MCQeasy

A company needs to create a dashboard that shows real-time sales data from a SQL database. Which Microsoft Power Platform tool should be used?

A.Power Apps

B.Power Automate

C.Power BI

D.AI Builder

AnswerC

Business analytics and dashboarding.

Why this answer

Power BI is the correct tool because it is designed specifically for data visualization and business analytics, capable of connecting directly to a SQL database to create real-time dashboards. It supports DirectQuery or live connections to SQL Server, enabling near-real-time updates without requiring data to be imported into a separate store.

Exam trap

The trap here is that candidates may confuse Power Apps' ability to display data in galleries or forms with the dedicated dashboard and visualization capabilities of Power BI, but Power Apps lacks native real-time SQL dashboarding features and is not the appropriate tool for this requirement.

How to eliminate wrong answers

Option A is wrong because Power Apps is a low-code platform for building custom business applications (canvas or model-driven apps), not for creating dashboards that visualize real-time sales data from a SQL database. Option B is wrong because Power Automate is a workflow automation tool that orchestrates actions across services, but it does not provide dashboard or visualization capabilities for real-time data. Option D is wrong because AI Builder is an add-on for adding AI models (e.g., prediction, object detection) to Power Apps or Power Automate, not for building dashboards or connecting to SQL databases for real-time reporting.

Practice this question →