You administer a single server that contains a Microsoft S

QL Server 2016 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?

A. Use the SQL Server default instance and configure an 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.

SQL Server supports multiple instances of SQL Server on a single server or processor, but only one instance can be the default instance. All others must be named instances. A computer can run mul

tiple instances of SQL Server concurrently, and each instance runs independently of other instances.

References: https://msdn.microsoft.com/en-us/library/ms143531(v=SQL.105).aspx