Exam SnowPro Core topic 1 question 1004 discussion

Actual exam question from Snowflake's SnowPro Core

Question #: 1004
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?

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;

Show Suggested Answer

Suggested Answer: A 🗳️

by tidz at Feb. 8, 2024, 4 p.m.

Comments

Submit Cancel

MatthieuDN

3 months, 2 weeks ago

Selected Answer: A

A is correct

upvoted 1 times

...

Lematthew31

6 months ago

Selected Answer: A

It's A --> "With CREATE TABLE … LIKE, tags assigned to the source table are assigned to the target table" https://docs.snowflake.com/en/user-guide/object-tagging#create-table-statements

upvoted 1 times

...

KarthyJay

8 months, 4 weeks ago

https://docs.snowflake.com/en/user-guide/object-tagging With CREATE TABLE … LIKE, tags assigned to the source table are assigned to the target table.

upvoted 1 times

...

tidz

9 months ago

Selected Answer: A

it's correct

upvoted 2 times

...

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 1004 discussion

Comments

MatthieuDN

Lematthew31

KarthyJay

tidz

SY0-701