You need to create a partition scheme that will place all data to the SECONDARY filegroup

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?

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:



Leave a Reply 0

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