Microsoft Power Platform Fundamentals — Question 103

A company is creating a canvas app to display data from a legacy SQL Server database that is located on the company's internal network.
You need to connect to the data.
What should you use?

Answer options

• A. custom connector
• B. content pack
• C. data gateway
• D. Power BI

Correct answer: C

Explanation

The correct answer is C, as a data gateway is specifically designed to facilitate secure connections between on-premises data sources, like a SQL Server database, and cloud services. The other options, such as a custom connector, content pack, and Power BI, do not provide the necessary capability to connect directly to an internal database.