🔥 3-day streak
Snowflake SnowPro Core (COF-C03)38 / 148
Question 38 of 148

A data engineer needs to build a continuously refreshing transformation that joins raw order and customer tables and materializes the aggregated result. The business requires the transformed data to never be more than 5 minutes stale, and the team wants to avoid writing and scheduling custom tasks or streams to manage incremental refresh logic. Which Snowflake object best meets these requirements?

Reviewed for accuracy · Report an issueNext question