DP-300 Practice Test & Mock Exams

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.

The correct answer is B because configuring the storage account with the appropriate access tier and performance level ensures optimal performance and helps comply with data governance policies. Option A is incorrect as it does not mention the importance of setting the access tier and performance level. Option C is incorrect because it focuses on the wrong aspect; the primary concern is the storage account configuration rather than the managed instance itself. Option D is incorrect as it suggests enabling encryption without mentioning the need for setting the access tier and performance level.

The correct answer is B because configuring Microsoft Entra-only authentication ensures that only users with valid Microsoft Entra identities can access the database. Option A is incorrect because it involves creating SQL Server logins, which is not necessary when using Microsoft Entra-only authentication. Option C is incorrect because it suggests enabling Windows authentication, which is not relevant in this context. Option D is incorrect because it refers to contained database users, which are not suitable for Microsoft Entra-only authentication.