Microsoft
70-432 · Question #178
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 F. Create a new Filegroup. 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 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:
How the community answered
(60 responses)- A10% (6)
- D2% (1)
- E5% (3)
- F78% (47)
- G3% (2)
- J2% (1)
Community Discussion
No community discussion yet for this question.