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

Question

A Snowflake administrator wants to use the 'TRANSLATE function from Snowflake Cortex LLM within a user-defined function (UDF). However, they encounter a 'permission denied' error. Which of the following steps are necessary to grant the UDF the required privileges to successfully call the 'TRANSLATE function? (Select all that apply)

Options

• AGrant the 'SNOWFLAKE.ML.FEATURE_ENGINEERING.TRANSLATE function usage privilege to
• BGrant the 'USAGE privilege on the database where the UDF is defined to the role that owns the
• CGrant the 'USAGE privilege on the schema where the UDF is defined to the role that owns the
• DGrant the EXECUTE MANAGED TASK' privilege to the role that owns the UDF.
• EGrant the 'SNOWFLAKE.CORTEX.TRANSLATE function usage privilege to the role that owns the

Explanation

To allow a UDF to call the 'TRANSLATE' function, you need to grant usage privileges on the schema containing the UDF and the TRANSLATE function itself. You do not need to execute managed tasks or grant usage on the database. Also, TRANSLATE is part of the Snowflake Cortex namespace. Therefore the correct way to call the TRANSLATE function is to grant the usage privilege to SNOWFLAKE.CORTEX.TRANSLATE

No community discussion yet for this question.