SOL-C01 · Question #136
You are designing a data pipeline in Snowflake to process streaming data from Apache Kafka. You need to choose the appropriate virtual warehouse size. The data arrives at a rate of 100,000 messages pe
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #136. The question stem and answer options stay visible for context.
Question
You are designing a data pipeline in Snowflake to process streaming data from Apache Kafka. You need to choose the appropriate virtual warehouse size. The data arrives at a rate of 100,000 messages per second, and each message is approximately IKB. The processing involves complex transformations and aggregations. Which of the following considerations are MOST critical when determining the optimal warehouse size?
Options
- AOnly the total volume of data (100MB/second) needs to be considered. Choose the smallest
- BThe complexity of the transformations and aggregations performed on the data significantly
- CThe number of concurrent users accessing the processed data is the primary factor. Choose a
- DAlways choose the largest available warehouse (X-Large or larger) to ensure optimal performance,
- EThe frequency of data arrival (100,000 messages/second) requires a warehouse with sufficient
Unlock SOL-C01 to see the answer
You've previewed enough free SOL-C01 questions. Unlock SOL-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.