SnowPro Core Certification — Question 563
A user wants to add additional privileges to the system-defined roles for their virtual warehouse.
How does Snowflake recommend they accomplish this?
Answer options
- A. Grant the additional privileges to a custom role.
- B. Grant the additional privileges to the ACCOUNTADMIN role.
- C. Grant the additional privileges to the SYSADMIN role.
- D. Grant the additional privileges to the ORGADMIN role.
Correct answer: A
Explanation
Snowflake recommends assigning additional privileges to a custom role to maintain the integrity of the system-defined roles. Granting privileges to roles like ACCOUNTADMIN, SYSADMIN, or ORGADMIN is not advisable as it may lead to privilege escalation or management complexity.