Home » Microsoft » 70-765 » Which type of user should you create?
You use a contained database named ContosoDb within a domain.
You need to create a user who can log on to the ContosoDb database. You also need to ensure that you can port the database to different database servers within the domain without additional user account configurations.
Which type of user should you create?
A. SQL user without login
B. User mapped to an asymmetric key
C. Domain user
D. login mapped to a virtual account
Correct Answer: C
Explanation/Reference:
Explanation:
If the service must interact with network services, access domain resources like file shares or if it uses linked server connections to other computers running SQL Server, you might use a minimally-privileged domain account. Many server-toserver activities can be performed only with a domain user account.
References: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-windows-service-accounts-and-permissions