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.
SQL user with a custom SID
C.
SQL user with login
D.
Domain user
Answer is D: Domain User
0
0
D or A
i dont know
0
0
the correct answer is D
If you move the database to a different server in the same domain the user still be able to access the data.
0
0
The answer is D. The only type of users that isn’t linked to the actual SQL Server instance, but to something in the domain, is the account based on the domain user (so A and C are invalid, since they are bound to the instance).
Custom SID don’t have to do anything with it, so that would make B invalid too
0
0
D
0
0
Anybody knows about the new questions which are not in 70-461 (v.4).
Please help.
Thanking in advance.
Md
0
0
Answer is D
0
0
Answer is A
https://docs.microsoft.com/en-us/sql/relational-databases/security/contained-database-users-making-your-database-portable?view=sql-server-2017
0
0