How many SQL Server instances should you add to SQL1?

You have a server named SQL1 that has SQL Server installed. SQL1 hosts several applications.
You plan to deploy a third-party application to SQL1. 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 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 in 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

microsoft-exams

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.