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 year with
each year in its own filegroup.
You need to add a new partition for the upcoming year.
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’;