Question 570
A multi-step transformation should be automatically materialized and refreshed toward a target lag. Which object fits?
Explanation
Correct Answer
Correct: a dynamic table. Dynamic table stores the result of a defined transformation and refreshes automatically.
Incorrect Answers
Not best here: Standard view provides a nonmaterialized reusable SQL definition; the case calls for a dynamic table.
Not best here: Materialized view maintains a supported single-table materialized query result; the case calls for a dynamic table.
Not best here: External table represents accessible data stored in supported external object-storage files; the case calls for a dynamic table.