SOL-C01 practice question 17 of 30

Which function would you use to determine the sentiment of a customer review in Snowflake Cortex?

Full set: 214 questions
Answer options
A: TRANSLATE
B: COMPLETE
C: SENTIMENT Correct answer
D: PARSE_DOCUMENT
Correct Answer:
C. SENTIMENT
Explanation

The Snowflake Cortex SENTIMENT function is specifically designed to analyze text and determine its sentiment. It returns a numerical score between -1 (negative) and 1 (positive), allowing for the classification of text, such as customer reviews, into categories like positive, negative, or neutral. This function is part of Snowflake's set of pre-trained models for common natural language processing tasks.

Why Incorrect

A. TRANSLATE: This function is used for converting text from a source language to a target language, not for analyzing its sentiment.
B. COMPLETE: This function uses a large language model (LLM) to generate text completions based on a prompt, not to analyze sentiment.
D. PARSEDOCUMENT: This function is used to extract text content from unstructured document files, not to determine the sentiment of the text.

References

1. Snowflake Documentation. (n.d.). SENTIMENT. Snowflake Inc. Retrieved from https://docs.snowflake.com/en/sql-reference/functions/sentiment. "Returns a sentiment score between -1 and 1 for a given string of text."

2. Snowflake Documentation. (n.d.). Snowflake Cortex LLM Functions. Snowflake Inc. Retrieved from https://docs.snowflake.com/en/user-guide/snowflake-cortex/llm-functions. This page lists SENTIMENT as a function for sentiment analysis.

Scroll to Top