nerdexam
Snowflake

ARA-C01 · Question #135

When a database gets cloned, what accesses are replicated?

The correct answer is A. All objects in the database and their child objects(schemas, tables etC.. When a database is cloned in Snowflake, granted privileges on the database object and all its child objects such as schemas and tables are replicated to the clone.

Accounts and Security

Question

When a database gets cloned, what accesses are replicated?

Options

  • AAll objects in the database and their child objects(schemas, tables etC.
  • BOnly the data base object access
  • COnly the child object access
  • DNo access gets replicated

How the community answered

(31 responses)
  • A
    94% (29)
  • B
    3% (1)
  • D
    3% (1)

Why each option

When a database is cloned in Snowflake, granted privileges on the database object and all its child objects such as schemas and tables are replicated to the clone.

AAll objects in the database and their child objects(schemas, tables etC.Correct

Snowflake's cloning operation replicates not only the data but also all granted privileges on the source database and every child object it contains - including schemas, tables, views, and other securable objects - preserving the full access control structure in the cloned database.

BOnly the data base object access

Cloning does not limit access replication to only the top-level database object; privileges on all child objects are also carried over to the clone.

COnly the child object access

Cloning does not replicate only child object access; privileges on the parent database object itself are also included in the replication.

DNo access gets replicated

Snowflake explicitly replicates granted privileges during a clone operation; the clone inherits all access control metadata from the source objects.

Concept tested: Snowflake database cloning and privilege replication behavior

Source: https://docs.snowflake.com/en/user-guide/object-clone

Topics

#Database Cloning#Access Privileges#Object Permissions

Community Discussion

No community discussion yet for this question.

Full ARA-C01 Practice