- What This Cheat Sheet Covers
- Exam Snapshot: Format, Fee, and Logistics
- The Two Preparation Areas
- Vertica Projection Tuning: Must-Know Facts
- Aggregate Projection Design: Must-Know Facts
- Registration, Fees, and Retake Math
- Renewal and Validity Rules
- Who Actually Takes This Exam
- A Compressed Final-Week Review Plan
- Quick-Reference Table
- Frequently Asked Questions
- ADVAP has 60 questions, a two-hour limit, and a 70% passing score (42/60 correct).
- Only two preparation areas exist: Vertica Projection Tuning and Vertica Aggregate Projection Design.
- The exam listing and registration now live on Rocket Learn after Rocket Software's May 11, 2026 acquisition of Vertica.
- Know all four aggregate projection types: expression, live aggregate, TopK, and partition range.
What This Cheat Sheet Covers
This page is a condensed, one-stop reference for the Vertica Analyst Certification Exam - the credential this site refers to as ADVAP. It pulls together the exact format details, the two official preparation areas, the technical topics you're expected to know, and the registration and retake mechanics you'll deal with on Rocket Learn. It is not a substitute for hands-on practice, but it is exactly the sheet you'd want open the night before your test date.
If you haven't yet worked through a structured plan, pair this cheat sheet with the ADVAP Study Guide 2026 for a fuller walkthrough, or check how hard the ADVAP exam actually is before you commit to a test date.
Exam Snapshot: Format, Fee, and Logistics
Every fact below comes straight from the official Rocket Learn exam listing. Memorize these numbers - they're the kind of detail that gets asked in candidate forums and comparison articles constantly.
- Cost: USD 500, excluding VAT or other applicable local taxes.
- Question count: 60 questions total.
- Time limit: Two hours.
- Language: English.
- Question formats: Multiple-choice and true/false only - no drag-and-drop, no lab simulations, no free-text entry.
- Passing score: 70%, which is 42 correct answers out of 60.
- Intended audience: Vertica database administrators.
For a deeper breakdown of exactly how that 42-out-of-60 threshold works and what it means for your margin of error, see the ADVAP Passing Score 2026 guide. If budgeting for the exam matters to your planning, the ADVAP Certification Cost 2026 breakdown covers the fee structure in more detail.
Key Takeaway
With only 60 questions in two hours, you have about two minutes per question. Since every item is multiple-choice or true/false, there's no partial credit - plan your pacing so you can flag and revisit uncertain projection-design questions rather than freezing on any single one.
The Two Preparation Areas
ADVAP is built around exactly two official course titles that Rocket Learn maps directly to the Analyst exam. These aren't a weighted blueprint with published percentages - they're the two preparation areas Rocket Learn itself points candidates toward. Don't waste time hunting for a domain-weighting breakdown; it doesn't exist in the public listing.
Domain 1: Vertica Projection Tuning
Centers on interpreting how projection design decisions affect query performance, and on reading query execution plans to diagnose problems.
- Reading and interpreting query execution plans
- Using Database Designer to evaluate and generate projection recommendations
- Manually designing tables and projections for specific queries or database scenarios
- Query-performance configuration settings that influence how projections are used
Domain 2: Vertica Aggregate Projection Design
Focuses on the specialized projection types used to pre-aggregate data for faster analytic queries.
- Expression projections
- Live aggregate projections
- TopK projections
- Partition range projections
For a full walkthrough of how these two areas map to specific exam objectives and sample scenarios, read the ADVAP Exam Domains 2026 guide.
Vertica Projection Tuning: Must-Know Facts
This is the analytical half of the exam. Rather than asking you to recite syntax, it tests whether you can look at a query execution plan and understand what's slowing it down - and whether a manual projection redesign, rather than an automated Database Designer run, is the right fix.
- Execution plans: Be comfortable reading a plan end-to-end and identifying steps caused by suboptimal projection sort order or segmentation.
- Database Designer: Know what it optimizes for, when its automatic recommendations are sufficient, and when a scenario calls for hand-built projections instead.
- Manual design: Practice designing projections for a stated query pattern - this is explicitly called out as an exam skill, not just a course topic.
- Configuration knobs: Understand which query-performance settings interact with projection choice, since the exam frames performance as a function of design plus configuration.
Aggregate Projection Design: Must-Know Facts
This domain is narrower but denser - you need to know four projection types cold, including what each one is optimized for and where it would be the wrong choice.
| Projection Type | What It's Built For |
|---|---|
| Expression projection | Pre-computing derived columns or calculations so queries avoid repeated computation |
| Live aggregate projection | Maintaining running aggregates as data loads, keeping summaries current without a full recompute |
| TopK projection | Retaining only the top-ranked rows per group, useful for "most recent" or "highest value" style queries |
| Partition range projection | Organizing aggregated data by partition boundaries for range-based analytic queries |
Expect scenario-based questions here: a description of a query pattern, followed by a choice of which aggregate projection type best serves it. Rote memorization of definitions won't be enough - you need to map problem descriptions to the right structural answer.
Key Takeaway
Vertica Essentials training is described as the foundation for the advanced courses that feed into ADVAP. If aggregate projection concepts feel unfamiliar, that's a signal to backfill fundamentals before drilling scenario questions.
Registration, Fees, and Retake Math
Since Rocket Software completed its acquisition of Vertica from OpenText on May 11, 2026, the current certification listing and exam access sit on Rocket Learn. That's where you register, pay, and eventually schedule your seat.
- Fee: USD 500, excluding VAT or other applicable taxes - charged per attempt.
- First retake: If you fail, you're allowed to attempt again immediately - no mandatory waiting period for the second attempt.
- Third and later attempts: A minimum 14-day wait is required before any attempt beyond the second.
- Cost of retaking: Each additional attempt is charged separately - there's no bundled multi-attempt pricing.
Because every attempt is billed individually, a single unfocused attempt to "see what it's like" is an expensive way to prep. The ADVAP Pass Rate 2026 article looks qualitatively at what the exam's structure implies about first-attempt outcomes, and the cost breakdown walks through full budgeting including retake scenarios.
Renewal and Validity Rules
The current Rocket exam listing links out to OpenText's certification policies, which still govern renewal terms for this credential.
- Validity period: Three years from the date you pass.
- Renewal method: You renew by retaking the current version of the examination - there's no separate "renewal-only" assessment.
- Discount: A 50% discount applies to renewal exams taken before your existing certification expires.
Who Actually Takes This Exam
The official listing names Vertica database administrators as the intended audience. That framing matters for how you prepare: this isn't a general analytics or BI credential, and it isn't aimed at data scientists writing queries from the outside. It's built for people who own performance and schema decisions inside a Vertica deployment - the people who decide how tables and projections are physically structured.
If you're evaluating whether this fits your career path, the ROI analysis and the salary guide both dig into how this credential is typically used on a resume. For eligibility questions - whether you need prior Vertica experience or specific coursework first - see the ADVAP Requirements 2026 page. You can also browse current ADVAP-related job listings to see how employers describe the role in practice.
A Compressed Final-Week Review Plan
With only two domains, a short, focused review in the days before your test date is more useful than a long generic study calendar. Here's a compressed structure built specifically around ADVAP's two preparation areas.
Vertica Projection Tuning
- Practice reading full query execution plans and identifying the specific step causing slowness
- Run through Database Designer scenarios and note when manual redesign beats automated recommendations
- Drill query-performance configuration options tied to projection behavior
Vertica Aggregate Projection Design
- Build a one-line definition and one use case for each of the four projection types
- Work scenario questions that ask "which projection type fits this query pattern"
Full-Length Practice and Pacing
- Take timed practice sets at the two-hour, 60-question pace to build comfort with the clock
- Review any missed items by mapping them back to Domain 1 or Domain 2, not just "wrong answer"
Timed practice matters here because the two-hour window leaves little room for second-guessing. Practicing full-length runs under realistic exam conditions before your scheduled date is one of the simplest ways to catch pacing problems early. For a broader, non-compressed version of this plan, see the full ADVAP Study Guide 2026.
Quick-Reference Table
| Detail | Fact |
|---|---|
| Fee | USD 500, excluding VAT/taxes |
| Questions | 60 |
| Time limit | 2 hours |
| Format | Multiple-choice and true/false |
| Passing score | 70% (42/60) |
| Language | English |
| Audience | Vertica database administrators |
| Preparation areas | Vertica Projection Tuning; Vertica Aggregate Projection Design |
| Validity | 3 years |
| Renewal discount | 50% before expiration |
| Retake #2 | Immediate, no wait |
| Retake #3+ | Minimum 14-day wait; separate fee each time |
| Registration platform | Rocket Learn |
Frequently Asked Questions
No. ADVAP is the identifier this site uses to refer to the Vertica Analyst Certification Exam. It is not the official code used on Rocket Learn's listing.
The exam has 60 questions in a two-hour session, delivered only as multiple-choice or true/false items - no open-ended or lab-based questions.
You need 70%, which is 42 correct answers out of 60. See the ADVAP Passing Score 2026 page for more detail on how that threshold is applied.
You can retake the exam immediately after a first failure. Any attempt beyond the second requires waiting at least 14 days, and each additional attempt is charged separately at the standard fee.
Yes - it's valid for three years. Renewal happens by retaking the current version of the exam, and a 50% discount applies if you renew before your certification expires.
Keep this page bookmarked as your final review layer, but don't treat it as a replacement for working through real scenario questions on execution plans and aggregate projection types. Pair it with focused practice sessions on our practice test platform, and revisit the domains guide if any section above felt unfamiliar.