Microsoft
70-432 · Question #194
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 Quarter. You need to make the…
The correct answer is A. Remove the clustered index from the 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 Quarter. You need to make the table unpartitioned. 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
(49 responses)- A78% (38)
- B12% (6)
- E4% (2)
- H2% (1)
- J4% (2)
Community Discussion
No community discussion yet for this question.