Courseiva

CCNA Identify foundational components of Power Platform Questions

24 questions · Identify foundational components of Power Platform · All types, answers revealed

Practice these questionsDomain overviewAll questions
1
Multi-Selecthard

Which THREE of the following are capabilities of Power Virtual Agents? (Choose three.)

Select 3 answers
A.Use prebuilt templates for common scenarios
B.Escalate conversations to a live human agent
C.Create chatbots that can be published to websites and Microsoft Teams
D.Generate interactive reports from conversation data
E.Automate complex workflows with conditions
AnswersA, B, C

Templates accelerate bot creation.

Why this answer

Option A is correct because Power Virtual Agents provides a library of prebuilt templates for common chatbot scenarios, such as customer support or FAQ handling, which accelerates development by offering starter content and dialog structures. These templates are designed to be customized, allowing creators to quickly build functional bots without starting from scratch.

Exam trap

The trap here is that candidates may confuse Power Virtual Agents' ability to trigger Power Automate flows with the capability to automate complex workflows itself, or assume that conversation analytics includes interactive report generation, which is actually a Power BI feature.

Practice this question →
2
MCQeasy

A business analyst wants to create a dashboard that displays real-time sales data from a SQL database and share it with the team. Which Power Platform component is best suited?

A.Power Automate
B.Power BI
C.Power Virtual Agents
D.Power Apps
AnswerB

Power BI is the tool for dashboards and analytics.

Why this answer

Power BI is the correct choice because it is specifically designed for data visualization and business intelligence, enabling real-time dashboards from SQL databases via DirectQuery or live connections. It allows sharing dashboards with the team through Power BI Service, meeting the requirement for real-time sales data display and collaboration.

Exam trap

The trap here is that candidates may confuse Power Apps with Power BI because both can display data, but Power Apps is for app creation with limited real-time dashboard sharing, while Power BI is the dedicated analytics and visualization tool for live dashboards.

How to eliminate wrong answers

Option A is wrong because Power Automate is a workflow automation tool for triggering actions based on events, not for creating dashboards or visualizing real-time data. Option C is wrong because Power Virtual Agents is used to build conversational chatbots, not for data visualization or dashboard creation. Option D is wrong because Power Apps is for building custom applications with forms and logic, but it lacks native real-time dashboarding and sharing capabilities compared to Power BI.

Practice this question →
3
Drag & Dropmedium

Drag and drop the steps to create a canvas app from a SharePoint list 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 process starts in the maker portal, then selects SharePoint as source, connects to the list, chooses a template, and finally publishes and shares.

Practice this question →
4
Multi-Selectmedium

Which TWO of the following are key benefits of using Microsoft Dataverse? (Choose two.)

Select 2 answers
A.Business logic such as calculated columns and business rules
B.Built-in security and role-based access control
C.Ability to store unstructured data like videos
D.Direct embedding in Microsoft Teams without any integration
E.Real-time analytics dashboards
AnswersA, B

Dataverse supports business logic.

Why this answer

Option A is correct because Microsoft Dataverse includes built-in business logic capabilities such as calculated columns (which compute values based on other columns) and business rules (which enforce conditions or actions without custom code). These features allow creators to implement data validation and automation directly within the data platform, reducing the need for external workflows or plugins.

Exam trap

The trap here is that candidates often confuse Dataverse's structured data storage with general-purpose blob storage (Option C) or assume that Teams integration is automatic (Option D), when in fact Dataverse requires explicit connectors or custom solutions for both scenarios.

Practice this question →
5
MCQeasy

Refer to the exhibit. Which Power Platform component is being described?

A.Power BI
B.Power Virtual Agents
C.Power Automate
D.Power Apps
AnswerC

It's an automated workflow.

Why this answer

The exhibit describes a tool that automates workflows between applications and services, such as sending notifications or synchronizing files, without requiring custom code. This is the core function of Power Automate, which uses triggers and actions to create automated processes across hundreds of connectors.

Exam trap

The trap here is that candidates often confuse Power Automate with Power Apps because both involve 'automation' in a broad sense, but Power Automate specifically focuses on workflow automation between services, not building user interfaces or applications.

How to eliminate wrong answers

Option A is wrong because Power BI is a business analytics service for visualizing data and sharing insights, not for automating workflows. Option B is wrong because Power Virtual Agents is a chatbot-building platform that uses conversational AI, not workflow automation. Option D is wrong because Power Apps is a low-code application development platform for building custom apps, not for creating automated workflows between services.

