Microsoft
70-433 · Question #117
You have two tables named MainTable and ArchiveTable. You need to move data older than 30 days from MainTable into ArchiveTable. Which code segment should you use?
The correct answer is B. DELETE FROM MainTable. See the full explanation below for the reasoning.
Question
You have two tables named MainTable and ArchiveTable. You need to move data older than 30 days from MainTable into ArchiveTable. Which code segment should you use?
Options
- ADELETE FROM MainTable
- BDELETE FROM MainTable
- CINSERT INTO ArchiveTable
- DINSERT INTO ArchiveTable
How the community answered
(34 responses)- A15% (5)
- B76% (26)
- C6% (2)
- D3% (1)
Community Discussion
No community discussion yet for this question.