HP2-N36 Online Practice Questions and Answers

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

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 mergeout task? (Select three.)

A. Mergeout rewrites all ROS containers.

B. Mergeout writes data to memory.

C. Mergeout consolidates containers on disk.

D. Mergeout places data into all defined projections on the source table.

E. Mergeout purges deleted data already on disk.

F. Mergeout moves data from memory to disk.

Which task consolidates data containers, sorting, compressing, and purging data as needed?

A. mergesync

B. movesync

C. mergeout

D. moveout

What are the benefits of loading data directly into ROS? (Select three.)

A. The data is written to all projections on the source tables.

B. The data is sorted.

C. The data is unsorted.

D. The data is stored in only the super projection, which then populates other projections on the table in the background.

E. The data is in column format. The data is written in row format.

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 the Resource Manager's role in query processing?

A. serializing all requests to simulate concurrency

B. determination and allocation of request importance

C. determination and allocation of memory, threads, and file handles for the request

D. allowing queries to run in place of background tasks

When is a backup recommended? (Select two.)

A. prior to shutting down the cluster

B. prior to upgrading Vertica

C. prior to starting the Vertica cluster

D. any time large amounts of data have been added, updated, or deleted

E. any time data is added, updated, or deleted

Which methods are available to optimize a projection for delete processing? (Select two.)

A. Add a low cardinality column to the beginning of all projections on the source table.

B. Add a high cardinality column to the end of all projections on the source table.

C. Add all columns used as delete predicates to all projections on the source table.

D. Add a low cardinality column to the end of all projections on the source table.

E. Add a high cardinality column to the beginning of all projections on the source table.

Which statements are true about a prejoin projection? (Select three.)

A. A prejoin projection enforces primary and foreign key constraints.

B. A prejoin projection does not increase the storage footprint.

C. A prejoin projection slows down data loading.

D. A prejoin projection can process any type of join.

E. A prejoin projection adds no limitations to the tables in the join.

F. A prejoin projection improves query run time performance.

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.

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 features are available when using the Management Console for monitoring Vertica? (Select two.)

A. can only be accessed from a Windows machine

B. can only be accessed from a Linux machine

C. can be used by multiple users, with different sets of privileges for each

D. provides a unified view of all Vertica clusters

E. provides a visual depiction of CPU usage across the nodes of the cluster

What does an event-based window do?

A. enables analysis of two series of data when their measurement intervals do not align precisely

B. evaluates the values of a given set of variables and groups those values into a window

C. enables identification of a sequence of defined events

D. increments a counter based on whether an expression evaluates as true

What are the standard clauses in an analytics query?

A. It includes a PARTITION clause, with required over_clause, order_clause, and frame_clause.

B. It includes an OVER clause, with required partition_clause, order_clause, and frame_clause

C. It includes an OVER clause, with optional partition_clause, order_clause, and frame_clause.

D. It includes a PARTITION clause, with optional over_clause, order_clause, and frame clause.