Skip to main content
Data ⭐ Premium

dbt Analytics Engineering Certification - 340 Questions

By Webmaster Certland English ❤️ 0 likes

Practice exam for the dbt Analytics Engineering certification. Covers dbt development fundamentals, testing and documentation, advanced features, deployment, and analytics engineering practices.

⭐ Premium Updated Mar 2026

Unlock all 340 dbt Analytics Engineering Certification - 340 Questions questions

Full simulation · Detailed explanations · Unlimited attempts

  • 340 questions — ~5 full-length simulations
  • Detailed explanations — why each answer is right or wrong
  • Unlimited attempts — retake as many times as needed
  • Smart Practice + Focus Mode + no ads
340
Questions
All certifications
from $4.90/mo
⭐ Get Premium — $4.90/mo ▶ Try 5 questions free

Sample Questions — dbt Analytics Engineering Certification - 340 Questions

5 free sample questions from this practice exam. Correct answers are highlighted.

1. A data engineer is setting up a new dbt project. Which file is required at the root of every dbt project and contains the project name and version?

A dbt_project.yml ✓ Correct
B profiles.yml
C packages.yml
D schema.yml

2. A company stores a static list of country ISO codes and their full names in a CSV file. An analytics engineer wants to make this data available as a table in the data warehouse without writing a SQL model. Which dbt feature should they use?

A Define the CSV file as a source in sources.yml
B Place the CSV file in the seeds/ directory and run dbt seed ✓ Correct
C Create a snapshot referencing the CSV file path
D Register the CSV file as an exposure in the project

3. In a dbt project, where should SQL model files be placed by default?

A seeds/
B models/ ✓ Correct
C snapshots/
D macros/

4. An analytics engineer needs to configure a seed so that a column named `zip_code` is treated as a string rather than an integer. Where should this configuration be applied?

A Set column_types in dbt_project.yml under the seed configuration ✓ Correct
B Add a type annotation directly inside the CSV file header row
C Declare the seed as a source in sources.yml with the desired column type
D Create a schema.yml file in the models/ directory referencing the seed

5. A data team wants to load a static CSV lookup table into the data warehouse using dbt. Which dbt feature is designed for this use case?

A dbt Models
B dbt Snapshots
C dbt Seeds ✓ Correct
D dbt Sources

Want to test yourself for real?

Create a free account and run our exam simulation engine.

Free No credit card
  • Simulation engine
  • Up to 10 questions per attempt
  • Score & basic stats
Create free account Already have an account? Sign in
Best
Premium Premium
  • All 340 questions
  • Detailed explanations
  • Smart Practice + Focus Mode
⭐ Get Premium

Information

Questions 340
Time 2h
Difficulty Medium
Minimum Score 70.00%
▶ Try 5 questions — no account needed ⭐ Unlock all questions — Premium 🤍 Like

Related Exams

⭐ Premium

Google Professional Data Engineer - 340 Questions

340 questions · English
⭐ Premium

Microsoft Power BI Data Analyst (PL-300) - 340 Questions

340 questions · English
⭐ Premium

Microsoft Azure Data Fundamentals (DP-900) - 340 Questions

340 questions · English
⭐ Premium

AWS Certified Data Engineer Associate (DEA-C01) - 340 Questions

340 questions · English

Discussion

No comments yet. Be the first to start the discussion!

Sign in to join the discussion.