SOL-C01 · Question #198
A data engineer needs to translate product names stored in a 'PRODUCTS' table from English to French using Snowflake Cortex LLM. The 'PRODUCTS' table has a 'PRODUCT ID' and 'PRODUCT NAME EN' column. T
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #198. The question stem and answer options stay visible for context.
Question
A data engineer needs to translate product names stored in a 'PRODUCTS' table from English to French using Snowflake Cortex LLM. The 'PRODUCTS' table has a 'PRODUCT ID' and 'PRODUCT NAME EN' column. They want to create a view named 'PRODUCTS FR' that contains the translated product names in a new column called 'PRODUCT NAME FR. Which of the following SQL statements is the MOST efficient and correct way to create the view using the 'TRANSLATE' function, assuming the appropriate LLM endpoint is configured?
Options
- ACREATE VIEW PRODUCTS_FR AS SELECT PRODUCT_ID, 'en', 'fr') AS FROM PRODUCTS;
- BCREATE OR REPLACE VIEW PRODUCTS FRAS SELECT PRODUCT ID, 'en', 'fr') AS FROM
- CCREATE OR REPLACE VIEW PRODUCTS_FR AS SELECT PRODUCT_ID, NAME EN) AS
- DCREATE OR REPLACE VIEW PRODUCTS_FR AS SELECT PRODUCT_ID, PRODUCT NAME
- ECREATE OR REPLACE VIEW PRODUCTS_FR AS SELECT PRODUCT_ID,
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.