- ADVAP has no mandatory prerequisite course, but Vertica Essentials builds the foundation advanced material assumes.
- The exam costs USD 500 (excluding VAT), runs 60 questions in two hours, and requires 70% (42/60) to pass.
- Registration and delivery run through Rocket Learn following Rocket Software's acquisition of Vertica from OpenText.
- Eligibility is really about job function: the intended audience is working Vertica database administrators.
Who Actually Qualifies for ADVAP
Unlike certifications that gatekeep behind years of experience or sponsor letters, the Vertica Analyst Certification Exam (referred to on this site as ADVAP) has no formal enrollment barrier. There's no application review, no minimum years-of-service requirement, and no requirement to hold a prior certification before you register. Anyone can pay the fee and sit the exam through Rocket Learn.
That said, "can register" and "should register" are different questions. The exam's official listing describes its intended audience as Vertica database administrators - people who already work hands-on with projection design, query execution plans, and performance tuning inside a live or test Vertica environment. If you've never opened Database Designer or reviewed an execution plan for a slow query, the absence of a formal prerequisite won't protect you from a difficult exam day. For a deeper look at how tough the material actually is, see How Hard Is the ADVAP Exam? Complete Difficulty Guide 2026.
Formal Prerequisites and Foundational Knowledge
There is no gatekept prerequisite exam or credential you must hold before registering for ADVAP. However, Rocket's own course structure treats Vertica Essentials as the foundation that advanced coursework - including the material this exam draws from - is built on. If you're new to Vertica altogether, working through Essentials-level concepts first (architecture, basic loading, basic query behavior) will make the Analyst-level projection material far more digestible.
Practically speaking, "qualifying" for ADVAP means arriving with working knowledge of:
- How Vertica's columnar storage and projections relate to query performance
- Basic use of Database Designer for automated projection recommendations
- Reading a query execution plan and identifying inefficient access patterns
- SQL fundamentals sufficient to reason about joins, predicates, and sort order
None of this is enforced at registration. It's enforced by the exam itself, which is why candidates who skip the foundation tend to struggle regardless of how much time they spend memorizing terminology. A structured look at exactly what's tested is available in ADVAP Exam Domains 2026: Complete Guide to All 2 Content Areas.
Key Takeaway
Treat Vertica Essentials as your unofficial prerequisite even though it isn't enforced - skipping it is the single most common reason unprepared candidates fail.
Registration Mechanics and Fee Structure
Following Rocket Software's completed acquisition of Vertica from OpenText on May 11, 2026, certification listings and exam access moved to Rocket Learn. This is the current, authoritative source for scheduling and fees - not older OpenText-branded exam portals you may find referenced elsewhere.
The concrete registration facts, straight from the official listing:
- Fee: USD 500, excluding VAT or other applicable taxes
- Format: Multiple-choice and true/false questions
- Length: 60 questions
- Time limit: Two hours
- Language: English
- Passing score: 70%, equivalent to 42 correct answers out of 60
For a full breakdown of what that fee includes and how it compares across attempts, read ADVAP Certification Cost 2026: Complete Pricing Breakdown. If you want the passing threshold explained in more depth - including why 42/60 matters more than the percentage alone - see ADVAP Passing Score 2026: Exactly What You Need to Pass.
Eligibility by Domain: What You Must Know
Rocket Learn maps two official course-title domains directly to this exam. These aren't weighted blueprint percentages - they're the two preparation areas the exam draws from, and both deserve full attention rather than a 60/40 split guess.
Domain 1: Vertica Projection Tuning
This area centers on interpreting existing projection designs and understanding how those designs affect query performance in practice.
- Reading and interpreting query execution plans
- Using Database Designer to generate and evaluate projection recommendations
- Diagnosing performance issues tied to poor projection choices
- Configuring query-performance settings around projection behavior
Domain 2: Vertica Aggregate Projection Design
This area focuses on manually designing projections - including aggregate types - for specific queries and database scenarios rather than relying purely on automated tools.
- Manual table and projection design decisions
- Expression aggregate projections
- Live aggregate projections
- TopK projections
- Partition range projections
Both domains reward hands-on repetition over passive reading. If you can explain why a manually designed aggregate projection outperforms a default one for a given query pattern, you're demonstrating exactly the judgment ADVAP is built to measure. A domain-by-domain study sequence is laid out in ADVAP Study Guide 2026: How to Pass on Your First Attempt.
Who Should Not Take This Exam Yet
Because there's no enforced prerequisite, it's worth being honest about who is likely to struggle. If any of the following describe you, consider delaying registration:
- You have never used Database Designer in a real or sandbox Vertica instance
- You cannot explain the difference between a superprojection and a manually tuned projection
- You've never reviewed an execution plan to diagnose a slow query
- You're unfamiliar with at least the concept of TopK, live aggregate, or partition range projections
None of these gaps are disqualifying long-term - they're just signals that more hands-on time is needed before the two-hour clock starts. Roles that typically hire for this credential - database administrators, performance engineers, and analytics platform specialists - expect this depth of familiarity as baseline job knowledge, not exam trivia. See ADVAP Jobs for how the certification maps to real hiring criteria, and ADVAP Salary Guide 2026: Complete Earnings Analysis for how it factors into compensation conversations.
Key Takeaway
"Eligible on paper" and "ready to pass" are different bars. Use the domain lists above as a self-assessment before you pay the registration fee.
Validity, Renewal, and Retake Rules
The current Rocket exam listing links out to OpenText's certification policies, which govern validity and retakes for this credential:
| Policy | Detail |
|---|---|
| Certification validity | Three years from the date earned |
| Renewal method | Renew by passing the current version of the examination |
| Renewal discount | 50% off if renewed before the certification expires |
| First retake after a fail | Immediate - no mandatory waiting period |
| Third and later attempts | At least 14 days must pass before re-attempting |
| Retake cost | Each additional attempt is charged separately |
This matters for eligibility planning in two ways. First, if you fail on your first try, you can register again right away - there's no cooling-off period baked in for a second attempt. Second, if you fail twice, the 14-day wait before a third attempt effectively forces a reassessment period, which is a good opportunity to revisit whichever domain - Projection Tuning or Aggregate Projection Design - cost you the most points. For data-informed expectations about how many candidates pass on the first attempt, read ADVAP Pass Rate 2026: What the Data Shows.
Building a Qualification Timeline
Because eligibility is really about readiness rather than paperwork, the most useful thing you can do before registering is build a short, domain-anchored prep timeline rather than an open-ended "study more" plan.
Foundation and Domain 1 groundwork
- Review Vertica Essentials concepts if you haven't used them recently
- Practice reading execution plans for real queries
- Run Database Designer against sample workloads and study its output
Domain 1 depth: Projection Tuning
- Compare automated vs. manual projection outcomes on the same query
- Study query-performance configuration options tied to projections
Domain 2: Aggregate Projection Design
- Build expression, live aggregate, TopK, and partition range projections manually
- Match each aggregate type to the query scenario it best solves
Timed practice and gap review
- Take full-length practice questions under a two-hour limit
- Revisit whichever domain scores below 70% consistently
This isn't a generic template - the sequencing is deliberate. Domain 1 concepts (reading and interpreting existing designs) are easier to absorb before you attempt Domain 2's manual design work, since manual design decisions are easier to justify once you understand how performance effects show up in an execution plan. For a condensed, exam-day reference once you've built this foundation, bookmark ADVAP Cheat Sheet 2026: One-Page Review of Must-Know Facts, and run scenario-based practice questions on our practice test platform to simulate the real 60-question, two-hour format.
Frequently Asked Questions
No. There is no mandatory prerequisite exam or credential. Rocket Learn positions Vertica Essentials as foundational knowledge, but it isn't enforced at registration.
The official listing states the intended audience is Vertica database administrators, meaning people already working with projection design and query performance tuning in practice.
Registration and exam access run through Rocket Learn, following Rocket Software's completed acquisition of Vertica from OpenText on May 11, 2026.
You need 70%, which equals 42 correct answers out of the 60 total questions, within the two-hour time limit.
Certification is valid for three years. Renewal happens by passing the current version of the exam, and renewing before expiration qualifies you for a 50% discount.
For a broader orientation to the credential before you commit to a study plan, see What Is ADVAP Certification? and Is the ADVAP Certification Worth It? Complete ROI Analysis 2026.