Online Access Free HP2-N36 Practice Test

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

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

What is local segmentation capability in Vertica?

• A.Vertica automatically splits current segments in half to redistribute them to new nodes.
• B.Vertica automatically partitions the segmented data, allowing some partitions to be moved to new nodes as needed.
• C.Vertica automatically partitions the data, allowing partitions to be dropped and recreated on new nodes.
• D.Vertica automatically creates more segments than are currently needed, allowing some segments to be moved to new nodes as needed.

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 creates new files; deleting records does not create new files.
• C.Dropping a partition can be rolled back deleting records cannot be rolled back.
• D.Dropping a partition recovers space immediately; deleting records does not recover space immediately.

What is the WOS?

• A.a row-store, memory-based method for adding data to Vertica
• B.a redundant copy of commonly read data, cached in memory
• C.a redundant write-only location used to improve node uptime
• D.a column-store, disk-based method for storing data in Vertica

How does Vertica implement high availability in a clustered environment?

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