Answer-first summary for fast verification
Answer: CREATE TABLE [table_name] LIKE TABLE_A;
The question asks which CREATE statement automatically assigns the same tag from TABLE_A to a new target object. According to Snowflake documentation and the community discussion with supporting references, CREATE TABLE ... LIKE is the only statement that automatically copies tags from the source table to the target table. Option A (CREATE TABLE [table_name] LIKE TABLE_A) is correct because it explicitly preserves tags. Option B creates a view, which doesn't inherit table tags. Option C (CREATE TABLE ... AS SELECT) creates a new table but doesn't copy tags. Option D creates a materialized view, which also doesn't inherit tags from the source table. The community discussion shows 100% consensus on A with references to Snowflake documentation confirming that CREATE TABLE ... LIKE transfers tags.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A tag object is assigned to a table named TABLE_A in a schema within a Snowflake database.
Which CREATE object statement will automatically apply the same tag assignment from TABLE_A to a new target object?
A
CREATE TABLE [table_name] LIKE TABLE_A;
B
CREATE VIEW [view_name] AS SELECT * FROM TABLE_A;
C
CREATE TABLE [table_name] AS SELECT * FROM TABLE_A;
D
CREATE MATERIALIZED VIEW [view_name] AS SELECT * FROM TABLE_A;