DP-300 Certification Practice Question #99

Question

You have an Azure subscription that contains an Azure SQL managed instance named SQL1.

You use the Microsoft Power BI service.

You need to configure connectivity from the Power BI service to SQL1. The solution must ensure that only the Power BI service can initiate connections to SQL1.

Which type of endpoint should you use for SQL1, and what should you use to control the connections to SQL1? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Accepted Answer

The Power BI service is a Microsoft SaaS service that cannot use private endpoints or VNet service endpoints for outbound connections. The only supported connectivity method for Power BI to Azure SQL Managed Instance is via the public endpoint (port 3342). To restrict connections so only Power BI can initiate them, you create an NSG inbound rule with the Power BI service tag as the source — this is the recommended control mechanism for SQL MI (which uses NSGs, not Azure SQL Database firewall rules).

More DP-300 practice questions