Quick Answer
The answer is Outlook, SQL Server, and SharePoint. These are all valid connectors in Power Automate because they are prebuilt connectors that enable seamless integration with widely used Microsoft and enterprise services, allowing automated workflows to trigger actions like sending emails, querying databases, or managing list items. On the PL-900 exam, this question tests your understanding of the connector ecosystem, specifically which services are natively supported without custom development—a common trap is confusing premium connectors like Salesforce or HTTP with standard ones, or assuming all Microsoft services are automatically valid. A reliable memory tip is to remember the "Microsoft triad" for standard connectors: Outlook for communication, SharePoint for content, and SQL Server for data storage, as these three consistently appear in exam scenarios.
This PL-900 practice question tests your understanding of identify foundational components of power platform. Match the stated requirement to the specific cloud service, access model, or configuration option — many options are valid in isolation but not for this scenario. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
Which THREE of the following are valid connectors in Power Automate? (Choose three.)
Google Drive
Why wrong: Google Drive is not a built-in connector; it requires third-party.
SQL Server
SQL Server connector is available.
SharePoint
SharePoint is a standard connector.
Dropbox
Why wrong: Dropbox is not a built-in connector.
Outlook
Outlook connector is widely used.
Answer choices
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
SQL Server
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.
Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Answer analysis
For each option: why learners choose it and why it is or isn't the right answer here.
Google Drive
Why it's wrong here
Google Drive is not a built-in connector; it requires third-party.
SQL Server
Why this is correct
SQL Server connector is available.
Related concept
Read the scenario before looking for a memorised answer.
SharePoint
Why this is correct
SharePoint is a standard connector.
Related concept
Read the scenario before looking for a memorised answer.
Dropbox
Why it's wrong here
Dropbox is not a built-in connector.
Outlook
Why this is correct
Outlook connector is widely used.
Related concept
Read the scenario before looking for a memorised answer.
Common exam traps
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.
Detailed technical explanation
Power Automate connectors use REST APIs and OAuth 2.0 for authentication, with SQL Server leveraging the TDS protocol and the on-premises data gateway for hybrid connectivity. The SharePoint connector uses SharePoint REST APIs and supports list and library triggers, while the Outlook connector (Office 365 Outlook) uses Microsoft Graph API for email, calendar, and contact automation. Understanding which connectors are first-party versus third-party is critical for solution design.
Key takeaway
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
A cloud solutions architect for a retail company is evaluating services for a new workload. The correct answer here reflects best practice for the specific scenario described — not a general cloud recommendation. Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option. Cloud exam questions reward reading the constraint carefully: the same technology can be right or wrong depending on the use case.
What to study next
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Identify foundational components of Power Platform — study guide chapter
Learn the concepts, then practise the questions
Identify foundational components of Power Platform practice questions
Targeted practice on this topic area only
All PL-900 questions
976 questions across all exam domains
Microsoft Power Platform Fundamentals PL-900 study guide
Full concept coverage aligned to exam objectives
PL-900 practice test guide
How to use practice tests most effectively before exam day
Related practice questions
Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.
Practise PL-900 questions linked to Identify foundational components of Power Platform.
Practise PL-900 questions linked to Demonstrate capabilities of Power BI.
Practise PL-900 questions linked to Describe complementary Microsoft Power Platform solutions.
Practise PL-900 questions linked to Demonstrate the capabilities of Power Automate.
Practise PL-900 questions linked to Describe the business value of Microsoft Power Platform.
Practise PL-900 questions linked to Manage the Microsoft Power Platform environment.
Practise PL-900 questions linked to Identify foundational components of Microsoft Power Platform.
Practise PL-900 questions linked to Demonstrate the capabilities of Power BI.
Practise PL-900 questions linked to Demonstrate the capabilities of Power Apps.
Practise PL-900 questions linked to Demonstrate the capabilities of Microsoft Copilot Studio.
Practise PL-900 questions linked to Demonstrate the capabilities of Power Pages.
Practise PL-900 questions linked to PL-900 fundamentals.
Practice this exam
Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.
FAQ
Identify foundational components of Power Platform — This question tests Identify foundational components of Power Platform — Read the scenario before looking for a memorised answer..
The correct answer is: SQL Server — 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.
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Read the scenario before looking for a memorised answer.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Last reviewed: Jun 11, 2026
This PL-900 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-900 exam.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.