Valid dbt-Analytics-Engineering Dumps shared by EduDump.com for Helping Passing dbt-Analytics-Engineering Exam! EduDump.com now offer the newest dbt-Analytics-Engineering exam dumps, the EduDump.com dbt-Analytics-Engineering exam questions have been updated and answers have been corrected get the newest EduDump.com dbt-Analytics-Engineering dumps with Test Engine here:
Examine this query: select * from {{ ref('stg_orders') }} where amount_usd < 0 You want to make this a generic test across multiple models. Which set of two standard arguments should be used to replace {{ ref('stg_orders') }} and amount_usd? Choose 1 option.
Correct Answer: B
When converting a model-specific SQL query into a generic test, dbt expects the test macro to accept the two standard arguments used across all generic tests: model and column_name. These arguments allow dbt to automatically pass the correct table and the correct column when the test is applied in YAML. The argument model represents the actual relation (table/view) being tested. dbt compiles the reference itself-so instead of writing ref('stg_orders'), generic tests always use {{ model }} to represent the referenced relation. The argument column_name represents the actual column being tested. In this case, the hard-coded column amount_usd becomes the dynamic argument {{ column_name }}, allowing you to apply the logic to any numeric or validated column across multiple models. So the generic version of your SQL becomes: select * from {{ model }} where {{ column_name }} < 0 The other options are incorrect: * source is not the standard argument for generic tests. * model_name is not automatically passed by dbt. * field is not a recognized standard test argument. Thus, the two correct standard arguments are model and column_name.
