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.

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 your skills on administering the Vertica Analytics Platform.
The HP Vertica Big Data Accredited Solutions Expert (ASE) exam is administered via HP 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.
 

Who should take 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. 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 (multiple responses)
  • Multiple choice (single response)

Tips for taking 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. When you are prepared to take the exam, sign up at the Marketplace
  2. Arrange a hands on testing time with HPE Vertica
  3. When you pass the hands on exam  a voucher will be supplied for the written test
  4. Obtain a LearnerID (you will receive your ID within 3 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. When you are prepared to take the exam, sign up at the Marketplace
  2. Arrange a hands on testing time with HPE Vertica
  3. When you pass the hands on exam  a voucher will be supplied for the written test
  4. 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:// 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 using 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

Take the time to read the entire question and consider all of the options carefully before you answer. If the question indicates that it features an exhibit, study the exhibit and reread the question. Make sure to select the answer that correctly responds to the question that is asked — not simply an answer that includes some correct information. If the question asks for more than one answer, remember to select each correct answer. You will not receive partial credit for a partially correct answer.

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.

Valuable and relevant learning resources 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 will be updated.