SnowPro Advanced: Architect — Question 190

An Architect is designing a solution that includes using dynamic tables to transform data, with a maximum target lag of five minutes behind any updates to the base table.

The base table contains a large data set against which there are frequent small updates. Queries against the data set contain only basic expressions.

Which setting will OPTIMIZE the dynamic table performance?

Answer options

• A. Use the REFRESH_MODE = AUTO setting to have the system select the optimal refresh mode based on performance.
• B. Use the REFRESH_MODE = INCREMENTAL setting to process updated data after each refresh execution.
• C. Use the REFRESH_MODE = FULL setting to reprocess the complete dataset during every refresh.
• D. Use the REFRESH_MODE = FULL for all refreshes.

Correct answer: B

Explanation

The correct answer is B, as using REFRESH_MODE = INCREMENTAL allows the system to update only the modified data after each refresh, thereby improving performance by reducing the load on the system. Options A and D do not optimize performance, as they either rely on automatic selection or unnecessarily reprocess all data. Option C also reprocesses the complete dataset, which is inefficient for frequent small updates.