Practice this question →
6
MCQeasy

Which data platform in Power Platform provides a secure, scalable database with built-in business logic and security?

A.Microsoft Dataverse
B.SharePoint
C.SQL Server
D.Excel
AnswerA

Dataverse is the data platform for Power Platform.

Why this answer

Microsoft Dataverse is the correct answer because it is the underlying data platform for Power Platform that provides a secure, scalable database with built-in business logic (such as business rules, workflows, and calculated fields) and role-based security. Unlike other options, Dataverse is designed specifically to store and manage business data with features like column-level security, auditing, and a rich metadata-driven architecture.

Exam trap

The trap here is that candidates often confuse SharePoint's list storage capabilities with a true database platform, overlooking that Dataverse is the only option purpose-built for Power Platform with integrated security and business logic.

How to eliminate wrong answers

Option B (SharePoint) is wrong because while it can store list data and integrate with Power Platform, it lacks the relational database capabilities, built-in business logic (like server-side calculations and workflows), and granular role-based security that Dataverse provides; SharePoint is primarily a document management and collaboration platform. Option C (SQL Server) is wrong because although it is a robust relational database with security and logic, it is not a built-in data platform of Power Platform and requires additional configuration for integration, whereas Dataverse is natively integrated with Power Apps and Power Automate. Option D (Excel) is wrong because it is a spreadsheet application with no built-in security, scalability, or business logic capabilities; it is often used as a data source but is not a secure, scalable database platform.

Practice this question →
7
Multi-Selecteasy

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

Select 2 answers
A.SharePoint
B.Teams
C.Power Apps
D.Excel
E.Power BI
AnswersC, E

Power Apps is a core component.

Why this answer

Power Apps is a core component of Microsoft Power Platform, enabling users to build custom low-code applications for web and mobile without extensive programming. It integrates with other Power Platform services like Power Automate and Power BI to create end-to-end business solutions.

Exam trap

The trap here is that candidates often confuse data sources or integration tools (like SharePoint or Excel) with actual Power Platform components, leading them to select those as answers instead of the core services Power Apps and Power BI.

Practice this question →
8
MCQmedium

A business wants to create a chatbot that answers common IT support questions and can escalate to a human agent if needed. Which Power Platform component should be used?

A.Power Apps
B.Power BI
C.Power Automate
D.Power Virtual Agents
AnswerD

Power Virtual Agents is the chatbot builder.

Why this answer

Power Virtual Agents (D) is the correct choice because it is a Power Platform component specifically designed to create conversational AI chatbots with minimal code. It allows you to build a bot that answers common IT support questions using prebuilt topics and can seamlessly escalate to a human agent via a handoff to a live chat system or Dynamics 365 Customer Service.

Exam trap

The trap here is that candidates may confuse Power Automate's ability to trigger flows from a chatbot with the chatbot itself, but Power Automate is only an integration tool, not the chatbot platform.

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 chatbots. Option B is wrong because Power BI is a data visualization and business analytics tool, not a chatbot builder. Option C is wrong because Power Automate is a workflow automation service that orchestrates repetitive tasks and processes, but it does not natively provide conversational AI capabilities or a chatbot interface.

Practice this question →
9
MCQhard

A Power Apps app uses a canvas and connects to multiple data sources. Users complain that the app loads slowly. What is the best practice to improve performance?

A.Use the 'ClearCollect' function to cache data in a collection
B.Add more screens to distribute the load
C.Increase the timeout settings
D.Use a single data source
AnswerA

Collections cache data locally, reducing repeated queries.

Why this answer

Option A is correct because the ClearCollect function allows you to cache data from external sources into a local collection within the app. This reduces the number of round trips to the data source during user interactions, significantly improving load and response times by minimizing network latency and data source throttling.

Exam trap

The trap here is that candidates may think adding more screens distributes the workload, but in Power Apps, each screen loads independently and can trigger separate data source calls, worsening performance rather than improving it.

How to eliminate wrong answers

Option B is wrong because adding more screens increases the app's memory footprint and can actually degrade performance, as each screen may trigger additional data requests. Option C is wrong because increasing timeout settings does not address the root cause of slow data retrieval; it only allows the app to wait longer for a response, potentially masking performance issues. Option D is wrong because using a single data source is not always feasible and does not inherently improve performance; the bottleneck is often the number of queries, not the number of sources.

