Which of the following objects can be cloned? (Choose four.)

Which of the following objects can be cloned? (Choose four.)

A. Tables

B. Named File Formats

C. Schemas

D. Shares

E. Databases

F. Users

View Answer

Answer: A.C.E.F

Explanation:

The following objects can be cloned in Snowflake:

Tables: You can create a clone of a table using the CREATE TABLE … CLONE statement. This creates a new table with the same structure and data as the source table at the time of cloning.

Schemas: You can create a clone of a schema using the CREATE SCHEMA … CLONE statement. This creates a new schema with the same structure and objects as the source schema at the time of cloning.

Databases: You can create a clone of a database using the CREATE DATABASE … CLONE statement. This creates a new database with the same structure and objects as the source database at the time of cloning.

Users: While you cannot directly clone a user, you can create a new user with the same properties, roles, and privileges as an existing user by using the CREATE USER … COPY statement.

Named File Formats (B) and Shares (D) cannot be cloned directly using a single statement in Snowflake.