HP HP2-N36 Online Practice Questions and Exam Preparation

HP HP2-N36 Online Questions & Answers

• Question 31:

  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.
  A. It creates delete vectors, identifying files that can be removed from the system.

• Question 32:

  What is available on the Jobs chart in the Management Console? (Select two)

  A. loading status and errors
  B. resource pool usage
  C. memory usage
  D. recovery progress and errors
  E. query performance
  A. loading status and errors
  D. recovery progress and errors

• Question 33:

  Which statements are true of a projection? (Select two.)

  A. They can contain a comparison predicate.
  B. They can contain a join condition.
  C. They can only be created prior to loading data.
  D. They can be created at any time, either before or after data is loaded into a table.
  E. They can contain aggregate functions.
  B. They can contain a join condition.
  C. They can only be created prior to loading data.

• Question 34:

  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
  B. DIRECT

  ---

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

• Question 35:

  What is a Vertica cluster?

  A. a collection of projection files
  B. a grouping of several Vertica databases
  C. the set of nodes running one instance of Vertica
  D. a physical machine configured to run an instance of Vertica
  B. a grouping of several Vertica databases

• Question 36:

  What is a difference between maxconcurrency and plannedconcurrency?

  A. Maxconcurrency is a hard limit to the number of queries running within a pool; plannedconcurrency is used to create a query budget.
  B. Maxconcurrency is used to create a query budget; plannedconcurrency is a hard limit to the number of queries running within a pool.
  C. Maxconcurrency is a hard limit to the number of queries running within a pool; plannedconcurrency limits the number of queries running on the cluster.
  D. Maxconcurrency limits the number of queries running on the cluster; plannedconcurrency is a hard limit to the number of queries running within a pool.
  C. Maxconcurrency is a hard limit to the number of queries running within a pool; plannedconcurrency limits the number of queries running on the cluster.

• Question 37:

  What is local segmentation capability in Vertica?

  A. Vertica automatically splits current segments in half to redistribute them to new nodes.
  B. Vertica automatically partitions the data, allowing partitions to be dropped and recreated on new nodes.
  C. Vertica automatically creates more segments than are currently needed, allowing some segments to be moved to new nodes as needed.
  D. Vertica automatically partitions the segmented data, allowing some partitions to be moved to new nodes as needed.
  D. Vertica automatically partitions the segmented data, allowing some partitions to be moved to new nodes as needed.

  ---

  Reference:http://vertica-forums.com/viewtopic.php?f=5andt=874

• Question 38:

  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.
  D. It must be in a single location, accessible to all nodes in the cluster.

• Question 39:

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

  A. mergesync
  B. movesync
  C. mergeout
  D. moveout
  C. mergeout

  ---

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

• Question 40:

  What distinguishes table partitioning from projection segmentation?

  A. If table data is partitioned, associated projections can only be replicated.
  B. If table data is partitioned, the table cannot participate in a prejoin projection.
  C. If table data is partitioned, associated projections cannot be segmented.
  D. If table data is partitioned, associated projections can also be segmented.
  D. If table data is partitioned, associated projections can also be segmented.