HP HP2-N36 - HP Vertica Solutions [2012] Exam

Page:    1 / 10   
Total 50 questions

What does Time Series do?

  • A. enables identification of a sequence of defined events
  • B. evaluates the values of a given set of variables and groups those values into a window
  • C. increments a counter based on whether an expression evaluates as true
  • D. enables analysis of two series of data when their measurement intervals do not align precisely


Answer : B

During Vertica installation, how do you install onto multiple nodes of a cluster?

  • A. You must install the application individually on each node.
  • B. Run the installation script from the Console machine once per node.
  • C. Pass the IP address or node names as part of the -s argument, and it will install the application on each node.
  • D. Pass the IP addresses or node names to spread, and it will install the application on each node.


Answer : C

Reference:https://my.vertica.com/wbt/installing_vertica/index.htm(start the video and go the topic that says multiple node installation)

What are the benefits of ordering data in projection design? (Select two.)

  • A. It enables optimum encoding.
  • B. It enables partitioning of data.
  • C. It enables efficient sharing of data between similarly-ordered projections.
  • D. It enables efficient application of query predicates.
  • E. It enables segmentation of data.


Answer : D,E

What are characteristics of projections in Vertica? (Select three.)

  • A. A projection can contain data from one or more source tables.
  • B. A projection can contain data from only one source table.
  • C. A projection can contain a subset of rows from the source table.
  • D. Each projection contains all rows from the source table.
  • E. A projection can contain a subset of columns from the source table.
  • F. Each projection contains all columns from the source table.


Answer : A,D,F

Reference:http://184.106.12.19/2011/09/02/the-power-of-projections-part-2/

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.


Answer : A,C

Page:    1 / 10   
Total 50 questions