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

Register for this Exam

You will need an HPE Learner ID and a Pearson VUE login and password.  The total cost for this exam is listed on the HPE Software Education Catalog with all registrations for the entire exam handled through them.

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

Exam description

This exam tests a candidates skills on Administering the
Vertica Analytics Platform.  The exam is divided into two separate portions:
practicum and written.  The Practicum Portion is administered by Hewlett
Packard Enterprise Software Education organization and the written is
administered by Pearson VUE.  The total cost for this exam is listed on
the HPE Software Education Catalog with all registrations for the entire exam
handled through them.

 

Ideal candidate for this exam

This exam is intended for Vertica DBAs, HPE Partners and
individuals who routinely implement and/or troubleshoot a Vertica Solution and
wanting to validate their ability to analyze, diagnose, troubleshoot and
optimize the Vertica Performance.  This certification validates your
knowledge of, and experience with, the Vertica Analytics Platform.
 

Exam contents

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

Advice to help you take this exam

The exam consists of 2 parts.  A hands on examination where you will perform tasks in a cloud based environment.  When a passing score is achieved, a voucher will be supplied so that the written exam can be taken online at Pearson VUE.
Customers, follow these steps to take the exam:
  1. Obtain a LearnerID (you will receive your ID within 3 business days)
  2. Register with HPE Software Education through their Learning Catalog
  3. When you pass the hands on exam  a voucher will be supplied for the written test
  4. After you receive both your HPE Learner ID and accept the Terms and Conditions and passed the Practicum Exam, register with Pearson VUE to purchase and complete the HP2-N45 online exam
Partners, follow these steps to take the exam:
  1. When you are prepared to take the exam, register through the HPE Software Education Learning Catalog
  2. When you pass the hands on exam  a voucher will be supplied for the written test
  3. If you are registered with the HPE Unison Partner Portal you will already have a LearnerID. If you have forgotten your Learner ID please retrieve it at: https://mylearninghpe.com/forms/idLookup.aspx
  4. If you are not registered with the Unison Partner Portal you have two options
    • Register as a HPE Partner at the Partner Portal
    • Register as a Customer using the instructions above
  5. After you receive your HPE Learner ID and accept the Terms and Conditions, register with Pearson VUE to purchase and complete the HP2-N45 online exam
Read the entire question and consider all options before you answer. If the question includes an exhibit, study the exhibit and read the question again. Select the answer that fully responds to the question. If the question asks for more than one answer, select all correct answers. There is no partial credit.

Objectives

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

Troubleshooting

  • Follow standard procedures to resolve common issues.
  • Locate key information to resolve common issues.

25%

Optimization

  • Modify key settings to obtain optimal performance.
  • Specify important elements of an optimized database.
  • Create projections that are formatted for optimal performance.

10%

Security

  • Implement a secure Vertica environment.
  • Identify key factors to create a high availability environment.

10%

Database Setup And Automatic Design

  • Create objects in a Vertica database that provide for optimal querying of data.
  • Use the Database Designer to optimize a Vertica database.

7%

Loading and Removing Data

  • Identify factors that play a role in optimizing for the addition and removal of data from Vertica.

5%

Resource Management

  • Identify factors that play a role in optimizing the usage of resources while running transactions in Vertica.

Learning resources that were developed before the Hewlett-Packard Company separation might contain some content and brand elements that have not been updated for Hewlett Packard Enterprise. Learning resources with the highest usage are updated.