HP2-N36 Online Practice Questions and Answers

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.

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

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

How are records marked for deletion?

A. Vertica removes the file that stores the deleted data.

B. Vertica rewrites the files that contained the deleted records, ignoring records to be deleted.

C. Vertica deletes the records from the original source files.

D. Vertica creates a delete vector, identifying records to be deleted.

What is the ROS?

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 row-store, memory-based method for adding data to Vertica

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

How does mergeout purge data marked for deletion?

A. It creates delete vectors, identifying files that can be removed from the system.

B. It updates files by removing records marked with delete vectors.

C. It writes undeleted records to files in a new location, then deletes all source files.

D. It writes deleted records to files in a new location, then deletes all source files.

What is a Vertica cluster?

A. a collection of projection files

B. a grouping of several Vertica databases

C. the set of nodes running one instance of Vertica

D. a physical machine configured to run an instance of Vertica

Which statement is true about a query explain plan?

A. It determines how to run the query, runs it, and returns the result.

B. It writes the SQL to execute a query.

C. It tells exactly how many rows will be returned by the query.

D. It displays the results of Optimizer to the user, showing projection(s) used and the query process.

What is available on the Jobs chart in the Management Console? (Select two)

A. loading status and errors

B. resource pool usage

C. memory usage

D. recovery progress and errors

E. query performance