- What the ADVAP Exam Actually Tests
- Registration, Fees, and Retake Rules
- Domain 1: Vertica Projection Tuning
- Domain 2: Vertica Aggregate Projection Design
- Understanding the Question Format
- A Study Timeline Built Around the Two Domains
- Who Hires ADVAP-Certified Analysts
- Mistakes That Sink First-Time Candidates
- Frequently Asked Questions
- The exam has 60 questions, a two-hour limit, and requires 42 correct (70%) to pass.
- Only two prep areas exist: Vertica Projection Tuning and Vertica Aggregate Projection Design.
- Registration costs USD 500 (excluding VAT) through Rocket Learn, not a third-party testing vendor.
- You can retake immediately after one failure, but must wait 14 days for a third attempt.
What the ADVAP Exam Actually Tests
The Vertica Analyst Certification Exam - referred to on this site as ADVAP - is not a broad database theory test. It is a narrowly scoped, practitioner-focused exam built for people who already work inside Vertica environments and need to prove they understand how projections behave under real query load. Rocket Software, which completed its acquisition of Vertica from OpenText on May 11, 2026, now hosts the current certification listing and exam access on Rocket Learn.
The exam's stated audience is Vertica database administrators. That framing matters: the questions assume you've already touched a live Vertica cluster, run explain plans, and made at least one manual projection decision under pressure. If you're brand new to Vertica, start with the foundational material before attempting this exam - our ADVAP Requirements guide breaks down what background actually prepares you.
Registration, Fees, and Retake Rules
Every mechanical detail of taking this exam now runs through Rocket Learn rather than a legacy OpenText portal, though the underlying certification policies still originate from OpenText's certification program documentation. Here's what to expect:
- Cost: USD 500, excluding VAT or other applicable taxes.
- Format: 60 questions, multiple-choice and true/false, delivered in English.
- Time limit: Two hours.
- Passing score: 70%, which is 42 correct answers out of 60.
- Validity: Three years from the pass date, renewable through the current examination.
- Renewal discount: 50% off if you renew before your certification expires.
The retake structure is worth internalizing before you schedule your first attempt. If you fail once, you're allowed to schedule a second attempt immediately - no waiting period. But if that second attempt also fails, the policy requires at least 14 days before you can sit for a third or subsequent attempt, and each additional attempt is billed separately. That means a rushed, unprepared first try is expensive in both time and money. For a full cost breakdown including how these fees stack up across scenarios, see ADVAP Certification Cost 2026: Complete Pricing Breakdown.
Key Takeaway
Treat your first attempt as the one that counts. Immediate retakes are allowed after one failure, but repeated failures trigger a mandatory 14-day gap and additional fees - so front-load your preparation instead of relying on a quick second try.
If you want the exact numeric breakdown of what 70% means in practice - including how many wrong answers you can afford across a 60-question exam - the dedicated ADVAP Passing Score 2026 guide walks through the math in more depth than we will here.
Domain 1: Vertica Projection Tuning
This is the first of the two official course titles Rocket Learn maps directly to the Analyst exam, and it forms the backbone of the test. Projection tuning is fundamentally about reading and reacting to how Vertica physically stores and retrieves data.
Vertica Projection Tuning
Candidates must be able to interpret query execution plans and connect what they see there back to projection structure - sort order, encoding, segmentation, and how well a projection matches the predicates and joins in a given query.
- Reading query execution plans to identify projection-related bottlenecks
- Understanding how Database Designer generates and optimizes projections automatically
- Knowing when and how to override automatic design with manual table and projection design
- Tuning query-performance configuration settings tied to projection selection
Expect scenario-based questions here rather than pure definitions. You might be shown a simplified plan output or a description of a slow query and asked what projection change would resolve it. This is exactly the kind of applied reasoning that separates ADVAP from a memorization-based test - a distinction covered in more detail in How Hard Is the ADVAP Exam? Complete Difficulty Guide 2026.
Domain 2: Vertica Aggregate Projection Design
The second official course title mapped to the exam shifts from general projection tuning into a more specialized category: aggregate projections. This is where candidates often lose the most points, because the four aggregate projection types are easy to confuse under time pressure.
Vertica Aggregate Projection Design
You need to distinguish between aggregate projection types by use case, not just by name, and know which scenario calls for which structure.
- Expression projections - precomputing derived values used repeatedly in queries
- Live aggregate projections - maintaining rolling aggregate results as data loads
- TopK projections - retaining only the top-ranked rows per group for fast retrieval
- Partition range projections - aligning aggregate structures with partitioned data ranges
A useful way to practice this domain is to write out, for each of the four types, one sentence describing the query pattern it's built for and one sentence describing a scenario where using it would actually hurt performance. That contrast is often exactly what exam questions are probing. For a side-by-side breakdown of both official domains and how they relate to each other, see ADVAP Exam Domains 2026: Complete Guide to All 2 Content Areas.
| Aspect | Domain 1: Projection Tuning | Domain 2: Aggregate Projection Design |
|---|---|---|
| Core skill tested | Interpreting execution plans and general projection structure | Selecting the correct aggregate projection type per scenario |
| Key tool | Database Designer, query-performance configuration | Expression, live aggregate, TopK, and partition range projections |
| Typical question style | Diagnose a slow query and choose the fix | Match a data pattern to the correct aggregate type |
| Prerequisite grounding | Comfort reading query plans | Solid understanding of Domain 1 first |
Understanding the Question Format
All 60 questions are either multiple-choice or true/false, delivered in English, within a two-hour window. That's roughly two minutes per question on average, though scenario-based projection questions will eat more of that budget than straightforward true/false items.
Because both official Rocket Learn course titles feed directly into this exam, don't expect trick questions designed to test edge-case trivia. Instead, expect questions that check whether you can apply the material from Vertica Essentials - the stated foundation for advanced Vertica courses - to a described database scenario. If your foundational Vertica knowledge is shaky, that's the gap to close before diving into projection tuning specifics. Our ADVAP Cheat Sheet 2026 condenses the must-know facts from both domains into a single reviewable page for the days right before your exam.
A Study Timeline Built Around the Two Domains
Because ADVAP only has two prep areas, a long generic study plan isn't necessary - but sequencing still matters. Projection tuning concepts (Domain 1) underpin aggregate projection design (Domain 2), so study them in that order.
Foundations and Projection Tuning
- Review Vertica Essentials material as a refresher on core storage and query concepts
- Practice reading query execution plans line by line
- Study how Database Designer builds projections and when manual design is preferable
Query-Performance Configuration
- Work through query-performance configuration settings and their effect on projection choice
- Practice manual table and projection design against sample query scenarios
- Take a timed practice set focused only on Domain 1 material
Aggregate Projection Design
- Build comparison notes on expression, live aggregate, TopK, and partition range projections
- Work scenario questions that require choosing between the four aggregate types
- Revisit any Domain 1 weak spots that resurface in aggregate-context questions
Full-Length Practice and Review
- Take full-length, timed practice exams under two-hour conditions
- Review the exact passing threshold and confirm your accuracy against 42/60
- Do a final pass through the ADVAP Cheat Sheet the day before your exam
If you're using spaced repetition or timed drills, apply them specifically to the four aggregate projection types and to execution-plan reading - those are the two skill areas most likely to separate a pass from a near-miss. General study techniques matter less here than direct repetition on these ADVAP-specific mechanics.
Who Hires ADVAP-Certified Analysts
Because the exam is explicitly targeted at Vertica database administrators, the certification signals something specific to employers: you can look at a real Vertica workload and make a defensible projection decision, not just recite Vertica architecture. Organizations running Vertica at scale - often in analytics-heavy industries with large columnar datasets - value this because poor projection design directly translates into slow queries and wasted compute.
If you're evaluating whether this credential fits your career path, the return-on-investment question is worth thinking through deliberately rather than assuming. See Is the ADVAP Certification Worth It? Complete ROI Analysis 2026 for a framework, and ADVAP Salary Guide 2026: Complete Earnings Analysis for how this credential typically factors into compensation conversations. For open-role research, ADVAP Jobs is a useful starting point.
Mistakes That Sink First-Time Candidates
A few patterns show up repeatedly among people who don't pass on the first attempt:
- Treating the two domains as equal in isolation. Aggregate projection design questions frequently assume you already understand general projection tuning concepts - skipping ahead to Domain 2 without mastering Domain 1 backfires.
- Memorizing definitions instead of practicing scenarios. Knowing what a TopK projection is doesn't help if you can't recognize the query pattern that calls for one.
- Underestimating the two-hour pace. Sixty questions in two hours sounds generous until you hit several multi-step scenario questions in a row.
- Ignoring the retake cost structure. Some candidates schedule the exam too early, assuming a free retake - but only the immediate second attempt avoids the 14-day wait, and every additional attempt is billed separately.
For a broader look at where difficulty actually comes from on this exam - content depth versus time pressure versus prerequisite knowledge - read How Hard Is the ADVAP Exam? Complete Difficulty Guide 2026. And if you want to see how outcomes tend to break down for candidates who prepare properly versus those who don't, ADVAP Pass Rate 2026: What the Data Shows covers what's actually documented.
Before you lock in a test date, it's also worth checking scheduling logistics on Rocket Learn - testing windows and any deadline considerations are covered in ADVAP Exam Dates 2026: Testing Windows, Deadlines & Scheduling. And once you've got the fundamentals down, running through timed practice questions on our practice test platform is one of the fastest ways to find out whether your Domain 1 and Domain 2 knowledge actually holds up under exam conditions.
Frequently Asked Questions
The exam has 60 questions in multiple-choice and true/false format, with a two-hour time limit, delivered in English.
You need 70%, which is 42 correct answers out of the 60 total questions. See our passing score breakdown for more detail.
They are Vertica Projection Tuning and Vertica Aggregate Projection Design - the exact official Rocket Learn course titles mapped to this exam.
You can schedule an immediate second attempt with no waiting period. If that also fails, you must wait at least 14 days before a third attempt, and each additional attempt is charged separately.
Three years. You can renew through the current examination, and renewing before expiration qualifies you for a 50% discount.
Registration and exam access are handled through Rocket Learn, following Rocket Software's acquisition of Vertica from OpenText. Full pricing details are in our certification cost guide.
Passing ADVAP on the first attempt comes down to respecting how narrow and applied the exam actually is: two domains, scenario-driven questions, and a firm 70% bar. Master query execution plans and Database Designer behavior first, layer in the four aggregate projection types second, and rehearse under real time pressure using timed practice questions before you commit to a test date.