Exam SnowPro Advanced Architect topic 1 question 42 discussion

Actual exam question from Snowflake's SnowPro Advanced Architect

Question #: 42
Topic #: 1

[All SnowPro Advanced Architect Questions]

A company’s daily Snowflake workload consists of a huge number of concurrent queries triggered between 9pm and 11pm. At the individual level, these queries are smaller statements that get completed within a short time period.
What configuration can the company’s Architect implement to enhance the performance of this workload? (Choose two.)

A. Enable a multi-clustered virtual warehouse in maximized mode during the workload duration.
B. Set the MAX_CONCURRENCY_LEVEL to a higher value than its default value of 8 at the virtual warehouse level.
C. Increase the size of the virtual warehouse to size X-Large.
D. Reduce the amount of data that is being processed through this workload.
E. Set the connection timeout to a higher value than its default.

Show Suggested Answer

Suggested Answer: AB 🗳️

by hillcat111 at June 9, 2023, 12:25 p.m.

Comments

Submit Cancel

Arkitekt

1 month, 3 weeks ago

Selected Answer: AB

It's all about concurrency of many small queries, and that's the point of a multi-clustered warehouse. Warehouse size is more about handling large single queries.

upvoted 1 times

...