SnowPro Core Certification — Question 1132

A Snowflake user wants to design a series of transformations that need to be executed in a specific order, on a given schedule.

What Snowflake objects should be used?

Answer options

• A. Pipes
• B. Tasks
• C. Streams
• D. Sequences

Correct answer: B

Explanation

The correct answer is B, as Tasks in Snowflake are designed to run SQL statements on a scheduled basis and can be orchestrated to execute in a specified order. Pipes are used for data ingestion, Streams are utilized for change data capture, and Sequences are for generating sequential numbers, which do not fulfill the requirement of executing transformations in a specific order on a schedule.