[Solved] You have a large sales table that updates daily with new sales and corrections to... Which incremental strategy should you choose in dbt to efficiently update the table without full reloads? | dbt

dbt - Incremental Models

You have a large sales table that updates daily with new sales and corrections to existing sales records. Which incremental strategy should you choose in dbt to efficiently update the table without full reloads?

Amerge, because it updates existing rows and adds new ones

Bdelete+insert, because it deletes all rows and inserts fresh data

Cappend, because it only adds new rows

Dfull refresh, because incremental strategies are not suitable

Step-by-Step Solution

Solution:

Step 1: Analyze data update needs
The table has new sales and corrections, so existing rows need updates and new rows need inserts.
Step 2: Match strategy to needs
Append only adds new rows, so it won't update corrections. Delete+insert replaces matching rows but can be costly. Merge efficiently updates and inserts rows incrementally.
Final Answer:
merge, because it updates existing rows and adds new ones -> Option A
Quick Check:
merge = update + insert for corrections and new data [OK]

Quick Trick: Use merge for updates plus new rows efficiently [OK]

Common Mistakes:

MISTAKES

Choosing append and missing updates
Thinking delete+insert always best
Ignoring performance of full refresh

Master "Incremental Models" in dbt

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More dbt Quizzes

Which incremental strategy should you choose in dbt to efficiently update the table without full reloads?

Step 1: Analyze data update needs

Step 2: Match strategy to needs

Final Answer:

Quick Check:

Want More Practice?