COF-C02 Question #369: Real Exam Question with Answer & Explanation

Question

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?

Options

• ACREATE TABLE <table_name> LIKE TABLE_A;
• BCREATE VIEW <view_name> AS SELECT * FROM TABLE_A;
• CCREATE TABLE <table_name> AS SELECT * FROM TABLE_A;
• DCREATE MATERIALIZED VIEW <view name> AS SELECT * FROM TABLE A;