SOL-C01 Question #136: Real Exam Question with Answer & Explanation

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

Explanation

The complexity of transformations and the frequency of data arrival both play crucial roles in determining warehouse size. Complex transformations require more compute power, and high data arrival rates require higher concurrency to avoid backlog. Option A is incorrect because it only considers data volume. Option C is relevant for querying the processed data, not for processing the streaming data itself. Option D is not cost-effective.

No community discussion yet for this question.