SnowPro Advanced: Architect — Question 175

An Architect wants to construct an ETL pipeline that reads data from an external stage using an external table. This pipeline will perform multiple transformations on the changed data, incorporate data from dimension tables through joins, and ultimately load the processed data into a target table.

What should the Architect do to accomplish this task automatically?

Answer options

• A. Use streams and tasks.
• B. Use dynamic tables.
• C. Use materialized views.
• D. Use Snowpipe with the auto-ingest option enabled.

Correct answer: B

Explanation

The correct answer is B, as dynamic tables are designed for automatically managing and transforming data in response to changes, making them ideal for ETL processes. Streams and tasks (A) are suitable for change data capture but do not directly handle transformations and loading. Materialized views (C) do not support the full range of transformations required here. Snowpipe (D) is primarily focused on loading data from cloud storage and does not handle the transformation aspect as required in this scenario.