HP2-N36 Online Practice Questions and Answers

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

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.

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.

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.

What does the acronym RLE stand for?

A. run language encoding

B. random length encoding

C. random language encoding

D. run length encoding

What is the difference between dropping a partition and deleting records?

A. Dropping a partition creates delete vectors; deleting records does not create delete vectors.

B. Dropping a partition can be rolled back; deleting records cannot be rolled back.

C. Dropping a partition creates new files; deleting records does not create new files.

D. Dropping a partition recovers space immediately; deleting records does not recover space immediately.

What are the actions of the moveout task? (Select two.)

A. Moveout consolidates containers already on disk.

B. Moveout places data into all defined projections on the source table.

C. Moveout rewrites all ROS containers.

D. Moveout moves data from memory to disk.

E. Moveout writes data to memory.

F. Moveout purges deleted data already on disk.

What is the WOS?

A. a redundant copy of commonly read data, cached in memory

B. a column-store, disk-based method for storing data in Vertica

C. a redundant write-only location used to improve node uptime

D. a row-store, memory-based method for adding data to Vertica

What is a benefit of having identically-sorted buddy projections?

A. improved storage usage, since Vertica shares data files

B. more efficient use of disk since the data is only on one node

C. better query performance, since Vertica gets half the data from each projection

D. fast recovery of a down node

What is the process for online recovery of a failed node? (Select two.)

A. The recovered node gathers the necessary files from nodes with its buddy projections.

B. The recovered node verifies that it is current once a recovery cycle completes.

C. The recovered node uses spread to speed up the recovery process.

D. The recovered node restores all files from the last backup.

E. The recovered node must be rebuilt from epoch 0.