Practice this question →
10
MCQmedium

A company wants to analyze customer feedback from surveys stored in Excel and create interactive reports. Which combination of Power Platform components is best?

A.Power Virtual Agents and Power BI
B.Power Apps and Power BI
C.Power BI and Power Automate
D.Power Apps and Power Automate
AnswerC

Power BI for reports, Power Automate for automation (e.g., refresh).

Why this answer

Option C is correct because Power BI is the primary tool for creating interactive reports and dashboards from data sources like Excel, while Power Automate can be used to automate the ingestion or refresh of survey data from Excel into Power BI, enabling scheduled updates. Together, they directly address the requirement to analyze feedback and build interactive reports without needing custom app development.

Exam trap

The trap here is that candidates often confuse Power Apps (for building apps) with Power BI (for analytics), or assume Power Automate alone can generate reports, when in fact Power BI is the only component designed for interactive data visualization and reporting.

How to eliminate wrong answers

Option A is wrong because Power Virtual Agents is a chatbot builder for conversational interfaces, not a tool for analyzing survey data or creating interactive reports. Option B is wrong because Power Apps is for building custom applications, not for data analysis or interactive reporting; it lacks the native analytics and visualization capabilities of Power BI. Option D is wrong because Power Apps and Power Automate together can handle data entry and workflows but cannot produce interactive reports or dashboards; Power BI is essential for the reporting requirement.

Practice this question →
11
Drag & Dropmedium

Drag and drop the steps to create a security role in Dataverse 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

Security roles are created in admin center, named, permissions set, then saved and assigned.

Practice this question →
12
MCQeasy

Which Power Platform component provides a low-code platform to build custom business applications that can be embedded in Microsoft Teams?

A.Power BI
B.Power Apps
C.Power Virtual Agents
D.Power Automate
AnswerB

Power Apps is the low-code app platform.

Why this answer

Power Apps is the correct answer because it is the low-code platform within Microsoft Power Platform specifically designed for building custom business applications. These apps can be directly embedded into Microsoft Teams via the 'Power Apps' tab or personal app, allowing users to interact with the app without leaving the Teams interface.

Exam trap

The trap here is that candidates may confuse Power Automate (automation) or Power BI (analytics) with app building, but only Power Apps provides the low-code application development capability required for custom business apps in Teams.

How to eliminate wrong answers

Option A is wrong because Power BI is a business analytics and visualization tool, not an application builder; it creates reports and dashboards, not custom business apps. Option C is wrong because Power Virtual Agents is a chatbot service for creating conversational AI agents, not for building custom business applications. Option D is wrong because Power Automate is a workflow automation service for creating automated processes between apps and services, not for building custom business applications.

Practice this question →
13
MCQeasy

Which Power Platform component allows users to create automated workflows between apps and services?

A.Power Automate
B.Power BI
C.Power Virtual Agents
D.Power Apps
AnswerA

Power Automate automates workflows.

Why this answer

Power Automate is the correct answer because it is the Power Platform component specifically designed to create automated workflows between apps and services. It enables users to build flows that trigger actions across hundreds of connectors, such as sending an email when a new SharePoint item is added, without writing code.

Exam trap

The trap here is that candidates often confuse Power Automate with Power Apps, thinking both can automate workflows, but Power Apps is for building user interfaces and logic within an app, not for cross-service automation.

How to eliminate wrong answers

Option B is wrong because Power BI is a business analytics tool for visualizing data and creating reports, not for automating workflows. Option C is wrong because Power Virtual Agents is used to create conversational AI chatbots, not to build automated workflows between apps and services. Option D is wrong because Power Apps is a low-code platform for building custom applications, not for creating automated workflows.

Practice this question →
14
MCQmedium

A company wants to automate the process of sending a welcome email to new employees after their HR record is created in Dataverse. Which component should be used?

A.Power Apps
B.Power Virtual Agents
C.Power Automate
D.Power BI
AnswerC

Power Automate creates automated workflows.

Why this answer

Power Automate is the correct choice because it is designed to create automated workflows that trigger on events in Dataverse, such as the creation of a new HR record. It can then perform actions like sending a welcome email via connectors (e.g., Office 365 Outlook) without manual intervention.

Exam trap

