How to become a dbt Certified Developer
The dbt (data build tool) Certification let’s you show you’re a reliable source for Analytics Engineering industry’s development for (Operational) Analytics.
I would recommend Paul Fry’s article “Preparing for the dbt ‘Analytics Engineering’ Certification” as an introduction to what the dbt Certified Developer Certification is and resources.
This article will cover additional material & tips that would be helpful for folks, like myself
- About me: I have 2+years of dbt experience, 3+ years of Python development for Analytics and reporting. I am currently a Sr. Data Analyst @ Autodesk.
What would you do?
These questions are geared towards experienced model & development. Moreover, the question range from starting a dbt project to developing & testing (i.e Building) your first model.
I would say this exam is more geared towards the following folks:
- 3-6months of startup or full dbt project build
- 6+months in dbt experience
If you are a newcomer to the space, I recommend developing a dbt project using your preffered Database & BI tool. You can find trials for such tools on their available website.
- NOTE: If you work with a company, even better! Try out local dbt development!
My (personal) recommended tools w/free trials are the following:
- Database - Snowflake
- BI - Mode Analytics
- BI - Preset
You can see how I developed a dbt project, in my past (personal) training course Analytic Engineering & dbt: 0-100
You can be technically correct in one sense, but wrong in the question’s scenario
There are certain pieces of terminology you have to certainly know. The scenario for each question sets you up to solve a problem in the context of one part of the Analytic Engineering practice, but proposed answers can be part of another part.
Imagine you are configuring a YAML file called
src_sfdc.yml. The question you get calls for identifying a test configuration. You have 4 multiple choice questions. Two of them say “model” in their explanation, and sound right. REMEMBER, this is about a Source, not a model.
Mitigating Non-dbt Exam issues
Learning about Discrete Option Multiple Choice (DOMC) questions…before you find out the hard way.
I didn’t look into DOMC-style questions. When I first saw one, I was a bit confused on what to do. Moreover, what the interpretation of a Yes/No question meant. As a consequence, I wasted 1min-2min deciphering what to do. That time could have been ~1.8mins on re-evaluating another question (120mins / 65 Q’s).
As a summary:
“DOMC represents a relatively simple but very useful change in the delivery of multiple choice question. Instead of showing all of the options at one time, as is usually done, options are randomly presented one at a time. For each presented option, the test taker chooses YES or NO indicating whether the he or she thinks it is the correct one.” - source
I should also note that DOMC-style questions are not necessarily 2+ Yes/No path questions. They could be 1 Yes/No or 3 Yes/No path questions.
Types of Questions
- Developing dbt models
- Debugging data modelling errors
- Monitoring data pipelines
- Implementing dbt tests
- Deploying dbt jobs
- Creating and maintaining dbt documentation
- Promoting code through version control
- Establishing environments in a data warehouse for dbt
Questions can vary
After I passed the exam at Coalesce’22, I was headed back to the main conference floor. Approaching the staircase, I found someone else that passed the exam.
- Note: You can tell because they we got special swag for being one of the many few becoming dbt Certified Developers
We got to talking, and he mentioned some of the Snapshot-related scenario questions he had. I told him “WHAT Snapshot questions?” I got 3+ Incremental materialization questions, but I didn’t get any Snapshot questions…
Another theory to the test is that questions can vary on what is served up on the test.
This makes sense because the person who developed the Exam provides high standard exams that minimize cheating, compared to other tool/software certifications.
Hope you enjoyed this article, and good luck on your upcoming exam!
Last day at #dbtCoalesce 😭♥️— ℝaul ∈ 🥑 (YIMBY) 🚲 ❤ (@RaulingAverage) October 21, 2022
Became a dbt Certified Developer & had some fun! pic.twitter.com/iMnVkSptXy
- dbt Fundamentals
- Advanced Materialization
- Mainly focus on Snapshot & Incremental Materialization methods
- Jinja & Macro Statements
- Advanced Materialization
- Coalesce NOLA ‘22