HP2-N36 Exam Questions

What are the differences between compression and encoding? (Select two.)

What does the acronym RLE stand for?

What is the WOS?

Which statement is true about the data directory location across the nodes of a cluster?

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

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

How are records marked for deletion?

What is the ROS?

How does mergeout purge data marked for deletion?

Which statement about the business benefits of Vertica is true?

Which type of storage architecture does Vertica have?

When is a backup recommended? (Select two.)

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

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

What are the advantages of a merge join versus a hash join? (Select two.)

If your CEO runs a query each day, how can you be assured necessary resources will be available when the query is run? (Select two.)

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

What are the standard clauses in an analytics query?

What does Time Series do?

During Vertica installation, how do you install onto multiple nodes of a cluster?

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

What are characteristics of projections in Vertica? (Select three.)

What is the purpose of Vertica's transaction model? (Select three.)

What distinguishes table partitioning from projection segmentation?

What is a buddy projection?

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

Which statements are true of a projection? (Select two.)

How does Vertica implement high availability in a clustered environment?

Which notation must be added to the COPY command to cause data to be placed directly in ROS?

What are the disadvantages of using delete vectors to identify records marked for deletion? (Select two.)

What is the difference between dropping a partition and deleting records?

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

What are the benefits of loading data into WOS?

What are the benefits of using delete vectors to identify records marked for deletion? (Select two.)

What are the actions of the moveout task? (Select two.)

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

What is local segmentation capability in Vertica?

What is the process for online recovery of a failed node? (Select two.)

What is a Vertica cluster?

How can you disallow user connections, while preserving dbadmin connectivity?

What does Event Series Join do?

Which statement is true about a query explain plan?

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

What is a difference between maxconcurrency and plannedconcurrency?

What can be used to determine memory resources needed by a query?

Which features are available when using the Management Console for monitoring Vertica? (Select two.)

What is available on the Jobs chart in the Management Console? (Select two)

What does an event-based window do?

Who can log in to the Management Console?

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