You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_DB. CK_DB contains a table named CK_Prod
where the Sales Product resides. You have received instruction to move CK_Prod’ test to a new
schema named CK_Tester. You need to complete this task using the appropriate Transact-SQL statement.
What should you do?
A.
You should consider adding the following:
ALTER TABLE Products. Test SWITCH TO CK_Tester.Table1;
B.
You should consider adding the following:
ALTER AUTHORIZATION ON Products. Test TO CK_Tester;
C.
You should consider adding the following:
ALTER USER Products WITH DEFAULT_SCHEMA = CK_Tester;
D.
You should consider adding the following:
ALTER SCHEMA CK_Tester TRANSFER Products. Test.