What approach shoul...
 
Notifications
Clear all

What approach should Oliver choose that would be most efficient and minimize the chance of losing historical data?

1 Posts
1 Users
0 Likes
81 Views
Marshall
(@cainsmarshall)
Prominent Member
Joined: 7 months ago
Posts: 329
Topic starter  

Oliver is designing an ETL process to copy sales data into a data warehouse on a hourly basis.

What approach should Oliver choose that would be most efficient and minimize the chance of losing historical data?

  • A . Bulk load.
  • B . Purge and load.
  • C . Use ELT instead of ET
  • E . Delta load.

Show Answer Hide Answer

Suggested Answer: D

Explanation:

D. Delta load

Since Oliver needs to migrate changes every hour, a delta load is the best approach.

   
Quote
Topic Tags
Share: