Courseiva
← PL-900
Full test
Question 960 of 976
Describe the business value of Microsoft Power Platform →hardMultiple ChoiceObjective-mapped

Quick Answer

The correct answer is that the flow is using the cloud SQL connector without an on-premises data gateway. This is because the SQL connector in Power Automate is inherently a cloud-based service, and it cannot directly establish a connection to an on-premises SQL Server database without a bridge. An on-premises data gateway must be installed on a machine within the same network as the SQL Server, and the connector must be explicitly configured to use that gateway to route traffic securely. On the Microsoft Power Platform Fundamentals PL-900 exam, this scenario tests your understanding of how cloud connectors differ from on-premises connectors and the critical role of the gateway in hybrid integrations. A common trap is assuming the SQL connector works universally, but it will fail with a connection error if no gateway is linked. Remember the memory tip: “Cloud can’t crawl on-prem without a gateway bridge.”

PL-900 Practice Question: Describe the business value of Microsoft Power Platform

This PL-900 practice question tests your understanding of describe the business value of microsoft power platform. The scenario asks you to isolate a root cause — eliminate options that address a different problem before choosing. 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.

Exhibit

{
  "connections": [
    {
      "name": "shared_office365",
      "id": "/providers/Microsoft.PowerApps/apis/shared_office365"
    },
    {
      "name": "shared_sql",
      "id": "/providers/Microsoft.PowerApps/apis/shared_sql"
    }
  ],
  "environment": {
    "name": "Production",
    "type": "Production",
    "region": "eastus"
  }
}

Refer to the exhibit. You are troubleshooting a Power Automate flow that fails when trying to access an on-premises SQL Server database. The flow uses the SQL connector. Based on the exhibit, what is the most likely cause of the failure?

Clue words in this question

Noticing these words before you look at the options changes how you read each choice.

  • Clue: "most likely"

    Why it matters: Probability qualifier — the question wants the most probable cause or outcome, not a guaranteed one. Eliminate low-probability options.

Question 1hardmultiple choice
Full question →

Exhibit

{
  "connections": [
    {
      "name": "shared_office365",
      "id": "/providers/Microsoft.PowerApps/apis/shared_office365"
    },
    {
      "name": "shared_sql",
      "id": "/providers/Microsoft.PowerApps/apis/shared_sql"
    }
  ],
  "environment": {
    "name": "Production",
    "type": "Production",
    "region": "eastus"
  }
}

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

The flow is using the cloud SQL connector without an on-premises data gateway.

The exhibit shows a Power Automate flow using the SQL connector to access an on-premises SQL Server database. The SQL connector in Power Automate is a cloud-based connector that, by default, cannot directly reach on-premises resources. To bridge this gap, an on-premises data gateway must be installed and configured on a machine within the same network as the SQL Server, and the connector must be associated with that gateway. Without this gateway, the flow will fail with a connection error, making option B the correct answer.

Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • ✗

    The Office 365 connector is conflicting with the SQL connector.

    Why it's wrong here

    Multiple connectors can coexist in a flow without conflict.

  • ✓

    The flow is using the cloud SQL connector without an on-premises data gateway.

    Why this is correct

    The cloud SQL connector requires a gateway for on-premises databases.

    Clue confirmation

    The clue word "most likely" in the question point toward this answer.

    Related concept

    Read the scenario before looking for a memorised answer.

  • ✗

    The environment type is Production, which restricts access to on-premises data.

    Why it's wrong here

    Production environments can connect to on-premises data with a gateway.

  • ✗

    The region 'eastus' does not support on-premises connectivity.

    Why it's wrong here

    All Azure regions support on-premises data gateways.

Common exam traps

Common exam trap: answer the scenario, not the keyword

The trap here is that candidates may assume the SQL connector can directly access on-premises databases without any additional infrastructure, overlooking the mandatory requirement of an on-premises data gateway for hybrid connectivity.

Detailed technical explanation

How to think about this question