The trap here is that candidates may confuse Power Apps' ability to trigger flows from within an app with the actual automation component, but Power Automate is the dedicated service for event-driven workflows like sending emails on Dataverse record creation.

How to eliminate wrong answers

Option A is wrong because Power Apps is a low-code platform for building custom apps (canvas or model-driven), not for automating workflows or sending emails based on Dataverse events. Option B is wrong because Power Virtual Agents is used to create conversational chatbots, not to trigger automated email actions from Dataverse record creation. Option D is wrong because Power BI is a business analytics tool for data visualization and reporting, not for workflow automation or email sending.

Practice this question →
15
MCQmedium

A company wants to create a custom app that allows field technicians to view and update work orders from their mobile devices. The app must work offline and sync data when connectivity is restored. Which Power Platform component should be used?

A.Power Apps
B.Power Automate
C.Power BI
D.Power Virtual Agents
AnswerA

Power Apps enables custom mobile apps with offline sync.

Why this answer

Power Apps is the correct component because it enables the creation of custom canvas or model-driven apps that can run on mobile devices. Power Apps supports offline capability through the use of the offline profile feature, which allows users to view and update work orders without connectivity and sync changes to the underlying Microsoft Dataverse when the connection is restored.

Exam trap

The trap here is that candidates may confuse Power Automate's ability to trigger offline workflows with the need for a full mobile app interface, overlooking that Power Apps is the only component that provides both a custom UI and built-in offline sync for Dataverse data.

How to eliminate wrong answers

Option B is wrong because Power Automate is a workflow automation tool that triggers actions based on events, but it does not provide a user interface for field technicians to view or update work orders directly. Option C is wrong because Power BI is a data visualization and analytics tool, not an app-building platform, and it lacks offline data entry and sync capabilities for work order management. Option D is wrong because Power Virtual Agents is a chatbot service for creating conversational AI, not a custom app for mobile data entry and offline sync.

Practice this question →
16
MCQhard

A company uses Power Automate to send approval requests. The flow is triggered when a new item is added to a SharePoint list. However, the flow fails when the item contains a large attachment. What is the most likely cause?

A.The flow is using the wrong trigger
B.The approval action is not configured for attachments
C.The SharePoint list is not properly configured for large files
D.The attachment exceeds the maximum file size allowed by Power Automate
AnswerD

Power Automate has a 100 MB limit for file-related actions.

Why this answer

Power Automate imposes a maximum file size limit for attachments processed within flows. When a SharePoint list item includes a large attachment that exceeds this limit, the flow fails during the approval action because the attachment data cannot be transmitted. This is a known constraint in Power Automate, typically around 100 MB for standard connectors, and is the most direct cause of the failure described.

Exam trap

The trap here is that candidates may confuse SharePoint's large file configuration (which supports files up to 250 GB) with Power Automate's attachment size limit, leading them to incorrectly select Option C.

How to eliminate wrong answers

Option A is wrong because the trigger (when a new item is added to a SharePoint list) is correctly configured; the issue is not with the trigger but with the attachment size during processing. Option B is wrong because the approval action does not require special configuration for attachments beyond the size limit; the failure occurs before the approval action can process the attachment. Option C is wrong because SharePoint lists can be configured to allow large files (up to 250 GB), but the failure is due to Power Automate's attachment size limit, not SharePoint's configuration.

Practice this question →
17
Matchingmedium

Match each Microsoft Power Platform component to its primary purpose.

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

Concepts
Matches

Build custom apps with low code

Automate workflows and processes

Visualize and analyze data

Create AI-powered chatbots

Build external-facing websites

Why these pairings

These are the five main components of Microsoft Power Platform.

Practice this question →
18
MCQmedium

A non-profit organization uses Power Automate to send thank-you emails to donors after a donation is recorded in a SharePoint list. The flow is triggered when a new item is added. Recently, the flow has been failing intermittently with a '400 Bad Request' error. The SharePoint list has columns: DonorName, Email, Amount, Date. The flow uses the 'Send an email (V2)' action. The IT volunteer who set up the flow is unavailable. The organization needs a quick resolution. What is the most likely cause of the error?

A.The flow trigger is misconfigured
B.The SharePoint list is full
C.The 'Send an email' action is using an invalid email address
D.The organization's email server is down
AnswerC

400 errors often come from invalid email format or missing address.

Why this answer

