You are the administrator of a SQL Server system that will contain marketing, sales, and production data. Each of these departments is contains in a Windows group named after the department. Each of these departments should be able to read and modify its own data, but they should not be able to read or modify that data of other departments. You need to configure the server so it meets security requirements with minimal administrative overhead and resource consumption. What should you do?
D – Create a Windows Authenticated login for each department.
F – Map each user account to the db_datareader and db_datawriter database roles.
H – Create database user accounts for each department in the database.
(In this instance, you should create a separate database for each of the departments so they do not have access to the other departments’ data. You also need to create a login for each of the groups and then create a database user account in the corresponding database for each login. Finally, add the accounts to the db_datareader and db_datawriter roles.)