Exam ID HP2-N36
Exam type Web-Based online exam used in certifications
Exam duration 1 hour 30 minutes
Exam length 50 questions
Passing score 70%
Delivery languages English
Related Certifications
Supporting courses These recommended courses help you prepare for the exam:

Register for this Exam

You will need an HP Learner ID and a Pearson VUE login and password.

During the exam, you can make specific comments about the exam and items. HP welcomes these comments as part of our continuous improvement process.

Exam description

This exam tests your skills on the Vertica platform.

Who should take this exam?

This exam is for Vertica system administrators, database analysts, and application developers.
Prior to taking the exam, you are expected to complete the “Vertica Introduction” training (formerly titled “Vertica Boot Camp”) or equivalent self-directed study, plus 3-6 months of production level experience with the Vertica platform.
You should have 1-3 years Linux experience and experience with a scripting language such as Perl or Python. Extensive working knowledge of SQL plus 3-4 years of technical, hands on experience with a relational database is suggested. A solid understanding of relational database systems including theory, design, and structure is important.

Exam contents

This exam has 50 questions. Here are types of questions to expect:
  • Multiple choice (multiple responses)
  • Multiple choice (single response)

Tips for taking this exam

You are not required to take the recommended, supported courses; and completion of training does not guarantee that you will pass the exam. HP strongly recommends a combination of training, thorough review of courseware and additional study references, and sufficient on the job experience prior to taking the exam.

Objectives

This exam validates that you can successfully perform the following:
10%

Vertica Architecture

  • Identify key features of Vertica
  • Describe high availability capabilities and describe Vertica's transaction model
  • Differentiate between compression and encoding
  • Installation of Vertica

10%

Projection Design

  • Identify characteristics and determine features of projections used in Vertica
  • Define RLE
  • Describe ORDER BY importance in projection design
  • Describe the purpose of projection segmentation
  • Understanding buddy projections
  • Determining segmentation and partitioning

20%

Loading Data into Vertica

  • Identify benefits of loading data into WOS and directly into ROS
  • Define the actions of the moveout and mergeout tasks
  • Describe how mergeout purges data marked for deletion
  • Copying data directly to ROS
  • Identifying characteristics of data file directory
  • Understanding both WOS and ROS
  • Distinguishing between moveout and mergeout actions

16%

Removing Data Permanently from Vertica and Advanced Projection Design

  • Describe the process used to mark records for deletion
  • Identify the advantages and disadvantages of using delete vectors to identify records marked for deletion
  • Identify the process for processing a large delete or update
  • Distinguish between deleting partitions and deleting records
  • Identify the advantages of a merge join versus a hash join
  • Identify the advantages of a group by pipe versus a group by hash
  • Describe the characteristics of a prejoin projection
  • Determine methods available to optimize a projection for delete processing

10%

Cluster Management in Vertica

  • Identify the steps used to add nodes to an existing cluster
  • Describe the benefits of having identically sorted buddy projections
  • Identify the steps of online recovery of a failed node
  • Define local segmentation capability in Vertica
  • Distinguish between the items in a Vertica cluster

10%

Backup/Restore and Resource Management in Vertica

  • Identify situations when a backup is recommended
  • Identify features of the Vertica file used for backup and restore
  • Define the Resource Manager's role in query processing
  • Describe the differences between maxconcurrency and plannedconcurrency
  • Using query profiles and resource pools

10%

Monitoring and Troubleshooting Vertica

  • Define the use of Management Console in monitoring Vertica
  • Determine methods to troubleshoot spread
  • Describe how to disallow user connections, while preserving dbadmin connectivity
  • Defining, using and logging into Management Console
  • Administering a cluster using Management Console

14%

Analytics and Performance Tuning

  • Understanding analytics syntax
  • Using Event Based Windows, Time Series, Event Series Join, and Pattern Matching
  • Using explain plans and query profiles
  • Improving query performance
  • Analyzing an explain plan