SnowPro Specialty: AI Governance & Security free question 3 / 10 · Domain 2: AI Access Control and Identity
A role holds the USE AI FUNCTIONS account privilege. It holds neither the CORTEX_USER nor the AI_FUNCTIONS_USER database role. Which Cortex AI functions can users of this role call?
- AI_COMPLETE and AI_CLASSIFY, the functions most analysts use
- AI_EMBED and AI_FILTER, the functions that need extra roles
- None of the functions until a database role is granted
- The aggregate functions AI_AGG and AI_SUMMARIZE_AGG
Show the answer and explanation
Answer: D
Why this is correct
Under "USE AI FUNCTIONS on the account privilege", the page says users normally need both the account-level privilege (or a per-function privilege) and one of the CORTEX_USER or AI_FUNCTIONS_USER database roles. It then makes one exception: if a user has the account privilege but lacks the CORTEX_USER role, they can still use the AI_AGG and AI_SUMMARIZE_AGG functions. A role with only the account privilege therefore reaches those two aggregates and nothing else.
Why the other options are wrong
"AI_COMPLETE and AI_CLASSIFY, the functions most analysts use" … The page says users need the account privilege and one of the two database roles to use the functions. Scalar functions such as AI_COMPLETE are not an exception.
"AI_EMBED and AI_FILTER, the functions that need extra roles" … The embedding functions have their own database role. The page gives no exception for AI_EMBED or AI_FILTER when the database roles are missing.
"None of the functions until a database role is granted" … The page names an exception. A user with the account privilege but without CORTEX_USER can still use the two aggregate functions.
Know the exception when reading a role design
If a user has the account privilege but lacks the CORTEX_USER role, they can still use the AI_AGG and AI_SUMMARIZE_AGG functions.