Administering Microsoft SQL Server 2012/2014 Databases — Question 57

You administer a single server that contains a Microsoft SQL Server 2012 default instance on which several production databases have been deployed.
You plan to install a new ticketing application that requires the deployment of a database on the server. The SQL login for this application requires sysadmin permissions.
You need to ensure that the login for the ticketing application cannot access other production databases.
What should you do?

Answer options

• A. Use the SQL Server default instance and enable Contained Databases.
• B. Use the SQL Server default instance and configure a user-defined server role. Add the login for the ticketing application to this role.
• C. Install a new named SQL Server instance on the server.
• D. Install a new default SQL Server instance on the server.

Correct answer: C

Explanation

The correct answer is C because installing a new named SQL Server instance creates an isolated environment, allowing you to grant sysadmin permissions to the ticketing application's login without impacting access to production databases. Options A and B do not provide the necessary isolation, while option D does not achieve the desired outcome of limiting access to the production databases.