70-432 Sample Question : 5

QUESTION 5:

You administer two SQL Server 2008 instances named Instance1 and Instance2.A database named
Customers resides on Instance1.You move the Customers database from Instance1 to Instance2.
A SQL Server login named User1 that has the password "111999" is used by a user to access the
database on Instance1.You create the same SQL Server login on Instance2.The user attempts to access the Customers database on Instance2 by using the SQL Server login User1.However, the user receives an error message which indicates that the access to the Customers database is denied.You need to ensure that User1 can access the Customers database.Which Transact-SQL statements should you execute on Instance2?

A.USE Customers;ALTER USER User1 ENABLE;
B.USE Customers;ALTER LOGIN User1 WITH PASSWORD = '111999' UNLOCK;
C.USE Customers;ALTER USER User1 WITH LOGIN = User1;
D.USE Customers;ALTER LOGIN User1 WITH DEFAULT_DATABASE = Customers;

Answer: C