You need to add a new partition for the upcoming year

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?

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’;



Leave a Reply 0

Your email address will not be published. Required fields are marked *