The '400 Bad Request' error in Power Automate's 'Send an email (V2)' action typically indicates that the email server rejected the request due to a malformed or invalid recipient address. Since the flow dynamically pulls the email from the SharePoint list's 'Email' column, a missing, misspelled, or improperly formatted email address (e.g., missing '@' or domain) would cause the SMTP server to return a 400 status. This is the most common cause in donation-tracking scenarios where manual data entry may introduce errors.

Exam trap

Cisco often tests the distinction between HTTP error codes (400 vs. 500 series) and their root causes, so the trap here is that candidates may incorrectly attribute the error to a server-side issue (like email server down) or a trigger misconfiguration, rather than recognizing that 400 errors are client-side and related to invalid input in the action parameters.

How to eliminate wrong answers

Option A is wrong because a misconfigured trigger would prevent the flow from starting at all or cause it to fail on every run, not intermittently; the '400 Bad Request' is an HTTP response from the email action, not a trigger issue. Option B is wrong because SharePoint lists do not have a 'full' capacity limit that would cause a 400 error; list throttling or storage limits would produce different errors (e.g., 429 or 507). Option D is wrong because if the organization's email server were down, the error would typically be a timeout or connection failure (e.g., 504 Gateway Timeout or 'Unable to connect'), not a 400 Bad Request, which indicates the request was received but rejected due to invalid syntax.

Practice this question →
19
MCQmedium

Refer to the exhibit. A Power Automate flow fails with the error shown. What is the most likely cause?

A.The flow trigger is misconfigured
B.The SharePoint site is offline
C.The SharePoint connection used in the flow does not have write permissions
D.The HTTP request URL is malformed
AnswerC

403 indicates lack of permission.

Why this answer

The error message indicates a permission issue when the flow attempts to write to the SharePoint list. Since the flow trigger and HTTP request URL are validated at design time and the SharePoint site is accessible (the flow runs but fails), the most likely cause is that the SharePoint connection used in the flow lacks write permissions on the target list or library.

Exam trap

The trap here is that candidates often assume a flow failure is due to a misconfigured trigger or a malformed URL, but the error message explicitly points to a permission issue, which is a common oversight when reusing connections across environments or after permission changes.

How to eliminate wrong answers

Option A is wrong because a misconfigured trigger would prevent the flow from starting or would cause a different error (e.g., 'Trigger not found'), not a permission-related failure during an action. Option B is wrong because if the SharePoint site were offline, the flow would fail with a connectivity or timeout error, not a permission denied error. Option D is wrong because a malformed HTTP request URL would result in a 400 Bad Request error or a parsing error, not a permission denied error.

Practice this question →
20
MCQhard

An organization uses Power Apps to manage inventory. The app uses a SharePoint list as the data source. Users report that when two employees update the same item simultaneously, data is lost. What is the best solution?

A.Switch the data source to Microsoft Dataverse
B.Restrict editing to one user at a time using permissions
C.Use Power Automate to create a flow that queues updates
D.Enable versioning on the SharePoint list and modify the app to check the last modified timestamp before update
AnswerD

Versioning tracks changes, and checking timestamps prevents overwrites.

Why this answer

Option D is correct because it directly addresses the root cause of data loss: concurrent updates overwriting each other. By enabling versioning on the SharePoint list, the app can retrieve the last modified timestamp before performing an update. If the timestamp has changed since the record was loaded, the app can detect a conflict and prompt the user to refresh, preventing silent overwrites.

This pattern is known as optimistic concurrency control and is the standard approach for SharePoint-based Power Apps.

Exam trap

The trap here is that candidates often assume a more complex solution (like switching to Dataverse or using Power Automate) is required, when the simplest and most effective fix is to leverage existing SharePoint features like versioning and timestamp checking within the app logic.

How to eliminate wrong answers

Option A is wrong because switching to Microsoft Dataverse does not inherently solve concurrency conflicts; Dataverse supports optimistic concurrency but requires explicit implementation in the app, and the question specifically asks for the best solution given the existing SharePoint data source. Option B is wrong because restricting editing to one user at a time using permissions is impractical for real-time collaboration, creates a poor user experience, and does not address the technical mechanism of concurrent updates. Option C is wrong because using Power Automate to queue updates introduces latency, complexity, and potential ordering issues, and does not prevent data loss from simultaneous writes; it also violates the principle of handling conflicts at the data source level.

