nerdexam
SnowflakeSnowflake

SOL-C01 · Question #209

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

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.

Querying and Performance

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?

Options

  • AOption A
  • BOption B
  • COption C
  • DOption D
  • EOption E

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

#Snowflake Cortex#LLM Functions#Sentiment Analysis#SQL Querying

Community Discussion

No community discussion yet for this question.

Full SOL-C01 PracticeBrowse All SOL-C01 Questions