How should you complete the Transact-SQL statement?

HOTSPOT
You are the administrator of a database that hosts tables for a data warehouse.
The table named Fact1 has data from the start of calendar year 2011 through the end of 2017. The table contains at least 20 million rows of data for each year.
You create the table by running the following Transact-SQL statement:
CREATE PARTITION FUNCTION PartitionFunc-Fact1(SMALLINT)
AS RANGE LIFT VALUES(2012, 2013, 2014, 2015)
You need to modify the partition function so that rows for each calendar year are in a separate partition. You must also move all data prior to 2014 to another table named Fact1_old.
How should you complete the Transact-SQL statement? To answer, select the appropriate Transact-SQL segment in the dialog box in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

microsoft-exams

One thought on “How should you complete the Transact-SQL statement?

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.