SnowPro Specialty: AI Governance & Security Practice Questions

SnowPro Specialty: AI Governance & Security (ADS-B01) exam preparation

SnowPro Specialty: AI Governance & Security practice questions in English: 180 questions with explanations. The mock exam has 80 questions and 115 minutes.

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?

  1. AI_COMPLETE and AI_CLASSIFY, the functions most analysts use
  2. AI_EMBED and AI_FILTER, the functions that need extra roles
  3. None of the functions until a database role is granted
  4. 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.

Go to the SnowPro Specialty: AI Governance & Security practice app (10 free questions; purchase unlocks all questions)

See the full practice set