dp-300 Practice Question 2008
Exam: dp-300
Domain: Implement a secure environment
Topic: Configure database authentication and authorization
Difficulty: medium
When setting up database authorization for a ledger table in SQL Server, which type of user should you use to ensure that the ledger table is protected and only accessible by specific roles or users within the database?
Answer Options
A
Use Microsoft Entra-only authentication.
B
Use contained database users.
C
Use Windows authentication.
D
Use SQL Server logins.
Correct Answer
B: Use contained database users.
Explanation
The correct answer is B because contained database users are appropriate for ledger tables as they do not require server-level logins and are scoped to the database. Option A is incorrect because Microsoft Entra-only authentication is used for authenticating users against Microsoft Entra ID, not for authorizing ledger table access. Option C is incorrect because Windows authentication is used for authenticating users against the Windows domain, not for authorizing ledger table access. Option D is incorrect because SQL Server logins are used for authenticating users at the server level, not for authorizing ledger table access.