nerdexam
Snowflake

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' conta

Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #209. The question stem and answer options stay visible for context.

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?

Exhibit

SOL-C01 question #209 exhibit

Options

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

Unlock SOL-C01 to see the answer

You've previewed enough free SOL-C01 questions. Unlock SOL-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Snowflake Cortex#LLM Functions#Sentiment Analysis#SQL Querying
Full SOL-C01 Practice