Snowflake Exam SnowPro-Core Topic 1 Question 85 Discussion

Actual exam question for Snowflake's SnowPro-Core exam

Question #: 85
Topic #: 1

[All SnowPro-Core Questions]

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

When a tag object is assigned to a table, using the statementCREATE TABLE <table_name> AS SELECT * FROM TABLE_Awill automatically assign the TABLE_A tag to the newly created table2.

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

Limited Time Offer

25%

Off

Get Premium SnowPro-Core Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Deane

5 months ago

I find these topics a bit convoluted. I think more research on Snowflake documentation is needed.

upvoted 0 times

...

Keneth

5 months ago

I see your point. But I believe 'CREATE TABLE AS SELECT' would carry over the tag, as it replicates data with schema.

upvoted 0 times

...

Ty

5 months ago

I feel it's A, 'CREATE TABLE LIKE TABLE_A' should be correct because it's cloning the structure.

upvoted 0 times

...

Delmy

6 months ago

Really? I was leaning towards B, 'CREATE VIEW AS SELECT * FROM TABLE_A.'

upvoted 0 times

...

Keneth

6 months ago

Yeah, it's tricky, but I think it's C, 'CREATE TABLE AS SELECT * FROM TABLE_A.'

upvoted 0 times

...

Deane

7 months ago

Hey, any thoughts on the Snowflake exam question?

upvoted 0 times

...

Clay

7 months ago

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

upvoted 0 times

...

Willard

7 months ago

C) CREATE TABLE AS SELECT * FROM TABLE_A;

upvoted 0 times

...

Ronnie

7 months ago

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

upvoted 0 times

...