SOL-C01 practice question 12 of 30

What is the purpose of the COMPLETE function in Snowflake Cortex?

Full set: 214 questions
Answer options
A: To parse documents
B: To translate languages
C: To classify text
D: To generate text completions based on a given prompt Correct answer
Correct Answer:
D. To generate text completions based on a given prompt
Explanation

The COMPLETE function in Snowflake Cortex provides access to a large language model (LLM) for generative tasks. Its primary purpose is to generate text that logically follows or completes a given input string, known as a prompt. This enables various applications, such as summarization, question answering, and content creation, by leveraging the generative capabilities of the underlying model.

Why Incorrect

A. To parse documents: Document parsing is handled by the PARSEDOCUMENT function, which extracts text from files.
B. To translate languages: Language translation is performed by the TRANSLATE function.
C. To classify text: While COMPLETE can be prompted to perform classification, its core purpose is generation. Specific functions like SENTIMENT are for classification.

References

1. Snowflake Documentation. (n.d.). COMPLETE. Snowflake Inc. Retrieved from https://docs.snowflake.com/en/sql-reference/functions/complete. "Generates a response to a given prompt... You can use this function to perform a variety of 'prompt-and-response' tasks."

2. Snowflake Documentation. (n.d.). Snowflake Cortex LLM Functions. Snowflake Inc. Retrieved from https://docs.snowflake.com/en/user-guide/snowflake-cortex/llm-functions. The documentation describes COMPLETE as a function for "ad-hoc text generation."

Scroll to Top