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 cont
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #208. The question stem and answer options stay visible for context.
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
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.