Free HP HP2-N36 Exam Dumps Questions & Answers

What are the benefits of ordenng data in projection design? (Select two.)

• A.  It enables segmentation of data.
• B.  It enables partitioning of data.
• C.  It enables optimum encoding.
• D.  , It enables efficient application of query predicates.
• E.  It enables efficient sharing of data between similarly-ordered projections.

How are records marked for deletion?

• A.  Vertica removes the file that stores the deleted data.
• B.  Vertica deletes the records from the original source files.
• C.  Vertica creates a delete vector, Identifying records to be deleted.
• D.  Vertica rewrites the files that contained the deleted records, ignoring records to be deleted.

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

• A.  Add all columns used as delete predicates to all projections on the source table.
• B.  Add a high cardinality column to the end of all projections on the source table.
• C.  Add a high cardinality column to the beginning of all projections on the source table.
• D.  Add a low cardinality column to the beginning of all projections on the source table.
• E.  Add a low cardinality column to the end of all projections on the source table.

What are features of using the Vertica backup script? (Select two.)

• A.  It uses a lightweight locking protocol, stopping data loading for a brief period of time.
• B.  It enables recovery by database, node, or table.
• C.  It can be run remotely via the Management Console.
• D.  it can be run while the database is not running.
• E.  It enables backup of the entire database only.

Which methods exist to troubleshoot spread? (Select two.)

• A.  Verity that spread.conf is the same on all nodes.
• B.  Power cycle the server.
• C.  Restart the spread daemon on the node.
• D.  Verify that spread.conf is different on all nodes.
• E.  Restart the Vertica process on the node.