snowflake · SnowPro-Advanced-Data-Engineer · Q604 · multiple_response · topic_1

A new CUSTOMER table is created by a data pipeline in a Snowflake schema where MANAGED ACCESS is enabled. Which roles c…

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.)

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

Explanation

Wrong solution, should be A-E-F: In managed access schemas (i.e. schemas created using the CREATE SCHEMA … WITH MANAGED ACCESS syntax), object owners lose the ability to make grant decisions. Only the schema owner (i.e. the role with the OWNERSHIP privilege on the schema) or a role with the global MANAGE GRANTS privilege can grant privileges on objects in the schema.

Reference: examtopics_top_comment

Practice with progress tracking

Start tracked practice Pricing