HP
HP2-N36 · Question #31
What is the difference between dropping a partition and deleting records?
The correct answer is D. Dropping a partition recovers space immediately; deleting records does not recover space. See the full explanation below for the reasoning.
Question
What is the difference between dropping a partition and deleting records?
Options
- ADropping a partition creates delete vectors; deleting records does not create delete vectors.
- BDropping a partition can be rolled back; deleting records cannot be rolled back.
- CDropping a partition creates new files; deleting records does not create new files.
- DDropping a partition recovers space immediately; deleting records does not recover space
How the community answered
(17 responses)- A18% (3)
- B6% (1)
- C6% (1)
- D71% (12)
Community Discussion
No community discussion yet for this question.