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?
A.
Remove the clustered index from the table.
B.
Use the ALTER PARTITION FUNCTION … SPLIT RANGE statement.
C.
Use the ALTER TABLEstatement to remove the COLLATEoption.
D.
Execute the DBCC CLEANTABLEcommand on the OrderItems table.
E.
• Create a new filegroup.
• Create a new database file.
• Use the ALTER PARTITION SCHEME statement along with the NEXT USED clause.
• Use ALTER INDEX REORGANIZE statement.
F.
• Create a new Filegroup.
• Create a new database File.
• Use the ALTER PARTITION SCHEME statement along with the NEXT USED clause.
• Use the ALTER PARTITION FUNCTION statement along with the SPLIT RANGE clause.
G.
• Create a new table.
• Use the ALTER TABLE statement along with the SWITCH PARTITION clause.
• Use the ALTER PARTITION FUNCTION statement along with the MERGE RANGE clause.
H.
• Create a new partition function.
• Create a new partition scheme.
• Add a clustered index to place the data onto the partition scheme.
I.
Run the following statement:
CREATE PARTITION SCHEME SEC_FG
AS PARTITION FUNC_FG
ALL TO (SECONDARY);
J.
Run the following statement:
EXECUTE sp_tableoption
@TableNamePattern =’OrderItem3′,
@OptionName= ‘PartltionByYear’;
@OptionValue= ‘true’;