Skip to Content

PL-400: Which Authentication Option Should You Use for Custom Connectors with SQL Server via On-Premises Gateway?

How to Securely Connect Power Platform Custom Connectors to SQL Server Using the Right Authentication Method?

Table of Contents

Question

You are developing a custom connector that will connect to a SQL Server instance by using an on-premises data gateway.

You need to ensure that users can create a connection by using the custom connector.

Which authentication option should you use?

Select only one answer.

A. API Key
B. Basic
C. OAuth 2.0
D. SQL Server
E. Windows

Answer

E. Windows

Explanation

This item tests the candidate’s knowledge of implementing authentication for custom connectors.

Windows authentication is available for connections that make use of an on-premises data gateway. There are several authentication mechanisms available for the custom connector that allow access to secure REST API services. Basic authentication prompts the user to enter User and Password to create a connection. The OAuth 2.0 authentication option is available only for online connectors. The API Key authentication option is mostly used by web services.

Microsoft Power Platform Developer PL-400 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Microsoft Power Platform Developer PL-400 exam and earn Microsoft Power Platform Developer PL-400 certification.