SOL-C01 · Question #200
A data analyst is tasked with translating customer reviews from various languages into English to perform sentiment analysis. The customer reviews are stored in a table named 'CUSTOMER REVIEWS' with c
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #200. The question stem and answer options stay visible for context.
Question
A data analyst is tasked with translating customer reviews from various languages into English to perform sentiment analysis. The customer reviews are stored in a table named 'CUSTOMER REVIEWS' with columns 'REVIEW ID', 'REVIEW TEXT', and 'LANGUAGE CODE'. However, the 'LANGUAGE CODE column is sometimes missing or inaccurate. What is the BEST approach to use the Snowflake Cortex LLM's 'TRANSLATE function to handle reviews where the language is unknown?
Options
- AUse a CASE statement to check if 'LANGUAGE_CODE is null. If it is, pass the review text directly
- BCreate a separate table containing default language codes for each region and join it with the
- CUse the 'DETECT LANGUAGE function from Snowflake Cortex LLM to automatically identify the
- DExclude all reviews with a missing 'LANGUAGE CODE from the translation process to avoid
- EUse a TRY_TRANSLATE function which does not exist, which would catch exception if
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.