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?

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?

Gregory Destrebecq · Accepted Answer

CREATE TABLE <table_name> AS SELECT * FROM TABLE_A;

Gregory Destrebecq · Answer

CREATE TABLE <table_name> LIKE TABLE_A;

Gregory Destrebecq · Answer

CREATE VIEW <view_name> AS SELECT * FROM TABLE_A;

Gregory Destrebecq · Answer

CREATE MATERIALIZED VIEW <view name> AS SELECT * FROM TABLE A;

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 399 - COF-C02 discussion

Suggested answer: C

0 comments