SOL-C01 Question #200: Real Exam Question with Answer & Explanation

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

Explanation

Option C is the best approach. Snowflake Cortex LLM provides a 'DETECT_LANGUAGE function that can automatically identify the language of the text. This allows you to handle cases where the UNGUAGE CODE is missing or inaccurate. Option A may not work as expected if automatic language detection is not reliable or supported directly within the TRANSLATE function. Option B introduces complexity and potential inaccuracies with default language codes. Option D avoids the problem but sacrifices valuable data.

No community discussion yet for this question.