Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Go to Exam

Question 1004

A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database.

Which CREATE object statement will automatically assign the TABLE_A tag to a target object?

CREATE TABLE LIKE TABLE_A;

CREATE VIEW AS SELECT * FROM TABLE_A;

CREATE TABLE AS SELECT * FROM TABLE_A;

CREATE MATERIALIZED VIEW AS SELECT * FROM TABLE_A;

Correct Answer: A

The CREATE TABLE LIKE statement is used to create a new table based on the definition of an existing table (in this case, TABLE_A), and it automatically assigns tags from the source table to the target table. This ensures that any tags assigned to TABLE_A will also be assigned to the new table created using this statement.

Discussion

tidzOption: A

it's correct

Lematthew31Option: A

It's A --> "With CREATE TABLE … LIKE, tags assigned to the source table are assigned to the target table" https://docs.snowflake.com/en/user-guide/object-tagging#create-table-statements

KarthyJayOption: A

https://docs.snowflake.com/en/user-guide/object-tagging With CREATE TABLE … LIKE, tags assigned to the source table are assigned to the target table.