HP Vertica Solutions [2012]: HP2-N36 Exam
HP2-N36 Questions & Answers
Exam Code: HP2-N36
Exam Name: HP Vertica Solutions [2012]
Q & A: 55 Q&As
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
QUESTION 6
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.
Answer: B
QUESTION 7
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
Answer: C
…go to http://www.lead2pass.com/hp2-n36.html to download the lastest full version.