SnowPro Advanced: Data Engineer — Question 1

A new CUSTOMER table is created by a data pipeline in a Snowflake schema where MANAGED ACCESS is enabled.
Which roles can grant access to the CUSTOMER table? (Choose three.)

Answer options

• A. The role that owns the schema
• B. The role that owns the database
• C. The role that owns the CUSTOMER table
• D. The SYSADMIN role
• E. The SECURITYADMIN role
• F. The USERADMIN role with the MANAGE GRANTS privilege

Correct answer: A, E, F

Explanation

The correct answers are A, E, and F because the role that owns the schema (A) can manage grants, the SECURITYADMIN role (E) has the ability to grant access, and the USERADMIN role with the MANAGE GRANTS privilege (F) also can grant access. The roles that own the database (B) and the CUSTOMER table (C) do not have the ability to grant access when MANAGED ACCESS is enabled, and the SYSADMIN role (D) does not inherently have this capability under the managed access settings.