dbt Analytics Engineer Certification Practice Test
dbt certification for analytics engineers covering data modeling, transformation, testing, documentation, and best practices with dbt Core and dbt Cloud. Administered by dbt Labs. Key domains include Creating and Maintaining dbt documentation, Debugging data modeling errors, Developing dbt models and Implementing and maintaining external dependencies. The exam consists of 65 questions over 120 minutes.
नमूना प्रश्न
पूरी परीक्षा कैसी है देखने के लिए कुछ प्रश्न आज़माएं।
In a dbt project involving a model with a versioned public contract used by another dbt project, A YAML file defines tests: [unique, not_null] under event_id, but dbt test says no tests were selected for fct_user_events. The model name in YAML is fct_event_ids while the SQL file is fct_user_events.sql. What is the most likely fix? Consider the operational side effects as well as compilation behavior; the best answer should avoid creating a hidden dependency or brittle production workflow.
In a dbt project involving a semantic model that exposes revenue metrics to the dbt Semantic Layer, A team uses state:modified+ in CI and notices a downstream model is not selected after only a test YAML file changed on its parent. What should they consider? Consider the operational side effects as well as compilation behavior; the best answer should avoid creating a hidden dependency or brittle production workflow.
In a dbt project involving a finance mart consumed by month-end close dashboards, The ad_platform team migrated a legacy SQL script that joins customers, orders, and payments in one file. They want dbt models that keep staging clean and business rules reusable. Which refactor best matches dbt modeling conventions? Assume the project already compiles except for the design choice described; choose the action that best preserves dbt lineage and environment safety.
In a dbt project involving a feature branch that changes one upstream dimension and two downstream marts, A production deployment job should run every weekday at 6 AM after the ingestion job. Which dbt Cloud configuration area is most relevant? Assume the project already compiles except for the design choice described; choose the action that best preserves dbt lineage and environment safety.
In a dbt project involving a model with a versioned public contract used by another dbt project, A producer project marks an intermediate model private, but a downstream project tries to cross-project ref it. Why should this fail or be rejected in review? Assume the project already compiles except for the design choice described; choose the action that best preserves dbt lineage and environment safety.