PrepAway - Latest Free Exam Questions & Answers

Which method should you use?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
ALTER TABLE …
SWITCH …

B.
INSERT … SELECT …Íž
TRUNCATE TABLE

C.
ALTER PARTITION FUNCTION …
MERGE …

D.
ALTER PARTITION FUNCTION …
SPLIT …


Leave a Reply