Exam DP-300 topic 2 question 38 discussion

Actual exam question from Microsoft's DP-300

Question #: 38
Topic #: 2

HOTSPOT
-

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.

Show Suggested Answer

Suggested Answer:

by U_C at April 6, 2023, 4:03 a.m.

Comments

Submit Cancel

jerrychan

Highly Voted 9 months ago

reference: https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-service-tags?source=recommendations The following configurations are necessary to successfully enable the endpoints for use in the Power BI service: 1. Enable a public endpoint in the SQL Managed Instance. 2. Create a Network Security Group rule to allow inbound traffic. 3. Enter the credentials in Power BI. So the answer is correct.

upvoted 5 times

voodoo_sh

5 months, 3 weeks ago

Endpoint Type: Public Control Connections: NSG Enable public endpoint in SQL MI, and then you can open up port 3342 via the NSG inbound rules. For the new inbound rule, make sure to specify: Source: Service Tag Source service tag: Power BI

upvoted 1 times

...

vcloudpmp

Most Recent 11 months, 2 weeks ago

https://www.datahai.co.uk/power-bi/connecting-power-bi-to-azure-sql-database-using-private-endpoints/ https://community.fabric.microsoft.com/t5/Power-Query/Azure-SQL-Server-Managed-Instance/m-p/377418#M16216 https://community.powerbi.com/t5/Power-Query/Azure-SQL-Server-Managed-Instance/m-p/376246 https://www.mssqltips.com/sqlservertip/5953/create-power-bi-connection-to-azure-sql-database/

upvoted 1 times

...

U_C

1 year, 2 months ago

The answer is correct

upvoted 2 times

...

U_C

1 year, 2 months ago

To configure connectivity from the Power BI service to an Azure SQL managed instance, you should use a Public endpoint for SQL1 1. You can control the connections to SQL1 by using a Network Security Group (NSG) 1. Therefore, the correct answer is Endpoint type: Public and Control connections by using: A network security group (NSG).

upvoted 4 times

...