You have a server named SQL1 mat has SQL Server installed SQU hosts several applications. You plan to deploy a third-party application to SQU.
The application must have the following:
* A vendor-provided password for the sa account
* A vendor-provided user account that is a member of the sysadmin fixed server role
* A vendor-provided user account that is a member of the db.owner fixed database role in the msdb database
* A vendor-provided user account that is a member of the db.owner fixed database role in the master database
* A vendor-provided user account that is a member of the SQLAgentOperatorRole fixed database role m the msdb
Database You need to identify the minimum number of SQL Server instances that you must add to SQL1 to support the application requirements. The solution must use the principle of least privilege
How many SQL Server instances should you add to SQL1?
A . 0
B . 1
C . 2
D . 3
Answer: D
Leave a Reply