SnowPro Core Recertification — Question 51

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 create a new table that inherits the properties, including tags, from TABLE_A. Options B, C, and D do not inherit tags from TABLE_A; they create new objects without that inherited tagging feature.