HP2-N36 exam course

HP

Code: HP2-N36

Exam Name: HP Vertica Solutions

[2012]

http://www.itexamtest.com/HP2-N36.html

Question: 1

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

Answer: B

Question: 2

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 lP address or node names as part of the -s argument, and it will install the application on

D. each node,

E. Pass the IP addresses or node names to spread and it will install the application on each node.

Answer: C

Question: 3

What are the benefits of ordenng 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: BD

Question: 4

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: BCF

Question: 5

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: BEF

http://www.itexamtest.com/HP2-N36.html