HP HP ExpertONE Certification HP2-N36 Questions & Answers

• Question 31:

  What are the benefits of loading data directly into ROS? (Select three.)

  A. The data is written to all projections on the source tables.

  B. The data is sorted.

  C. The data is unsorted.

  D. The data is stored in only the super projection, which then populates other projections on the table in the background.

  E. The data is in column format. The data is written in row format.

  Correct Answer: ABD

• Question 32:

  What are the benefits of loading data into WOS?

  A. The data is cached in memory for quick access.

  B. The data is able to be queried as soon as it is loaded.

  C. The data is broken out into projections.

  D. The data is sorted.

  Correct Answer: A

  Reference:https://my.vertica.com/docs/6.1.x/HTML/index.htm#10825.htm#o20112

• Question 33:

  What are the benefits of using delete vectors to identify records marked for deletion? (Select two.)

  A. Delete vectors move deleted records to files in a new location.

  B. Delete vectors enable historical queries of data marked for deletion until the data has been purged.

  C. Delete vectors rewrite the original files, immediately purging them off the system.

  D. Delete vectors are stored in a different location, minimizing storage impact.

  E. Delete vectors are a fast method for marking records for deletion.

  Correct Answer: BE

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

• Question 34:

  What are the actions of the moveout task? (Select two.)

  A. Moveout consolidates containers already on disk.

  B. Moveout places data into all defined projections on the source table.

  C. Moveout rewrites all ROS containers.

  D. Moveout moves data from memory to disk.

  E. Moveout writes data to memory.

  F. Moveout purges deleted data already on disk.

  Correct Answer: CD

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

• Question 35:

  What does the acronym RLE stand for?

  A. run language encoding

  B. random length encoding

  C. random language encoding

  D. run length encoding

  Correct Answer: D

  Reference:http://www.vertica.com/2010/05/26/why-verticas-compression-is-better/(paragraph right under illustration 1)

• Question 36:

  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

  Correct Answer: A

• Question 37:

  Which notation must be added to the COPY command to cause data to be placed directly in ROS?

  A. DISC

  B. DIRECT

  C. NOWOS

  D. ROS

  Correct Answer: B

  Reference:http://www.vertica.com/wp-content/uploads/2011/01/ FastDataLoadingInVertica.pdf(page 4)

• Question 38:

  What are the disadvantages of using delete vectors to identify records marked for deletion? (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.

  Correct Answer: CD

• Question 39:

  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.

  Correct Answer: A

• Question 40:

  What are the actions of the mergeout task? (Select three.)

  A. Mergeout rewrites all ROS containers.

  B. Mergeout writes data to memory.

  C. Mergeout consolidates containers on disk.

  D. Mergeout places data into all defined projections on the source table.

  E. Mergeout purges deleted data already on disk.

  F. Mergeout moves data from memory to disk.

  Correct Answer: CDE

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