Please explain and approve the answer you will choose because I need to understa
ID: 3576910 • Letter: P
Question
Please explain and approve the answer you will choose because I need to understand this very well
Please explain and approve the answer you will choose because I need to understand this very well
You are working for a large company as a junior DBA. our company maintains 3 larger database servers or instances. Within each server instance, the company maintains numerous databases Obviously within each database is numerous schemas and tables. Recently your company hired 10 summer interns to help out. These 10 new employees will need to do various tasks on varous servers/instances and databases. How should you set up their login ids? O Create a log in ids for all three servers and user ids for a of the databases on the servers O Create a user id for all three servers and log in ids for all of the databases on the servers. Analyze the needs of the various interns. Some may not have to access to the entire system Produce log ins and use ids based need. Group as many of these as you can to speed up the process. ork with your OS co workers to produce the proper Windows log ins. Once the Windows log in exists the interns will automatically be able to connect to SQL Server.Explanation / Answer
For first Question the answer will be option 3 that is Analyze the need of the various interns, some may not have to access to entire system. Produces login and user id based needs. Group as many of these as you can to speed up the process. As per information security policy in each and every company should have to follow specific permission policy for each and every employee. For this reason only give valid permission to user only as per requirements and company need for proper data security.
For second question answer is option 1 that is create a view calles MailingLables and make sure the administrative staff has access to that view beacuse they want to view the data only but not want to perform any changes in database table.Creating View they will be assigned only read only access to those table and can be easily access their required data from database.