SnowPro Advanced Administrator ADA-C02

By Snowflake · Question Mode

QuestionQ58

Manage and administer Snowflake accounts, data security, and governance

DatabaseA contains one schema, Schema1, which has many tables and views. The ANALYST role has privileges to select from every object in DatabaseA.Schema1. The SYSADMIN role clones DatabaseA as DatabaseA_clone.

Which privileges does the ANALYST role have on tables and views in DatabaseA_clone?

Choose two
Explanation

When a database is cloned in Snowflake, privileges granted on child objects are inherited by their clones, including the cloned schema and all tables and views it contains. Privileges granted on the database container itself are not inherited. The ANALYST role therefore has the inherited schema-level access and SELECT on all cloned tables and views.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!