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.

No reference material is allowed at the testing site. This exam may contain beta test items for experimental purposes.

Exam description

This exam tests your administration skills on the Vertica Analytics Platform.
This exam is administered via HPE Vertica and Pearson VUE. The cost is $200 USD, globally.

Reminder: this exam is currently only available when purchased using a credit card or PayPal with a US address.

Ideal candidate for this exam

This exam is intended for Vertica DBAs and partners who want to validate their ability to analyze, diagnose, troubleshoot, and optimize Vertica performance.

Exam contents

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

Advice to help you take this exam

The exam consists of 2 parts:
  • A hands on examination where you perform tasks in a cloud based environment and an online exam.
  • Once you pass the hands on exam, you receive a voucher to take the written exam online at Pearson VUE.

Customers, follow these steps to register for the exam:
  1. Sign up at the Marketplace
  2. Arrange a hands on test time with HPE Vertica
  3. When you pass the hands on exam, you receive a voucher for the written test
  4. Obtain a LearnerID (you receive your ID within three business days)
  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
Partners, follow these steps to take the exam:
  1. Sign up at the Marketplace
  2. Arrange a hands on test time with HPE Vertica
  3. When you pass the hands on exam, you receive a voucher for the written test
  4. If you are registered with the HPE Unison Partner Portal you already have a LearnerID. If you have forgotten your Learner ID please retrieve it at: https:// https://mylearninghpe.com/forms/idLookup.aspx
  5. 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 and use the instructions above
  6. 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:
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.