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

An application role in SQL Server allows an application to connect to a database with a specific set of permissions that are independent of the individual user operating the application. The application activates this role by providing a password, thereby shifting the security context to the role's defined permissions for the session.

A database user typically represents an individual or service account and their access is tied to their specific login credentials, not an application-wide, user-independent context.

A server login authenticates a principal at the SQL Server instance level but does not grant database-specific object access independent of the individual user operating an application.

A server role groups logins and grants server-level permissions, which is not suitable for managing application-specific, database-level access independent of the individual user.