Microsoft
70-432 · Question #178
70-432 Question #178: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #178. The question stem and answer options stay visible for context.
Question
You administer a Microsoft SQL Server 2008 R2 database that contains an OrderItems table. The table has the following definition: Currently, the table is partitioned by year with each year in its own filegroup. You need to add a new partition for the upcoming year. What should you do?
Options
- ARemove the clustered index from the table.
- BUse the ALTER PARTITION FUNCTION ... SPLIT RANGE statement.
- CUse the ALTER TABLEstatement to remove the COLLATEoption.
- DExecute the DBCC CLEANTABLEcommand on the OrderItems table.
- ECreate a new filegroup.
- FCreate a new Filegroup.
- GCreate a new table.
- HCreate a new partition function.
- JRun the following statement:
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.