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

dbt-Analytics-Engineering Exam Question 106

(Multiple Select)

A.Macros can completely obfuscate dependencies, making them untraceable.

B.If macros reference raw tables, those dependencies might not be reflected in dbt's lineage graphs.

C.Macros generally make dependency tracking easier by encapsulating logic.

D.If macros themselves have dependencies on other macros, this adds an extra layer to consider.

dbt-Analytics-Engineering Exam Question 107

"Our dbt jobs take hours to run, and it's hard to know why!" says a frustrated colleague. What initial investigation steps would you suggest?

A.All of the above.

B.Check your dbt_project.yml configuration for any project-wide performance settings to optimize.

C.Look into dbt's profiling capabilities to pinpoint the slowest models and queries.

D.Review any 'on-run-start' or 'on-run-end' hooks that might add unexpected overhead.

dbt-Analytics-Engineering Exam Question 108

You notice that long descriptions within sources.yml cause formatting issues when viewing the docs, making them hard to read. What strategies could you employ to mitigate this?

A.Enforce a strict character limit on source descriptions-

B.Utilize Markdown within your descriptions to improve readability with headings and line breaks-

C.Use a third-party dbt package that enhances the presentation of source descriptions in documentation.

D.Split your source description into multiple properties (e.g., description_short and description_long)

dbt-Analytics-Engineering Exam Question 109

You want to trigger a dbt job immediately upon successful completion of an upstream ETL process. Which methods could achieve this?

A.Configuring the ETL process to send a completion notification to your CIICD tool, triggering the dbt job.

B.Using dbt Cloud's webhooks to create an endpoint that your ETL process can call.

C.Scheduling a dbt job with a very frequent interval (e.g., every 5 minutes) to poll for changes in a metadata table.

D.Using the dbt build command to run all dependent models after a successful dbt run.

dbt-Analytics-Engineering Exam Question 110

(Multiple Select)

A.Add {{ log(macros, info=true) statements within the macro to track how it executes-

B.Check the generated column names in the compiled SQL to ensure they match existing columns in the data.

C.Run dbt Is to confirm that all dependencies for the macro and the model are resolved correctly.

D.Implement unit tests specifically for the macro to validate its output under different inputs

Latest Upload: 140CrowdStrike.CCSE-204.v2026-06-12.q25; 160VMware.2V0-17.25.v2026-06-12.q49; 147Appian.ACA-100.v2026-06-11.q23; 204CompTIA.220-1202.v2026-06-11.q114; 162CheckPoint.156-590.v2026-06-11.q47; 221CompTIA.220-1202.v2026-06-10.q109; 194CertiProf.CEHPC.v2026-06-10.q54; 151Hitachi.HQT-4160.v2026-06-10.q25; 387PMI.PMI-ACP-CN.v2026-06-09.q453; 190Splunk.SPLK-5002.v2026-06-08.q52

dbt-Analytics-Engineering Exam Question 106

dbt-Analytics-Engineering Exam Question 107

dbt-Analytics-Engineering Exam Question 108

dbt-Analytics-Engineering Exam Question 109

dbt-Analytics-Engineering Exam Question 110

Download PDF File