Data Tests

dbt — Advanced

Advanced incremental strategies, semantic layer concepts, CI for dbt, Slim CI, unit tests, governance, and performance. Mix of single-answer and multiple-answer items.

dbt — Intermediate

Incremental models, snapshots, macros, packages, exposures, and selection syntax. Mix of single-answer and multiple-answer items.

dbt — Beginner

dbt Core basics: projects, models, refs, materializations, and `dbt run`/`test`. Mix of single-answer and multiple-answer items.

SQL Fundamentals — Advanced

Window functions, recursive CTEs, isolation levels, EXPLAIN/plans, upsert patterns, deadlocks, and advanced join/set techniques. Mix of single-answer and multiple-answer items.

SQL Fundamentals — Intermediate

LEFT/anti-joins, GROUP BY/HAVING, subqueries, CTEs, CASE/COALESCE, EXISTS, set ops nuance, and basic transaction/index awareness. Mix of single-answer and multiple-answer items.

SQL Fundamentals — Beginner

Core SQL: SELECT, WHERE, ORDER BY, NULL, aggregates, DISTINCT, LIKE, and simple INNER JOIN. Mix of single-answer and multiple-answer items; multi-select questions ask you to select every correct statement.

Data Analytics — Intermediate

Dimensional modeling, attribution cautions, statistics hygiene, and warehouse patterns. Single- and multiple-choice.

Data Analytics — Beginner

Metrics, basic SQL analytics thinking, charts integrity, and experiment vocabulary. Single- and multiple-choice.

Data Analytics — Advanced

Causal inference cautions, MLOps for metrics, streaming vs batch, experimentation platforms, and privacy. Mixed choice types.