DP-800MODULE QUIZ
Exit

Design and develop database solutions

Question 1 of 87

In Azure SQL Database, dbo.FactOrderHistory uses monthly RANGE LEFT partitions with aligned indexes, and partition 1 contains the oldest month. That month's rows must remain available in dbo.Archive, which does not exist, while its range is retired from the operational table without moving retained rows. Arrange the required actions in order. Not all options are used.

Drag the options into the answer area in the correct order.
AVAILABLE OPTIONS

Run ALTER PARTITION FUNCTION with MERGE RANGE at the lowest boundary of the function used by dbo.FactOrderHistory.

Create dbo.Archive on PRIMARY with columns, indexes, and a range constraint compatible with the oldest month of dbo.FactOrderHistory.

Run ALTER PARTITION SCHEME with NEXT USED [PRIMARY] on the partition scheme used by dbo.FactOrderHistory.

Run ALTER TABLE dbo.FactOrderHistory SWITCH PARTITION 1 TO dbo.Archive to reassign the oldest partition's data.

Run UPDATE STATISTICS dbo.FactOrderHistory WITH FULLSCAN to refresh the table's optimizer statistics.

ANSWER AREA
Drag options here