- ADVAP has exactly two official preparation areas: Vertica Projection Tuning and Vertica Aggregate Projection Design.
- The exam is 60 questions in two hours, multiple-choice and true/false, passing at 70% (42/60).
- Domain 1 centers on query execution plans, Database Designer, and manual projection tuning.
- Domain 2 focuses on aggregate projection types: expression, live aggregate, TopK, and partition range.
ADVAP Domain Overview
Unlike certification exams built around five or six weighted knowledge areas, the Vertica Analyst Certification Exam is organized around two official course titles that Rocket Learn maps directly to the exam listing. These are not formally weighted "blueprint" domains in the traditional sense - they are the exact preparation categories Rocket Learn associates with the Analyst exam, and understanding what each one actually tests is the single most important step before you register. If you haven't reviewed the exam structure yet, the ADVAP Study Guide 2026: How to Pass on Your First Attempt is a useful companion to this breakdown.
Both domains sit downstream of Vertica Essentials, which provides the conceptual foundation - segmentation, projections, encoding, and basic query behavior - before you move into the more analyst-focused material tested here. If you're still deciding whether this credential fits your career path, Is the ADVAP Certification Worth It? Complete ROI Analysis 2026 covers that decision in more depth.
Domain 1: Vertica Projection Tuning
Vertica Projection Tuning is the diagnostic half of the exam. It tests whether you can look at a projection design and reason about what it does to query performance - not just recite definitions. Expect scenario-driven items that ask you to interpret an existing projection layout, identify where it will help or hurt a specific query pattern, and decide what a manual redesign should look like.
Vertica Projection Tuning
Candidates must be able to interpret projection designs, trace their effects on query performance, and construct manual projections for specific queries or database scenarios.
- Reading and interpreting query execution plans to locate projection-related bottlenecks
- Using Database Designer output as a starting point, then evaluating where manual intervention is needed
- Building manual table and projection designs tailored to a described workload
- Adjusting query-performance configuration settings tied to projection behavior
- Recognizing when sort order, segmentation, or encoding choices are the real bottleneck rather than the projection itself
This is the domain where candidates who only memorize terminology tend to struggle. The exam's stated focus is on interpretation - reading a plan and explaining what it implies - as much as it is on producing the correct projection syntax. If you want a sense of how demanding this scenario-based style is compared to more definition-heavy certification exams, How Hard Is the ADVAP Exam? Complete Difficulty Guide 2026 walks through that comparison directly.
Key Takeaway
Practice reading actual query execution plans rather than just studying projection theory. Domain 1 rewards the ability to trace cause and effect from plan to performance outcome.
Domain 2: Vertica Aggregate Projection Design
Vertica Aggregate Projection Design narrows in on a specific family of projection types built to pre-compute or accelerate aggregate-heavy queries. Where Domain 1 is broadly diagnostic, Domain 2 is more structural: you need to know what each aggregate projection type does, when it applies, and how it changes both storage and query behavior.
Vertica Aggregate Projection Design
Candidates must know the mechanics, use cases, and tradeoffs of the aggregate projection types covered in Rocket Learn's preparation material.
- Expression projections - precomputing derived columns or expressions to speed up repeated calculations
- Live aggregate projections - maintaining aggregate values as data loads, avoiding recomputation at query time
- TopK projections - retaining only the top-ranked rows per group, useful for "most recent" or "highest value" query patterns
- Partition range projections - organizing aggregate data by partition boundaries to optimize range-based queries
Because these four projection types have overlapping use cases, expect questions that describe a query pattern or reporting requirement and ask you to pick the projection type - or design - that fits best. Confusing TopK with a generic aggregate projection, or assuming a live aggregate projection behaves identically to a standard aggregate at load time, are the kinds of mistakes that cost points here.
Question Format and Exam Mechanics
Both domains are tested inside the same 60-question, two-hour exam session, delivered in English through Rocket Learn. Questions are multiple-choice and true/false - there are no lab simulations or hands-on projection-building tasks during the exam itself, even though the content requires you to reason like someone who has built projections manually.
- Length: 60 questions
- Time limit: two hours
- Format: multiple-choice and true/false
- Language: English
- Passing score: 70%, equivalent to 42 correct answers out of 60
- Fee: USD 500, excluding VAT or other applicable taxes
For a full breakdown of exactly how the 42-out-of-60 threshold works and why it matters for pacing, see ADVAP Passing Score 2026: Exactly What You Need to Pass. If cost planning is part of your decision, ADVAP Certification Cost 2026: Complete Pricing Breakdown lays out the fee structure and renewal discount in detail.
Registration, scheduling, and the current exam listing itself all live on Rocket Learn, reflecting Rocket Software's completed acquisition of Vertica from OpenText on May 11, 2026. If you're mapping out testing windows or deadlines around that transition, ADVAP Exam Dates 2026: Testing Windows, Deadlines & Scheduling covers scheduling logistics in more depth.
Who Actually Takes This Exam
The intended audience is Vertica database administrators - not general BI analysts or data scientists using Vertica as one tool among many. That framing matters for how you prepare: the exam assumes you already operate inside a Vertica environment day-to-day and are being tested on your ability to tune and design projections at a more advanced level than entry-level administration requires.
Because of that audience, most candidates come in with some prior exposure to Vertica Essentials concepts - segmentation, basic projection structure, encoding - before tackling the two Analyst-level domains covered here. If you're unsure whether your current experience level qualifies you to attempt this exam, ADVAP Requirements 2026: Eligibility, Prerequisites & How to Qualify outlines what's expected before you register.
For context on how this credential fits into a broader Vertica-focused career track - and what kinds of roles look for it - ADVAP Jobs and ADVAP Salary Guide 2026: Complete Earnings Analysis are worth reading once you've got the domain content down.
Scheduling Study Time Around Two Domains
Because ADVAP only has two preparation areas instead of five or six, a long multi-month study calendar isn't necessary - but the two domains reward different types of practice, so splitting your time deliberately still helps.
Vertica Projection Tuning
- Review query execution plan output and practice tracing bottlenecks back to projection design
- Work through Database Designer output and identify where manual adjustments would change performance
- Draft manual table and projection designs for two or three sample query scenarios
Vertica Aggregate Projection Design
- Build a reference comparison of expression, live aggregate, TopK, and partition range projections
- Practice matching described reporting requirements to the correct aggregate projection type
- Revisit weak Domain 1 areas alongside new Domain 2 material, since the exam blends both
Timed practice and gap review
- Run full-length timed practice sessions to get comfortable with the 60-question, two-hour pace
- Flag any scenario type that still causes hesitation and rebuild it from scratch
This is one of the few places where general study techniques - spaced repetition on the four aggregate projection types, or timed drills to simulate exam pacing - genuinely apply to ADVAP specifically, since the exam's tight two-hour window for 60 scenario-based questions leaves little room for slow, uncertain reasoning. For a deeper walkthrough of preparation strategy, ADVAP Study Guide 2026: How to Pass on Your First Attempt expands on this approach, and running timed sets on our practice test platform is a direct way to build that pacing before exam day.
Domain Comparison at a Glance
| Aspect | Domain 1: Vertica Projection Tuning | Domain 2: Vertica Aggregate Projection Design |
|---|---|---|
| Core skill | Interpreting projection designs and their performance impact | Selecting and designing aggregate projection types |
| Key tools/concepts | Query execution plans, Database Designer, query-performance configuration | Expression, live aggregate, TopK, and partition range projections |
| Question style | Scenario-based diagnosis and manual redesign | Matching query patterns to the correct projection type |
| Foundation needed | Vertica Essentials concepts: segmentation, encoding, basic projections | Domain 1 fundamentals plus aggregate-specific mechanics |
Because the two domains overlap in practice - an aggregate projection choice in Domain 2 still needs to be evaluated using the execution-plan reasoning from Domain 1 - treating them as fully separate silos during study is a mistake. A quick review of ADVAP Cheat Sheet 2026: One-Page Review of Must-Know Facts in the final days before your exam can help reinforce how the two domains connect.
Frequently Asked Questions
Two: Vertica Projection Tuning and Vertica Aggregate Projection Design. These are the exact official course titles Rocket Learn maps to the Analyst exam listing, functioning as unweighted preparation areas rather than a formally weighted blueprint.
Rocket Learn does not publish domain weightings for this exam. The two titles are preparation areas mapped to the Analyst exam, not percentage-weighted blueprint sections, so candidates should prepare both thoroughly rather than assuming one carries more exam weight.
The intended audience is Vertica database administrators, and the content assumes familiarity with concepts typically covered in Vertica Essentials. Review ADVAP Requirements 2026: Eligibility, Prerequisites & How to Qualify for more detail on expected background.
The linked OpenText certification policies allow an immediate second attempt after an initial failure. Third and subsequent attempts require waiting at least 14 days, and each additional attempt is charged separately.
The certification carries a three-year validity period. Renewal happens through the current examination, and a 50% discount is available if you renew before your certification expires.