Snowflake Exam SnowPro-Core Topic 1 Question 85 Discussion

Actual exam question for Snowflake's SnowPro Core Exam exam

Question #: 85
Topic #: 1

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?

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;

Show Suggested Answer

Suggested Answer: C

by Gianna at Apr 22, 2024, 06:21 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

6 days ago

That's correct. It will automatically assign the tag to the target object.

upvoted 0 times

...

7 days ago

C) CREATE TABLE AS SELECT * FROM TABLE_A;

upvoted 0 times

...

8 days ago

Which CREATE object statement will automatically assign the TABLE_A tag to a target object?

upvoted 0 times

...