What is the default Load Frequency for full-extract versus incremental tables?

What is the default Load Frequency for full-extract versus incremental tables?

• A. All tables are daily
• B. Monthly
• C. Full-extract tables are weekly; Incremental tables are daily
• D. Weekly

Answer: (C)

The idea behind load frequency here is that full-extracts and incremental loads have different workload and freshness characteristics. A full-extract rebuilds the entire table in one go, so it’s heavier on resources. Because of that, it’s common to run it less often—weekly—as a balance between keeping the data reasonably fresh and not overloading the system. Incremental loads only bring in new or changed rows since the last load, so they’re much lighter and can be run more frequently to keep data up to date; daily incremental loads are typical to minimize latency to downstream reports and analytics. Choosing a monthly cadence for full-extracts would leave data stale for longer, and running a daily full-extract is usually unnecessary and resource-intensive. A weekly full-extract paired with daily incremental loads provides a practical default that matches how these processes are commonly used.

The idea behind load frequency here is that full-extracts and incremental loads have different workload and freshness characteristics. A full-extract rebuilds the entire table in one go, so it’s heavier on resources. Because of that, it’s common to run it less often—weekly—as a balance between keeping the data reasonably fresh and not overloading the system. Incremental loads only bring in new or changed rows since the last load, so they’re much lighter and can be run more frequently to keep data up to date; daily incremental loads are typical to minimize latency to downstream reports and analytics.

Choosing a monthly cadence for full-extracts would leave data stale for longer, and running a daily full-extract is usually unnecessary and resource-intensive. A weekly full-extract paired with daily incremental loads provides a practical default that matches how these processes are commonly used.