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

Question

You are working with Snowflake Cortex and the COMPLETE function to generate marketing copy from product specifications. You have a table `PRODUCT SPECS containing 'PRODUCT NAME, 'KEY FEATURES, and TARGET AUDIENCE columns. You want to generate a concise and engaging marketing tagline for each product. Given that 'SNOWFLAKE.ML.COMPLETE is implemented as a secure external function, what are the MINIMUM set of steps to grant the necessary permissions and execute the function successfully (select all that apply)?

Options

• AGrant the USAGE privilege on the SNOWFLAKE schema to the role executing the query using:
• BGrant the EXECUTE TASK privilege on the account to the role executing the query using. `GRANT
• CGrant the USAGE privilege on the database containing the SNOWFLAKE schema to the role
• DEnsure external functions are enabled at the account level: ALTER ACCOUNT SET ENABLE
• EGrant OWNERSHIP on the SNOWFLAKE.ML.COMPLETE to the role executing the query using:

Explanation

The COMPLETE function, being implemented as an external function, requires specific privileges. Granting USAGE on the schema (A) and database (C) containing the function is essential for accessing it. Also, external functions must be enabled at the account level(D). EXECUTE TASK is unrelated to external function execution. OWNERSHIP is not needed, USAGE provides sufficient access. A and C are prereqisite to use the functions and as well Snowflake ML complete being implemented as External function, the flag ENABLE EXTERNAL FUNCTIONS should be turned on, so the correct options are

No community discussion yet for this question.