Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Question 120

How would you determine the size of the virtual warehouse used for a task?

Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution

Querying (SELECT) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size

If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first

Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule

Correct Answer: C

If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first. This approach allows you to understand the specific computational resource needs of the stored procedure and adjust the virtual warehouse size accordingly to ensure efficient execution.

Discussion

SV1122Option: C

"Multi-cluster warehouses are best utilized for scaling resources to improve concurrency for users/queries. They are not as beneficial for improving the performance of slow-running queries or data loading. For these types of operations, resizing the warehouse provides more benefits." Snowflake representative explained this here https://community.snowflake.com/s/question/0D50Z00009F8nPTSAZ/how-to-choose-the-right-virtual-warehouse-size-in-snowflake-for-your-workload

corentinOption: B

I think B

Mayuri917233Option: C

C is correct

grabcOption: C

C should be correct

arpit_dataguyOption: C

C is the right answer as D talks about concurrency.