Free HP HP2-N36 Exam Dumps Questions & Answers

What are the actions of the mergeout task? (Select three.)

• A.  Mergeout consolidates containers on disk.
• B.  Mergeout purges deleted data already on disk.
• C.  Mergeout moves data from memory to disk.
• D.  Mergeout places data into all defined projections on the source table.
• E.  Mergeout rewrEtes all ROS containers.
• F.  Mergeout writes data to memory.

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

How does Vertica implement high availability in a clustered environment?

• A.  continuous mirroring of data
• B.  full replicas of all data on all nodes
• C.  built-in redundancy of data
• D.  full replicas of fact tables and segmented dimension tables

When is a backup recommended? (Select two.)

• A.  prior to starting the Vertica cluster
• B.  any time large amounts of data have been added, updated, or deleted
• C.  prior to shutting down the cluster
• D.  prior to upgrading Vertica
• E.  any time data is added, updated, or deleted

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, associated projections cannot be segmented.
• C.  If table data is partitioned, the table cannot participate in a prejoin projection.
• D.  If table data is partitioned, associated projections can also be segmented.