HP HP2-N36 - HP Vertica Solutions [2012] Exam
Page: 1 / 10
Total 50 questions
Question #1 (Topic: )
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
Question #2 (Topic: )
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
Question #3 (Topic: )
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
Question #4 (Topic: )
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
Question #5 (Topic: )
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
