· 192 questions
Amazon Athena Study Guide
About 200 interview-style questions on Amazon Athena: how serverless SQL on S3 works, tables and SerDes, partitions and partition projection, file formats, Iceberg tables, CTAS…
Study guides
Question-by-question study guides on the data engineering stack. Every answer is collapsible so you can quiz yourself, and the filter box finds any question in a guide.
· 199 questions
Amazon RDS Study Guide
About 200 interview-style questions on Amazon RDS and Aurora: engines, instance and storage choices, high availability with Multi-AZ, read replicas, backups and restores,…
· 195 questions
Apache Airflow Study Guide
About 200 interview-style questions on Apache Airflow, from DAGs and operators to scheduling, sensors, assets, executors, testing, deployment and troubleshooting. The answers…
· 201 questions
AWS Certified Cloud Practitioner Study Guide
About 200 questions and short answers I used to prepare the AWS Certified Cloud Practitioner exam (CLF-C02), which I passed in October 2026. They follow the exam's four domains:…
· 204 questions
AWS Glue Study Guide
About 200 interview-style questions on AWS Glue: the Data Catalog, crawlers, Spark ETL jobs, DynamicFrames, job bookmarks, workers and cost, streaming, data quality,…
· 207 questions
CI/CD for Data Study Guide
About 200 interview-style questions on CI/CD and automation for data platforms: Git workflows, testing strategies for pipelines and data, code quality, environments,…
· 208 questions
Data Architecture Study Guide
About 200 interview-style questions on data architecture: principles, storage and database choices, distributed systems trade-offs, modeling approaches (Inmon, Kimball, Data…
· 209 questions
Data Warehousing Study Guide
About 200 interview-style questions on data warehousing: core concepts, dimensional modeling with facts and dimensions, slowly changing dimensions, loading patterns, data quality,…
· 202 questions
Databricks Study Guide
About 200 interview-style questions on Databricks, from the lakehouse idea to Delta Lake, Unity Catalog, ingestion, Lakeflow pipelines and jobs, performance tuning, security and…
· 205 questions
dbt Study Guide
About 200 interview-style questions on dbt (data build tool), from the basics to incremental models, snapshots, testing, deployment and performance. The answers refer to dbt Core…
· 205 questions
Hadoop Study Guide
About 200 interview-style questions on Apache Hadoop and its ecosystem: HDFS, YARN, MapReduce, file formats, Hive, HBase, ZooKeeper, ingestion tools, security, operations and the…
· 201 questions
PostgreSQL Study Guide
About 200 questions on PostgreSQL and SQL for data engineering interviews: architecture, data types, querying, window functions, indexes, transactions and MVCC, performance…
· 212 questions
PySpark Study Guide
About 200 questions on PySpark for data engineering interviews: Spark's architecture, SparkSession and RDDs, DataFrames and column functions, aggregations, joins, window…
· 200 questions
Python Study Guide
About 200 questions on Python for data engineering interviews: the language itself, the standard library, object-oriented programming, generators and decorators, concurrency,…
· 205 questions
Snowflake Study Guide
About 200 interview-style questions on Snowflake, from its architecture to virtual warehouses, micro-partitions, loading, semi-structured data, streams and tasks, dynamic tables,…