Microsoft Power Platform Fundamentals — Question 307

Your company has an on-premises Microsoft SQL Server database that contains legacy sales data. You must display information from the database in a new
Power Apps app.
You need to establish a secure connection between the database and the app.
What should you use?

Answer options

Correct answer: C

Explanation

The correct answer is C, Data gateway, as it enables secure data transfer between on-premises databases and cloud services like Power Apps. Options A (Data source) and B (App) do not provide the necessary secure connection, while D (Power Automate) is more suited for automating workflows rather than establishing direct connections.