HP HP ExpertONE Certification HP2-N36 Questions & Answers

• Question 41:

  What are key features of Vertica? (Select three.)

  A. uses fully custom SQL syntax

  B. columnar data store

  C. stored data that is encoded and compressed

  D. native high availability

  E. runs on a Windows platform

  F. data caching for fast retrieval

  Correct Answer: BCD

  Reference:http://www.vertica.com/the-analytics-platform/

• Question 42:

  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.

  Correct Answer: BC

• Question 43:

  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.

  Correct Answer: AD

• Question 44:

  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.

  Correct Answer: DE

• Question 45:

  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.

  Correct Answer: ADF

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

• Question 46:

  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.

  Correct Answer: AC

• Question 47:

  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.

  Correct Answer: D

• Question 48:

  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

  Correct Answer: A

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

• Question 49:

  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

  Correct Answer: B

• Question 50:

  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.

  Correct Answer: C

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