The on-premises data gateway works by establishing a secure outbound connection from the on-premises network to Azure Relay, which then allows cloud services like Power Automate to send requests through the gateway to the on-premises SQL Server. The gateway must be installed on a machine that can reach the SQL Server, and the connector in the flow must be configured with the gateway's name and credentials. A common subtlety is that the gateway service account must have appropriate permissions on the SQL Server, and the gateway itself must be online and not blocked by firewalls or proxy servers.

KKey Concepts to Remember

  • Read the scenario before looking for a memorised answer.
  • Find the constraint that changes the correct option.
  • Eliminate answers that are true in general but not in this case.

TExam Day Tips

  • Watch for words such as best, first, most likely and least administrative effort.
  • Review why wrong options are wrong, not only why the correct option is correct.

Key takeaway

Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.

Real-world example

How this comes up in practice

A company's IT admin needs to give a contractor read-only access to production logs without sharing account credentials. Using role-based access control (RBAC) and temporary scoped permissions — not a permanent shared password — is the correct pattern. Questions like this test whether you can apply least-privilege access across cloud identity services.

What to study next

Got this wrong? Here's your next step.

Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.

Related practice questions

Related PL-900 practice-question pages

Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.

Identify foundational components of Power Platform practice questions

Practise PL-900 questions linked to Identify foundational components of Power Platform.

Demonstrate capabilities of Power BI practice questions

Practise PL-900 questions linked to Demonstrate capabilities of Power BI.

Describe complementary Microsoft Power Platform solutions practice questions

Practise PL-900 questions linked to Describe complementary Microsoft Power Platform solutions.

Demonstrate the capabilities of Power Automate practice questions

Practise PL-900 questions linked to Demonstrate the capabilities of Power Automate.

Describe the business value of Microsoft Power Platform practice questions

Practise PL-900 questions linked to Describe the business value of Microsoft Power Platform.

Manage the Microsoft Power Platform environment practice questions

Practise PL-900 questions linked to Manage the Microsoft Power Platform environment.

Identify foundational components of Microsoft Power Platform practice questions

Practise PL-900 questions linked to Identify foundational components of Microsoft Power Platform.

Demonstrate the capabilities of Power BI practice questions

Practise PL-900 questions linked to Demonstrate the capabilities of Power BI.

Demonstrate the capabilities of Power Apps practice questions

Practise PL-900 questions linked to Demonstrate the capabilities of Power Apps.

Demonstrate the capabilities of Microsoft Copilot Studio practice questions

Practise PL-900 questions linked to Demonstrate the capabilities of Microsoft Copilot Studio.

Demonstrate the capabilities of Power Pages practice questions

Practise PL-900 questions linked to Demonstrate the capabilities of Power Pages.

PL-900 fundamentals practice questions

Practise PL-900 questions linked to PL-900 fundamentals.

Practice this exam

Start a free PL-900 practice session

Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.

10 questions20 questions30 questions50 questionsTimed 30
PL-900 practice-test guide →Study guide →Browse all practice tests

FAQ

Questions learners often ask

What does this PL-900 question test?

Describe the business value of Microsoft Power Platform — This question tests Describe the business value of Microsoft Power Platform — Read the scenario before looking for a memorised answer..

What is the correct answer to this question?

The correct answer is: The flow is using the cloud SQL connector without an on-premises data gateway. — The exhibit shows a Power Automate flow using the SQL connector to access an on-premises SQL Server database. The SQL connector in Power Automate is a cloud-based connector that, by default, cannot directly reach on-premises resources. To bridge this gap, an on-premises data gateway must be installed and configured on a machine within the same network as the SQL Server, and the connector must be associated with that gateway. Without this gateway, the flow will fail with a connection error, making option B the correct answer.

What should I do if I get this PL-900 question wrong?

Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.

Are there clue words in this question I should notice?

Yes — watch for: "most likely". Probability qualifier — the question wants the most probable cause or outcome, not a guaranteed one. Eliminate low-probability options.

What is the key concept behind this question?

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 →

How Courseiva writes practice questions · Editorial policy

Keep practising

More PL-900 practice questions

Browse all PL-900 questions →

Last reviewed: Jun 24, 2026

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.

Loading comments…

Sign in to join the discussion.

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.