HP HP ExpertONE Certification HP2-N36 Questions & Answers

• Question 21:

  What are features of using the Vertica backup script? (Select two.)

  A. It uses a lightweight locking protocol, stopping data loading for a brief period of time

  B. It can be run remotely via the Management Console

  C. It enables recovery by database, node, or table

  D. It enables backup of the entire database only

  E. It can be run while the database is not running.

  Correct Answer: BC

• Question 22:

  Which methods are available to optimize a projection for delete processing? (Select two.)

  A. Add a low cardinality column to the beginning of all projections on the source table.

  B. Add a high cardinality column to the end of all projections on the source table.

  C. Add all columns used as delete predicates to all projections on the source table.

  D. Add a low cardinality column to the end of all projections on the source table.

  E. Add a high cardinality column to the beginning of all projections on the source table.

  Correct Answer: AC

• Question 23:

  What is the process to add hosts to an existing cluster? (Select two.)

  A. Restart spread on all hosts in the cluster.

  B. Recreate all projections on the new hosts.

  C. Update spread.conf on the new host(s) only.

  D. Install Vertica on the new hosts.

  E. Redistribute data to the new host(s).

  Correct Answer: AE

• Question 24:

  What is the Resource Manager's role in query processing?

  A. serializing all requests to simulate concurrency

  B. determination and allocation of request importance

  C. determination and allocation of memory, threads, and file handles for the request

  D. allowing queries to run in place of background tasks

  Correct Answer: C

• Question 25:

  How are records marked for deletion?

  A. Vertica removes the file that stores the deleted data.

  B. Vertica rewrites the files that contained the deleted records, ignoring records to be deleted.

  C. Vertica deletes the records from the original source files.

  D. Vertica creates a delete vector, identifying records to be deleted.

  Correct Answer: D

• Question 26:

  What is the ROS?

  A. a redundant copy of commonly read data, cached in memory

  B. a column-store, disk-based method for storing data in Vertica

  C. a row-store, memory-based method for adding data to Vertica

  D. a redundant write-only location used to improve node uptime

  Correct Answer: C

• Question 27:

  How does mergeout purge data marked for deletion?

  A. It creates delete vectors, identifying files that can be removed from the system.

  B. It updates files by removing records marked with delete vectors.

  C. It writes undeleted records to files in a new location, then deletes all source files.

  D. It writes deleted records to files in a new location, then deletes all source files.

  Correct Answer: A

• Question 28:

  What is the WOS?

  A. a redundant copy of commonly read data, cached in memory

  B. a column-store, disk-based method for storing data in Vertica

  C. a redundant write-only location used to improve node uptime

  D. a row-store, memory-based method for adding data to Vertica

  Correct Answer: D

• Question 29:

  Which statement is true about the data directory location across the nodes of a cluster?

  A. It must be in the same location on each node.

  B. It can be stored in different formats on different nodes.

  C. It can be in different locations on each node.

  D. It must be in a single location, accessible to all nodes in the cluster.

  Correct Answer: D

• Question 30:

  Which task consolidates data containers, sorting, compressing, and purging data as needed?

  A. mergesync

  B. movesync

  C. mergeout

  D. moveout

  Correct Answer: C

  Reference:https://my.vertica.com/docs/6.1.x/HTML/index.htm#2624.htm#o14826