nerdexam
HP

HP2-N36 · Question #7

How are records marked for deletion?

The correct answer is D. Vertica creates a delete vector, identifying records to be deleted. See the full explanation below for the reasoning.

Question

How are records marked for deletion?

Options

  • AVertica removes the file that stores the deleted data.
  • BVertica rewrites the files that contained the deleted records, ignoring records to be deleted.
  • CVertica deletes the records from the original source files.
  • DVertica creates a delete vector, identifying records to be deleted.

How the community answered

(50 responses)
  • A
    8% (4)
  • B
    18% (9)
  • C
    4% (2)
  • D
    70% (35)

Community Discussion

No community discussion yet for this question.

Full HP2-N36 Practice