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 questionsThe 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.
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.
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.
Keep practicing
Take the free SOL-C01 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other SOL-C01 practice questions
- Question 1Which Snowflake object is a logical container for schemas and other database objects?
- Question 2How can Python variable substitution be performed in Snowflake notebooks?
- Question 3Which SQL command is commonly used to load structured data from a stage into a Snowflake …
- Question 4Which command can be used to query the Information Schema in Snowflake to retrieve a list…
- Question 5Which command is synonymous with the LIST command in Snowflake?
- Question 6Which of the following data format supported to unload semi-structured data from Snowflak…
