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

Question

A company uses Snowflake Cortex's CLASSIFY TEXT to categorize product reviews. They want to track the daily distribution of reviews across different categories ('Positive', 'Negative', 'Neutral'). They need to create a robust and efficient solution for reporting on this trend. Which of the following approaches offers the best combination of performance, maintainability, and cost- effectiveness? Select two options.

Options

• ACreate a scheduled task that runs daily, classifies the new reviews using CLASSIFY TEXT, and
• BCreate a stream on the product reviews table and a task that is triggered by the stream. The task
• CDirectly query the raw product reviews table with CLASSIFY _ TEXT and group by date and
• DCreate a stored procedure that performs the classification and updates a summary table. Call this
• EReclassify all product reviews every night, overwriting the classification categories in a reporting

Explanation

Options A and B offer the best balance. Option A provides scheduled execution and summary data, enabling efficient reporting. Option B uses streams and tasks to incrementally update a materialized view, which is also efficient and reduces processing time. Option C is inefficient because it performs the classification on every dashboard refresh. Option D has a similar problem as C. Option E leads to data overwriting.

No community discussion yet for this question.