QuestionQ10

Verified

A developer has updated multiple models in their dbt project that are materialized as tables and views.

They want to run and test all models upstream and downstream of the modified models materialized as views.

Which command will achieve this? Choose 1 option.

Explanation

In dbt selection syntax a comma is an intersection (AND) and a space is a union (OR), while the + graph operator pulls in ancestors and descendants. The requirement combines two conditions, modified models and models materialized as views, together with their lineage, so a comma-joined selector with + operators on both sides is needed. Option E is the only choice that joins the state and view selectors with a comma and applies graph expansion to both; A lacks the + on the view selector, B ignores materialization entirely, C uses invalid @ syntax with separate (union) arguments, and D separates the selectors with a space, which unions them and selects far too much.

Learn more

Community Discussion

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