Online Access Free dbtLabs.dbt-Analytics-Engineering.v2026-03-04.q170 Practice Test (Page 3)

dbt-Analytics-Engineering Exam Question 6

While onboarding new data sources to your dbt project, you discover some have unexpectedly high null rates in key columns. How would you integrate tests for this into your dbt workflow?

A.Create not_null tests on the raw source tables in a separate dbt project dedicated to source validation.

B.Write tests within the initial staging models that calculate and check the null percentage.

C.Include a data quality monitoring step in your upstream ETL process before data reaches dbt

D.Designate some nulls as acceptable by extending the not_null test with the OR condition.

dbt-Analytics-Engineering Exam Question 7

You get a warning during dbt run:WARNlNG: Found 100 rows in 'stg_customers' that will become duplicates in the 'dim_customers' target.

A.It's safe to ignore this warning, as de-duplication is handled automatically by dbt.

B.Investigate your dim_customers modeling logic to ensure a unique key is correctly used to prevent duplicates.

C.Update the stg_customers source definition to include filtering logic to remove duplicate rows.

D.Increase the memory allocated for the database to handle the large number of duplicates.

dbt-Analytics-Engineering Exam Question 8

(Multiple Select)

A.Encapsulating complex logic in well-named macros with descriptive comments.

B.Minimizing explicit model dependencies to create loosely coupled components.

C.Using clear and consistent naming conventions across models and macros.

D.Preferring long, monolithic SQL files with minimal CTEs.

dbt-Analytics-Engineering Exam Question 9

You want to display the runtime metrics (e.g., execution time) of each model directly on the DAG node. Which challenges might you face when implementing this?

A.dbt documentation is primarily static; it might not be able to render dynamic metrics that change with each execution.

B.Retrieving runtime metrics for each historical run might not be natively supported by dbt

C.Adding too much detailed information directly to the DAG could lead to visual clutter and make it overwhelming.

D.All of the above

dbt-Analytics-Engineering Exam Question 10

dbt Model Snippet:SQL

A.Your sources.yml file is not configured correctly-

B.Your dbt_projectyml file has a model-level schema override.

C.The stg_orders model uses a schema config in its own model SQL

D.There's a custom macro in use that dynamically changes schemas.

Latest Upload: 125ISTQB.CT-AI.v2026-06-18.q68; 236IIA.IIA-CIA-Part3.v2026-06-17.q220; 164WGU.Introduction-to-IT.v2026-06-17.q67; 202CompTIA.220-1202.v2026-06-16.q110; 135TheInstitutes.CPCU-500.v2026-06-16.q25; 216ACAMS.CAMS7-CN.v2026-06-16.q170; 260CBIC.CIC.v2026-06-15.q123; 152Peoplecert.ITIL-4-Specialist-High-velocity-IT.v2026-06-15.q16; 264HashiCorp.Terraform-Associate-004.v2026-06-15.q126; 159Peoplecert.ITILFNDv5.v2026-06-15.q26

dbt-Analytics-Engineering Exam Question 6

dbt-Analytics-Engineering Exam Question 7

dbt-Analytics-Engineering Exam Question 8

dbt-Analytics-Engineering Exam Question 9

dbt-Analytics-Engineering Exam Question 10

Download PDF File