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

dbt-Analytics-Engineering Exam Question 111

You need to build a model to identify customers who haven't placed orders in the past 90 days. Performance with this model is critical, as it will trigger a re-engagement campaign. Which strategy is likely to yield the best results?

A.Filter the orders table for dates within the past 90 days, then find customers without corresponding order IDs.

B.Join the customers and orders table, group by customer ID and use a HAVING clause to filter inactive customers.

C.IJse a window function to rank order dates for each customer and filter those where the most recent order is older than 90 days.

D.Create a materialized view that contains only active customers and join against the orders table.

dbt-Analytics-Engineering Exam Question 112

You have a time-series fact table, and you're building incremental dbt models for efficiency. Model A loads an initial snapshot; subsequent models process new records only. During a dbt run, a model that processes new data fails. Select the possible consequences:

A.The initial snapshot will remain intact, but no new data will be updated.

B.dbt will revert the fact table to a state before the project was ever run.

C.All incremental models will need to be manually rerun after fixing the failed model.

D.The initial snapshot and all successfully processed incremental models will be unaffected.

dbt-Analytics-Engineering Exam Question 113

You're working on a dbt project in a development environment where compute resources are limited. You want to prototype a new model quickly without incurring high materialization overhead. Which materialization would be most suitable for this?

A.Incremental

B.Ephemeral

C.Snapshot

D.Table

dbt-Analytics-Engineering Exam Question 114

You're refactoring a project with long model files containing intertwined logic. Which of the following is NOT a typical sign of a good candidate for applying modularity principles?

A.The same SQL patterns are repeated with minor variations.

B.Portions of the logic form distinct conceptual steps in the transformation process.

C.The models are relatively small and perform simple transformations.

D.Renaming code blocks would improve readability.

dbt-Analytics-Engineering Exam Question 115

(Multiple Select)

A.You've refactored a core model and need to quickly validate its output and downstream dependencies.

B.A critical upstream data source has been delayed, and you only want to refresh dependent models once the data arrives.

C.There's an urgent request to update a single dashboard, and you know the exact subset of models to re-run.

D.You need to temporarily disable a computationally expensive model that isnt critical for daily reporting.

Latest Upload: 143CrowdStrike.CCSE-204.v2026-06-12.q25; 162VMware.2V0-17.25.v2026-06-12.q49; 151Appian.ACA-100.v2026-06-11.q23; 208CompTIA.220-1202.v2026-06-11.q114; 164CheckPoint.156-590.v2026-06-11.q47; 224CompTIA.220-1202.v2026-06-10.q109; 205CertiProf.CEHPC.v2026-06-10.q54; 152Hitachi.HQT-4160.v2026-06-10.q25; 403PMI.PMI-ACP-CN.v2026-06-09.q453; 193Splunk.SPLK-5002.v2026-06-08.q52

dbt-Analytics-Engineering Exam Question 111

dbt-Analytics-Engineering Exam Question 112

dbt-Analytics-Engineering Exam Question 113

dbt-Analytics-Engineering Exam Question 114

dbt-Analytics-Engineering Exam Question 115

Download PDF File