HP HP2-N36 Online Practice Questions and Exam Preparation

HP HP2-N36 Online Questions & Answers

• Question 21:

  What does the acronym RLE stand for?

  A. run language encoding
  B. random length encoding
  C. random language encoding
  D. run length encoding
  D. run length encoding

  ---

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

• Question 22:

  What are the differences between compression and encoding? (Select two.)

  A. Compressed data can be queried prior to materializing the data.
  B. Queries can be processed against compressed data, speeding query response time.
  C. Both reduce the storage footprint.
  D. Queries can be processed against encoded data, speeding query response time.
  E. Encoding reduces only the storage footprint.
  A. Compressed data can be queried prior to materializing the data.
  D. Queries can be processed against encoded data, speeding query response time.

• Question 23:

  What is the purpose of Vertica's transaction model? (Select three.)

  A. Transactions mean that undo logs are not needed.
  B. Transactions are used to maintain partitions.
  C. Transactions are only written upon an explicit commit being issued.
  D. Transactions are used for data recovery.
  E. Transactions are used to delete data.
  F. Transactions are used to maintain segmentation.
  A. Transactions mean that undo logs are not needed.
  C. Transactions are only written upon an explicit commit being issued.

• Question 24:

  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.
  C. Moveout rewrites all ROS containers.
  D. Moveout moves data from memory to disk.

  ---

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

• Question 25:

  Which statement is true about a query explain plan?

  A. It determines how to run the query, runs it, and returns the result.
  B. It writes the SQL to execute a query.
  C. It tells exactly how many rows will be returned by the query.
  D. It displays the results of Optimizer to the user, showing projection(s) used and the query process.
  B. It writes the SQL to execute a query.

• Question 26:

  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.
  A. Dropping a partition creates delete vectors; deleting records does not create delete vectors.

• Question 27:

  What is a buddy projection?

  A. a projection that contains the same columns and has the same segmentation as the original projection, using different node ordering, stored in different files on the same node as the original
  B. a projection that contains a subset of rows from the original projection, stored in different files on a neighboring node of the original
  C. a projection that contains the same columns and has the same segmentation as the original projection, using different node ordering, stored in different files on a different node than the original
  D. a projection that contains a subset of rows from the original projection, stored in different files on the same node as the original
  A. a projection that contains the same columns and has the same segmentation as the original projection, using different node ordering, stored in different files on the same node as the original

  ---

  Reference:http://vertica-forums.com/viewtopic.php?f=7andt=441

• Question 28:

  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.
  D. Vertica creates a delete vector, identifying records to be deleted.

• Question 29:

  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.
  A. The data is cached in memory for quick access.

  ---

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

• Question 30:

  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.
  A. The data is written to all projections on the source tables.
  B. The data is sorted.
  D. The data is stored in only the super projection, which then populates other projections on the table in the background.