Exam GES-C01 Topic 1 Question 67 Discussion

Actual exam question for Snowflake's GES-C01 exam
Question #: 67
Topic #: 1

A data engineering team is designing a pipeline in Snowflake to translate a continuous stream of multi-language customer support tickets into English using 'SNOWFLAKE.CORTEX.TRANSLATE. They are concerned about potential language identification issues and the overall cost implications. Which of the following statements are true regarding the use of 'SNOWFLAKE.CORTEX.TRANSLATE for this scenario? (Select all that apply)

A. If the source language of a ticket is unknown or contains mixed languages (e.g., 'Spanglish'), the function can still process it by specifying an empty string ') for the source _ language argument. B. The 'TRANSLATE' function is exclusively billed based on the number of input tokens, as it primarily analyzes existing text rather than generating new content. C. For cost efficiency, Snowflake recommends using a larger warehouse (e.g., XL or 2XL) for executing queries that call 'TRANSLATE functions, as this significantly reduces the per-token processing cost. D. Snowflake Cortex functions, including 'TRANSLATE, add an internal prompt to the user's input text, which increases the total input token count for billing purposes beyond the raw text length. E. The fixed billing rate for the 'TRANSLATE function is 1.50 Credits per one million Tokens processed.

Suggested Answer: A,D,E Vote an answer

Option A is correct because 'SNOWFLAKE.CORTEX.TRANSLATE can handle mixed-language input or unknown source languages by specifying an empty string for the 'source_language' argument. Option B is incorrect; for functions that generate new text, such as TRANSLATE , both input and output tokens are billable. Option C is incorrect; Snowflake recommends executing queries that call Cortex AISQL functions with a smaller warehouse (no larger than MEDIUM), as larger warehouses do not increase performance. Option D is correct, as TRANSLATE (among other Cortex functions) adds an internal prompt to the input text, resulting in a higher billed input token count than the raw text provided. Option E is correct, as the cost for the ' Translate' function is 1.50 Credits per one million Tokens processed.

by Vivien at Oct 28, 2025, 09:40 AM

Limited Time Offer

15%

Off

Get Premium GES-C01 Questions as Interactive Self Test Engine or PDF

Comments

0 Satisfied Customers

0 Shares

0 Demo Downloads

10 Years in Business