Microsoft
70-433 · Question #204
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…
The correct answer is B. INSERT ... SELECT ...; TRUNCATE TABLE. See the full explanation below for the reasoning.
Question
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?
Options
- AALTER TABLE ...
- BINSERT ... SELECT ...; TRUNCATE TABLE
- CALTER PARTITION FUNCTION ... MERGE ...
- DALTER PARTITION FUNCTION ...
How the community answered
(39 responses)- A5% (2)
- B72% (28)
- C8% (3)
- D15% (6)
Community Discussion
No community discussion yet for this question.