dp-300 Practice Question 2005
Exam: dp-300
Domain: Plan and implement data platform resources
Topic: Deploy resources by using manual methods
Difficulty: medium
In a scenario where you need to provision an Azure SQL Managed Instance in a specific region with a custom endpoint, which of the following steps should you take to ensure the instance is correctly configured and accessible from a virtual network in the same subscription?
Answer Options
A
Create the virtual network and then the managed instance.
B
Create the managed instance with the custom endpoint and then configure virtual network integration.
C
Create the managed instance and then create the virtual network.
D
Configure virtual network integration after creating both the managed instance and the virtual network.
Correct Answer
B: Create the managed instance with the custom endpoint and then configure virtual network integration.
Explanation
The correct answer is B because you must first create the Azure SQL Managed Instance with the specified endpoint and then configure the virtual network integration to allow the managed instance to communicate with the virtual network. Option A is incorrect because it does not address the need for virtual network integration. Option C is incorrect as it suggests creating the virtual network before the managed instance, which is not necessary and could lead to misconfiguration. Option D is incorrect because it implies that the virtual network integration can be done after the managed instance is created without any prior steps.