You administer a Microsoft SQL Server 2008 R2 database that contains an OrderItems
table. The table has the following definition:
The following DDL has been run on the database:
CREATE PARTITION FUNCTION FUNC_FG (INT)
AS RANGE LEFT FOR VALUES (1, 100, 1000);
You need to create a partition scheme that will place all data to the SECONDARY filegroup.
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’;
Explanation: