Online Access Free HP2-N36 Exam Questions

What is a benefit of having identically-sorted buddy projections?

• A.more efficient use of disk since the data is only on one node
• B.fast recovery of a down node
• C.better query performance, since Vertica gets half the data from each projection
• D.improved storage usage, since Vertica shares data files

What are key features of Vertica? (Select three.)

• A.columnar data store
• B.runs on a Windows platform
• C.data caching for fast retrieval
• D.native high availability
• E.stored data that is encoded and compressed
• F.uses fully custom SQL syntax

What are the advantages of a group by pipe versus a group by hash? (Select two.)

• A.A group by pipe requires no optimization.
• B.A group by pipe builds its entire output table in memory.
• C.A group by pipe can be processed spill to disk if the join result is large.
• D.A group by pipe is at least as fast as a group by hash.
• E.A group by pipe uses memory more efficiently.

What are the benefits of loading data into WOS?

• A.The data is cached in memory for quick access.
• B.The data is sorted.
• C.The data is able to be queried as soon as it is loaded.
• D.The data is broken out into projections.

How does Vertica implement high availability in a clustered environment?

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