dbt Analytics Engineering Prep
AE Certification

dbt Analytics Engineering Prep

dbt model development, tests, documentation, Jinja/macros, dbt Cloud

900 Qs

Total questions

Practice + mock exams

1 cert

Supported exam

dbt Analytics Engineering

JA & EN

Question & answer language

English / 日本語

100%

Explanation coverage

Every question has a detailed explanation

Why Nicheelab

Pass with questions aligned to the dbt Labs official Exam Guide

dbt Analytics Engineering covered

Full coverage of the AE Certification scope

Bilingual questions & detailed explanations

900 questions in Japanese and English, grounded in the official dbt documentation

Study in your spare time

See the explanation right after each question — study from 5 minutes during commutes or breaks

Accuracy tracking

Automatically tracks accuracy per category and visualizes weak areas in charts

Multi-device ready

Optimized layout for desktop, tablet, and mobile

Aligned with official docs

Explanations built from the official dbt documentation


Supported exams

dbt Analytics Engineering

Analytics Engineering

AE Certification | 900 Qs

Pricing

Try for free

¥0

Sample the public problems

Recommended
Paid Plan

¥980/mo · US$6.20

Full access to all dbt practice + mock exams


dbt Certification Study Guide

Articles to support your exam prep

Certification Overview

Where the Analytics Engineer cert fits in

Analytics Engineer Exam

Scope, weighting, registration

Difficulty Guide

Required skills and study-time estimates

Study Strategy Guide

Official materials and hands-on practice

Sample Questions

Sample questions by domain

Exam Cost Guide

Fees, vouchers, retakes

Pass Stories

Test-day flow and gotchas

dbt Cloud Free Tier

Learning environment on the Developer Plan

Career Value

Market value as an Analytics Engineer

Cloud vs Core

Feature differences and how to choose

Project Structure

Layout of models/seeds/macros

Models Basics

Transformation units defined in SQL

Sources & freshness

External tables and freshness checks

Tests Overview

Generic / singular tests

Macros Basics

Reusable logic in Jinja

Key CLI Commands

run / test / build / compile

Materializations

view/table/incremental/ephemeral

Incremental

Incremental ingestion fundamentals

ref() function

Dependency resolution and inter-model refs

Jinja Basics

Must-know syntax for dbt

CI/CD Overview

From PR to production

Slim CI

Diff only via state:modified+

Semantic Layer

Unified metrics philosophy

Packages

Dependency management and installation

Study on your phone, too

Study efficiently in the Android app during your commute and spare moments.
Your progress syncs with the same account you use on the web.

Get it on Google Play

Start studying now

Pass your dbt certifications with bilingual study resources

Terms of ServicePrivacy PolicyNotation based on the Act on Specified Commercial TransactionsContact & Cancellation

© 2026 NicheeLab All rights reserved. | dbt is a trademark of dbt Labs, Inc.