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)
Correct Answer: A,D,E
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.