SOL-C01 · Question #208
SOL-C01 Question #208: Real Exam Question with Answer & Explanation
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:' i
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?
Options
- AOption A
- BOption B
- COption C
- DOption D
- EOption E
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.