SOL-C01 · Question #209
A data scientist wants to use the COMPLETE function in Snowflake Cortex to perform sentiment analysis on social media posts. They have a table named 'SOCIAL MEDIA POSTS with a column 'POST TEXT'…
The correct answer is E. Option E. Option E is the most appropriate. It explicitly instructs the COMPLETE function to classify the sentiment and provides the possible classifications (Positive', 'Negative', or 'Neutral'). Combining text with II and using smaller snowflake model to minimize compute cost.
Question
A data scientist wants to use the COMPLETE function in Snowflake Cortex to perform sentiment analysis on social media posts. They have a table named 'SOCIAL MEDIA POSTS with a column 'POST TEXT' containing the post content. They want to classify each post as either 'Positive', 'Negative', or 'Neutral'. Which of the following SQL statements is the MOST appropriate for this task?
Exhibit
Options
- AOption A
- BOption B
- COption C
- DOption D
- EOption E
How the community answered
(26 responses)- A4% (1)
- B4% (1)
- C12% (3)
- E81% (21)
Explanation
Option E is the most appropriate. It explicitly instructs the COMPLETE function to classify the sentiment and provides the possible classifications (Positive', 'Negative', or 'Neutral'). Combining text with II and using smaller snowflake model to minimize compute cost.
Topics
Community Discussion
No community discussion yet for this question.