Microsoft
70-432 · Question #231
70-432 Question #231: Real Exam Question with Answer & Explanation
The correct answer is H. Create a new partition function.. 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 not partitioned and contains no indexes. You need to partition the table by year. What should you do?
Exhibit
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:
Community Discussion
No community discussion yet for this question.