問題文
A stored procedure orchestrates five independent refresh statements that each take about 8 minutes and do not depend on each other. The team wants the total run time to be closer to 8 minutes than to 40. What feature addresses this?
選択肢
- Launch the statements asynchronously inside the procedure and wait for all of them before returning, so they overlap in time.
- Add clusters to the warehouse and the tasks so that the procedure's statements are distributed across them and run at the same time.
- Convert the procedure into five user-defined functions, which Snowflake evaluates in parallel when they appear in the same query.
- Increase the warehouse size so that the five sequential statements each complete in one fifth of the time.