Practice this question →
21
MCQhard

A medium-sized company uses Power Platform to manage its customer service operations. They have a model-driven app built on Dataverse that tracks cases and customer interactions. Recently, the app has been experiencing slow load times when users open a case record. The Dataverse environment is in the same region as the users. The app uses several business rules and calculated fields. The IT team suspects that the issue might be related to the number of components on the form. They want to optimize performance without disabling necessary functionality. The app is used by 50 customer service agents. What should the IT team do to improve form load times?

A.Remove unused fields and columns from the main form
B.Add more calculated fields to precompute values
C.Disable all business rules
D.Switch the app to a canvas app
AnswerA

Reduces data load and improves performance.

Why this answer

Option A is correct because removing unused fields and columns from the main form reduces the amount of data retrieved and processed when a case record loads. Fewer form components mean fewer calls to Dataverse and less client-side rendering, directly improving load times without disabling necessary business rules or calculated fields.

Exam trap

The trap here is that candidates may think adding calculated fields (Option B) or switching app types (Option D) are valid performance fixes, when in fact they either worsen the problem or miss the root cause of form component bloat.

How to eliminate wrong answers

Option B is wrong because adding more calculated fields increases server-side computation and can further degrade form load times, not improve them. Option C is wrong because disabling all business rules would break critical validation and automation logic, and the question specifies optimizing performance without disabling necessary functionality. Option D is wrong because switching to a canvas app is a fundamental architectural change that does not address the specific form component overload issue and introduces a different set of performance considerations.

Practice this question →
22
MCQhard

Refer to the exhibit. You are reviewing an Azure Resource Manager template for a Power Platform connector. Which component is being configured?

A.A Power Apps canvas app
B.A Power Automate flow
C.A Power BI dataset
D.A Dataverse connector
AnswerD

The properties show it's a Dataverse connector.

Why this answer

The exhibit shows an Azure Resource Manager (ARM) template defining a connection resource of type 'Microsoft.PowerPlatform/connectors'. This resource type specifically configures a Dataverse connector, which enables Power Platform components to connect to Microsoft Dataverse. The template includes properties like 'environment', 'apiId', and 'connectionParameters' that are unique to connector definitions, not to apps, flows, or datasets.

Exam trap

The trap here is that candidates confuse the ARM template resource type 'Microsoft.PowerPlatform/connectors' with the broader Power Platform components, but the template's specific properties (like 'apiId' and 'connectionParameters') uniquely identify it as a connector configuration, not an app, flow, or dataset.

How to eliminate wrong answers

Option A is wrong because a Power Apps canvas app is defined using a different ARM resource type (e.g., 'Microsoft.PowerApps/apps') and does not use connector-specific properties like 'apiId' or 'connectionParameters'. Option B is wrong because a Power Automate flow is defined under 'Microsoft.Logic/workflows' or 'Microsoft.PowerApps/flows', not under 'Microsoft.PowerPlatform/connectors'. Option C is wrong because a Power BI dataset is configured using 'Microsoft.PowerBI/datasets' and involves data model definitions, not connector connection settings.

Practice this question →
23
Matchingmedium

Match each solution type in Power Platform to its description.

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

Concepts
Matches

Used during development; can be edited

Used for deployment; cannot be edited

Identifies the creator of a solution

Update to a managed solution

Replaces an older solution version

Why these pairings

Solutions manage application lifecycle.

Practice this question →
24
Multi-Selecthard

Which THREE of the following are valid connectors in Power Automate? (Choose three.)

Select 3 answers
A.Google Drive
B.SQL Server
C.SharePoint
D.Dropbox
E.Outlook
AnswersB, C, E

SQL Server connector is available.

Why this answer

SQL Server is a valid connector in Power Automate because it allows direct integration with on-premises or cloud-hosted SQL Server databases via the on-premises data gateway or Azure SQL. This connector supports triggers like 'When an item is created or modified' and actions such as 'Get rows' or 'Insert row', enabling automated workflows that read and write data to SQL tables.

Exam trap

The trap here is that candidates may assume any popular cloud service (like Google Drive or Dropbox) is a built-in connector, but Microsoft only provides first-party connectors for its own services and a curated set of third-party services, excluding Google Drive and Dropbox from the standard list.

Practice this question →

Ready to test yourself?

Try a timed practice session using only Identify foundational components of Power Platform questions.

Start 20-question session