Snowflake Certification Practice Test

Disable ads (and more) with a membership for a one time $2.99 payment

Prepare for the Snowflake Certification Exam. Use flashcards and multiple choice questions with hints and explanations to excel. Ensure you're exam-ready today!

Each practice test/flash card set has 50 randomly selected questions from a bank of over 500. You'll get a new set of questions each time!

Practice this question and more.

When cloning a database, what is transferred along with the original object?

Any privileges granted on the source object
The data in the source object
A copy of all dependent objects
No privileges are transferred to the cloned object

The correct answer is: No privileges are transferred to the cloned object

When cloning a database in Snowflake, it is essential to understand how privileges operate during this process. When a database is cloned, the new clone does not inherit any privileges that were granted on the original source object. Instead, the permissions on the cloned object must be explicitly granted again if needed. This design allows for better security and management of access, ensuring that the new database clone starts as a clean slate in terms of privileges. Users with access to the original database do not automatically gain access to the clone, preserving control over who can interact with the new object. Thus, this response accurately reflects the behavior of the cloning process in Snowflake.