You administer a single server that contains a Microsoft SQL Server 2012 default instance.
You plan to install a new application that requiresthe deployment of a database on the server.
The application login requires sysadmin permissions.
You need to ensure that the application login is unable to access other production databases. What should you
do?
A.
Use the SQL Server default instance and configurean affinity mask.
B.
Install a new named SQL Server instance on the server.
C.
Use the SQL Server default instance and enable Contained Databases.
D.
Install a new default SQL Server instance on the server.
Explanation:
I would have gone with Contained Databases, but theapplication requires sysadmin permissions.
C
https://msdn.microsoft.com/en-us/library/ff929071%28v=sql.110%29.aspx
@Walter: Right answer is option B.
For contained databases, maintaining db settings in the CDB (instead of in the MASTER database), lets each database owner have more control over their database, without giving the database owner sysadmin permissions.
The question here states that “The application login requires sysadmin permissions”; hence, CDB wouldn’t work. You have to install a new named SQL server instance for the application.
You need to ensure that the application login is unable to access other production databases
so answer is C