SOL-C01 · Question #206
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')…
The correct answer is A. Create a scheduled task that runs daily, classifies the new reviews using CLASSIFY TEXT, and B. Create a stream on the product reviews table and a task that is triggered by the stream. The task. 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…
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
How the community answered
(33 responses)- A58% (19)
- C6% (2)
- D15% (5)
- E21% (7)
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.
Topics
Community Discussion
No community discussion yet for this question.