SOL-C01 practice question 11 of 30
When using the TRANSLATE function, what type of input is expected for the source and target languages?
Full set: 214 questionsThe Snowflake Cortex TRANSLATE function requires the source and target languages to be specified using their two-letter ISO 639-1 language codes. For example, 'en' is used for English, 'fr' for French, and 'de' for German. Using these standardized codes ensures unambiguous interpretation by the function and aligns with common practices in language processing services.
A. Full language names (e.g., "English", "French"): The function does not accept full language names as arguments; it requires the standardized two-letter codes.
C. File paths to language dictionaries: The function uses a pre-trained model and does not require users to provide external dictionary files.
D. Numerical language identifiers: The function's syntax is defined to use string-based ISO codes, not numerical identifiers, for specifying languages.
1. Snowflake Documentation. (n.d.). TRANSLATE. Snowflake Inc. Retrieved from https://docs.snowflake.com/en/sql-reference/functions/translatetext. "The TRANSLATE function translates text from a source language to a target language... sourcelanguage The two-letter ISO 639-1 code of the language of the input text."
Keep practicing
Take the free SOL-C01 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other SOL-C01 practice questions
- Question 1Which Snowflake object is a logical container for schemas and other database objects?
- Question 2How can Python variable substitution be performed in Snowflake notebooks?
- Question 3Which SQL command is commonly used to load structured data from a stage into a Snowflake …
- Question 4Which command can be used to query the Information Schema in Snowflake to retrieve a list…
- Question 5Which command is synonymous with the LIST command in Snowflake?
- Question 6Which of the following data format supported to unload semi-structured data from Snowflak…
