Q: 7
How would you determine the size of the virtual warehouse used for a task?
Options
Discussion
D . Using Multi-cluster warehouse (MCW) is recommended because it scales automatically for concurrent task runs, so you don't have to guess or manually adjust sizing. Other options are more manual or situational. Pretty sure that's what Snowflake wants here, but open to other ideas if I missed something.
D. not B. MCW handles concurrency automatically for scheduled tasks, so that's the recommended approach here.
Option D-B is a trap, sizing by stream content only works sometimes but MCW covers scheduled concurrency.
C/D? Exam reports make it sound like D is right with MCW but C makes sense for first-time stored procs.
Its B. If you check the stream content size, you can estimate how much warehouse power is needed for the task, especially if it's going to process a lot of data. Pretty sure that's the way to approach it since bigger streams might need larger warehouses.
I think D is the best fit. Multi-cluster warehouse (MCW) lets Snowflake automatically scale compute to match how many scheduled tasks need to run, so you don't have to set a fixed size. Pretty sure that's what they're looking for but could be missing some nuance here. Agree?
Be respectful. No spam.
