Microsoft
70-432 · Question #180
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…
The correct answer is G. Create a new table. See the full explanation below for the reasoning.
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 move the data from the oldest year into a new table in a different Schema to archive the data. 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:
How the community answered
(30 responses)- B3% (1)
- E13% (4)
- F10% (3)
- G70% (21)
- J3% (1)
Community Discussion
No community discussion yet for this question.