Describe the business value of Microsoft Power Platform →hardMultiple ChoiceObjective-mapped

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

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?

⚠ Common exam trap

A common mix-up: candidates 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.

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.

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.
✗
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.

Go deeper

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

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question