Snowpro Advanced Architect · Free Practice Question Medium
Question 24
- A Standard View
- B External Table
- C Materialized View
- D Dynamic Table
Reveal correct answer
Correct answer: D
Explanation
✅ Dynamic Table
Explanation:
To automatically refresh a table (daily_sales_summary) based on a source table (raw_sales_data) with transformations applied, the best Snowflake object is a Dynamic Table.
Continuous, automated refresh → Dynamic Tables automate incremental data updates, ensuring fresh data without manual intervention.
Declarative transformation capability → Allows users to define transformation logic without needing explicit task schedules.
Optimized for reporting layers → Ensures efficient data processing for dashboards and analytics.
For more details, check the official Snowflake blog on Dynamic Tables and Quickstart guide.
❌ Why the other options are incorrect?
Materialized View
→ Incorrect, because Materialized Views do not support complex transformations like joins and aggregations efficiently.
Standard View
→ Incorrect, because Views do not store precomputed results, leading to repeated computation on every query.
External Table
→ Incorrect, because External Tables reference external storage, making them unsuitable for transformation pipelines.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
