You administer a Microsoft SQL Server 2008 R2 database that contains an OrderItems table. The table has the following definition:

Data is grouped into quarterly partitions. You need to configure the groupings into 12 monthly partitions. What should you do?

Question

You administer a Microsoft SQL Server 2008 R2 database that contains an OrderItems table. The table has the following definition:

Data is grouped into quarterly partitions. You need to configure the groupings into 12 monthly partitions. What should you do?

Accepted Answer

B. Use the ALTER PARTITION FUNCTION ... SPLIT RANGE statement.

Answer

A. Remove the clustered index from the table.

Answer

C. Use the ALTER TABLEstatement to remove the COLLATEoption.

Answer

D. Execute the DBCC CLEANTABLEcommand on the OrderItems table.

Answer

E. Create a new filegroup.

Answer

F. Create a new Filegroup.

Answer

G. Create a new table.

Answer

H. Create a new partition function.

Answer

J. Run the following statement:

You administer a Microsoft SQL Server 2008 R2 database that contains an OrderItems table. The table has the following definition: Data is grouped into quarterly partitions. You need to configure the…