PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

A.
SQL user without login

B.
User mapped to an asymmetric key

C.
Domain user

D.
login mapped to a virtual account

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-to-server activities can be performed only with a domain user account.
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-windowsservice-accounts-and-permissions


Leave a Reply