Administering a SQL Database Infrastructure — Question 162

You need to grant access to an OLTP database regardless of the user operating the application.
Which strategy should you use?

Answer options

• A. Application role
• B. Database user
• C. Server login
• D. Server role

Correct answer: A

Explanation

The correct answer is A, Application role, as it allows access to the database based on the application rather than individual users. Options B and C are tied to specific user accounts, which would not meet the requirement of granting access regardless of the user. Option D, Server role, manages permissions at the server level but does not specifically address the need for application-level access.