dp-300 Practice Question 2007
Exam: dp-300
Domain: Implement a secure environment
Topic: Configure database authentication and authorization
Difficulty: medium
In a scenario where you need to configure database authentication using Microsoft Entra-only authentication for a SQL Server database, which of the following steps should you take to ensure that only users with valid Microsoft Entra identities can access the database without needing to create SQL Server logins?
Answer Options
A
Create SQL Server logins for all users.
B
Configure Microsoft Entra-only authentication for the database.
C
Enable Windows authentication for the database.
D
Create contained database users for all users.
Correct Answer
B: Configure Microsoft Entra-only authentication for the database.
Explanation
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.