You have two partitioned tables named Transaction and TransactionHistory.
You need to archive one of the partitions of the Transaction table to the TransactionHistory table.
Which method should you use?
A.
ALTER TABLE …
SWITCH …
B.
INSERT … SELECT …; TRUNCATE TABLE
C.
ALTER PARTITION FUNCTION … MERGE …
D.
ALTER PARTITION FUNCTION …
SPLIT …