dbt Analytics Engineering Certification

By dbt Labs · Question Mode

QuestionQ26

Verified

Match each description to the materialization.

Select
Drops and recreates a definition of a query which is executed at the time it's referenced
Inserts or updates records of an existing object in the warehouse using a delta
Code belonging to the model is inserted into the places the model is referenced
Drops and recreates an object in the warehouse as stored results when using dbt run
Explanation

A view stores a query definition rather than its results. Incremental models process changes into an existing table. Ephemeral models are incorporated into dependent queries as common table expressions. Table models are rebuilt as tables containing stored results. (docs.getdbt.com)

Learn more

Community Discussion

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