Exam SnowPro Core topic 1 question 13 discussion

ABCE : Shares and Users cannot be cloned in Snowflake because they represent different types of objects and have different purposes. Shares represent shared access to data within Snowflake, and they cannot be cloned because access to data is controlled through the sharing mechanism, not through copying the share itself. Users represent individual accounts within Snowflake, and they cannot be cloned because each user account must have a unique name and must be associated with a unique set of permissions. Cloning a user would result in two users with the same name, which is not allowed in Snowflake. Instead of cloning Shares or Users, you can use the Snowflake GRANT command to manage access to data and permissions in Snowflake. The GRANT command allows you to control access to data by granting specific privileges to users, roles, or groups.

answer: ABCE Below is the list of all objects which can be CLONED** in Snowflake. Data Containment Objects Databases Schemas Tables Streams Data Configuration and Transformation Objects Stages File Formats Sequences Tasks Note: Internal named stages cannot be cloned.

ABCE is correct

ABDF is correct

Table,schemas,file formats, databases can be cloned

Complete list is as follows: ○ Databases ○ Schemas ○ Tables ○ Views (including materialized views) ○ Streams ○ Stages ○ Pipes ○ Tasks ○ File Formats ○ Sequences

D is False because Shares cannot be cloned or reshared F is also false

A,C,E ARE CORRECT ANSWER

ABCE: Users and schema cannot be clone

The following account-level objects cannot be cloned: Users Roles Grants Virtual Warehouses Resource monitors Storage integrations

Creates a copy of an existing object in the system. This command is primarily used for creating zero-copy clones of databases, schemas, and tables; however, it can also be used to quickly/easily create clones of other schema objects , such as external stages, file formats, and sequences, and database roles.

https://docs.snowflake.com/en/sql-reference/sql/create-clone

Below are the items we can clone according to chatgpt : databases schemas tables views MV Shares Roles Stored Proc User Defined Func Seq Streams So the correct answer is A,C,D,E

ACEF are correct

A B C E

ABCE is the right answer To break it down Database, Schemas and Tables can be clone(no brainer). Users cannot be cloned like the above objects. Shares cannot be clone and no where in the docs mentioned about this cloning. The only one remaining from the choice is Named File Format.

User can't be cloned like database objects. As best practice -- this is from snowflake community.