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 how freshness is defined at the database level: - name: raw database: raw freshness: # default freshness warn_after: {count: 12, period: hour} error_after: {count: 24, period: hour} loaded_at_field: _etl_loaded_at How can one table from the source raw be excluded from source freshness?
Correct Answer: A
In dbt, source freshness can be defined at the source level (affecting all tables) or overridden at the individual table level. When freshness is declared at the source root, dbt applies the freshness policy to every table within that source unless a specific table opts out. The official dbt documentation states that setting: freshness: null at the table level disables freshness checks for that specific table, even when the source itself defines default freshness rules. This is the only documented way to exclude an individual table from a source freshness policy. Option B is incorrect because tables can override and disable freshness even when the parent source defines it. dbt's configuration hierarchy supports overriding child-level settings on a per-resource basis. Option C (loaded_at_field: null) does not disable freshness-it simply removes the loaded_at_field, which would cause dbt to error because a freshness check requires a timestamp field to operate. Option D (error_after: null) only removes the error threshold but does not disable freshness. The table would still participate in freshness checks and could trigger warnings. Thus, the correct and dbt-supported method to exclude a table from freshness is to explicitly set: freshness: null making A the correct answer.