Microsoft
70-432 · Question #231
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…
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:
How the community answered
(29 responses)- A7% (2)
- B3% (1)
- E7% (2)
- H83% (24)
Community Discussion
No community discussion yet for this question.