SnowPro Core Certification — Question 1305

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?

Answer options

• 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;

Correct answer: A

Explanation

The correct answer is A because using CREATE TABLE [table_name] LIKE TABLE_A will copy the structure and properties of TABLE_A, including any assigned tags. The other options do not inherit tags because they create new objects that reference TABLE_A without duplicating its properties.