HP HP2-N36 - HP Vertica Solutions [2012] Exam
Page: 3 / 10
Total 50 questions
Question #11 (Topic: )
What does the acronym RLE stand for?
A. run language encoding
B. random length encoding
C. random language encoding
D. run length encoding
Answer: D
Question #12 (Topic: )
How does Vertica implement high availability in a clustered environment?
A. full replicas of fact tables and segmented dimension tables
B. full replicas of all data on all nodes
C. built-in redundancy of data
D. continuous mirroring of data
Answer: A
Question #13 (Topic: )
Which notation must be added to the COPY command to cause data to be placed directly
in ROS?
in ROS?
A. DISC
B. DIRECT
C. NOWOS
D. ROS
Answer: B
Question #14 (Topic: )
What are the disadvantages of using delete vectors to identify records marked for deletion?
(Select two.)
(Select two.)
A. Delete vectors are stored in a different location, minimizing storage impact.
B. Delete vectors rewrites files, causing additional overhead.
C. Delete vectors must be recognized during the query process to remove records marked for deletion from the result set, slowing down the processing of a query.
D. Delete vectors do not instantly reclaim space used by deleted records.
E. Delete vectors must be maintained forever.
Answer: C,D
Question #15 (Topic: )
What is the difference between dropping a partition and deleting records?
A. Dropping a partition creates delete vectors; deleting records does not create delete vectors.
B. Dropping a partition can be rolled back; deleting records cannot be rolled back.
C. Dropping a partition creates new files; deleting records does not create new files.
D. Dropping a partition recovers space immediately; deleting records does not recover space immediately.
Answer: A
