You need to ensure that the application login is unable to access other production databases

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?

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.

Show Hint

Leave a Reply 4

Your email address will not be published. Required fields are marked *

Philomena

Philomena

What iss thᥱ official coach factory outlet website shopping nnhl shop
black ᖴriday deals Coach factory outlet sales ᥙѕa

Reply

Google

Google

Here are a number of the web-sites we recommend for our visitors.

Reply

Lee

Lee

I also think ‘b’ because sysadmin can access anything from within that SQL instance. A named instance that is dedicated to that database is the way to go.

Reply