Microsoft
70-432 · Question #122
70-432 Question #122: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #122. The question stem and answer options stay visible for context.
Question
You administer a SQL Server 2008 instance that contains a database named DB1. A table named Sales.Table1 exists in the Sales schema. You need to move the Sales.Table1 table to a new schema named Billing. Which Transact-SQL statement should you execute?
Options
- AALTER SCHEMA Billing TRANSFER Sales.Table1;
- BALTER USER Sales WITH DEFAULT_SCHEMA = Billing;
- CALTER AUTHORIZATION ON Sales.Table1 TO Billing:
- DALTER TABLE Sales.Table1 SWITCH TO Billing.Table1;
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.