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.
What iss thᥱ official coach factory outlet website shopping nnhl shop
black ᖴriday deals Coach factory outlet sales ᥙѕa
0
0
b
0
0
Here are a number of the web-sites we recommend for our visitors.
0
0
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.
0
0