nerdexam
SnowflakeSnowflake

ARA-C01 · Question #137

ARA-C01 Question #137: Real Exam Question with Answer & Explanation

Sign in or unlock ARA-C01 to reveal the answer and full explanation for question #137. The question stem and answer options stay visible for context.

Cost Optimization

Question

The following DDL command was used to create a task based on a stream: Assuming MY_WH is set to auto_suspend ?60 and used exclusively for this task, which statement is true?

Options

  • AThe warehouse MY_WH will be made active every five minutes to check the stream.
  • BThe warehouse MY_WH will only be active when there are results in the stream.
  • CThe warehouse MY_WH will never suspend.
  • DThe warehouse MY_WH will automatically resize to accommodate the size of the stream.

Unlock ARA-C01 to see the answer

You've previewed enough free ARA-C01 questions. Unlock ARA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Snowflake Tasks#Snowflake Streams#Virtual Warehouses#Cost Management
Full ARA-C01 PracticeBrowse All ARA-C01 Questions