SOL-C01 · Question #208
A data engineer is tasked with using Snowflake Cortex's COMPLETE function to generate concise summaries of customer reviews stored in a table named `CUSTOMER REVIEWS. The 'CUSTOMER REVIEWS' table…
The correct answer is D. Option D. The most cost-effective solution will leverage the smallest model that meets the requirements (snowflake-arctic-small). While all options function, using 'snowflake-arctic-small' minimizes compute costs. The instruction 'Summarize the following review in no more than 50 words:'…
Question
A data engineer is tasked with using Snowflake Cortex's COMPLETE function to generate concise summaries of customer reviews stored in a table named `CUSTOMER REVIEWS. The 'CUSTOMER REVIEWS' table contains a column named 'REVIEW TEXT' with the raw review text. They want to optimize for cost and performance. Which of the following SQL snippets represents the MOST efficient and cost-effective way to achieve this, assuming the summaries should ideally be no more than 50 words?
Exhibit
Options
- AOption A
- BOption B
- COption C
- DOption D
- EOption E
How the community answered
(68 responses)- A26% (18)
- B3% (2)
- C13% (9)
- D50% (34)
- E7% (5)
Explanation
The most cost-effective solution will leverage the smallest model that meets the requirements (snowflake-arctic-small). While all options function, using 'snowflake-arctic-small' minimizes compute costs. The instruction 'Summarize the following review in no more than 50 words:' is a reasonable prompt for summarization.
Topics
Community Discussion
No community discussion yet for this question.