Which code segment should you execute?

You have a SQL Server 2012 database named DB1. DB1 contains four filegroups named FG1, FG2, FG3, and
FG4. You execute the following code:

Two million rows are added to dbo.Sales.
You need to move the data from the first partition to a new table named SalesHistory and, starting on
December 31, 2012, repartition dbo.Sales to support new sales data for three months.
Which code segment should you execute?
To answer, move the appropriate code segments from the list of code segments to the answer area and
arrange them in the correct order.
Select and Place:

You have a SQL Server 2012 database named DB1. DB1 contains four filegroups named FG1, FG2, FG3, and
FG4. You execute the following code:

Two million rows are added to dbo.Sales.
You need to move the data from the first partition to a new table named SalesHistory and, starting on
December 31, 2012, repartition dbo.Sales to support new sales data for three months.
Which code segment should you execute?
To answer, move the appropriate code segments from the list of code segments to the answer area and
arrange them in the correct order.
Select and Place:

Answer:

Explanation:
Note:
* Box 1 Box 2:
/ You need to move the data from the first partition to a new table named SalesHistory. / First create the new
table, then move the contents of the first partition. *( Box 3 Box 4) Drop the partition scheme and then the
partition function and the recreate them (box 5-box6). First recreate the partition function.
/You need, starting on December 31, 2012, repartition dbo.Sales to support new sales data for three months.
/ A partition function can be dropped only if there are no partition schemes currently using the partition function.
If there are partition schemes using the partition function, DROP PARTITION FUNCTION returns an error.



Leave a Reply 1

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


Tina

Tina

The correct solution is:

CREATE TABLE SalesHistory
(date_key INT NOT NULL, customer_KEY int,
amount MONEY)
ON FG1;

ALTER TABLE Sales SWITCH PARTITION 1 TO SalesHistory;
ALTER PARTITION FUNCTION pf1() MERGE RANGE (20120331);
ALTER PARTITION FUNCTION pf1() SPLIT RANGE (20121231);