HP HP2-N36 - HP Vertica Solutions [2012] Exam
Page: 2 / 10
Total 50 questions
Question #6 (Topic: )
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: D
Question #7 (Topic: )
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: A
Question #8 (Topic: )
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
Answer: B,C,D
Question #9 (Topic: )
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.
Answer: B,C
Question #10 (Topic: )
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.
Answer: A,D
