Microsoft
70-457 · Question #124
You administer a single server that contains a Microsoft SQL Server 2012 default instance. You plan to install a new application that requires the deployment of a database on the server. The…
The correct answer is B. Install a new named SQL Server instance on the server. See the full explanation below for the reasoning.
Question
You administer a single server that contains a Microsoft SQL Server 2012 default instance. You plan to install a new application that requires the 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?
Options
- AUse the SQL Server default instance and configure an affinity mask.
- BInstall a new named SQL Server instance on the server.
- CUse the SQL Server default instance and enable Contained Databases.
- DInstall a new default SQL Server instance on the server.
How the community answered
(15 responses)- A20% (3)
- B73% (11)
- C7% (1)
Community Discussion
No community discussion yet for this question.