Exam SnowPro Core topic 1 question 1278 discussion

Actual exam question from Snowflake's SnowPro Core

Question #: 1278
Topic #: 1

This statement is run:

SELECT { 'key' : { 'subkey': 'value' }} mycolumn;

What notations will retrieve the 'value' from the VARIANT column? (Choose two.)

A. mycolumn.key.subkey
B. mycolumn.key:subkey
C. mycolumn:key.subkey
D. mycolumn['key'].subkey
E. mycolumn:key:subkey

Show Suggested Answer

Suggested Answer: BE 🗳️

by MultiCloudIronMan at Jan. 10, 2025, 6:22 p.m.

Comments

Submit Cancel

37ceea2

2 weeks, 6 days ago

Selected Answer: CE

I have checked, as well, in snowflake, all C,D,E are working. For me, D was a surprise. I shall select C and E

upvoted 2 times

...

Unfortunately C,D,E will work in Snowflake: At the same time accorting to documentation Snowflake separates Dot and Bracket Notation, thst's why voting for C and E. https://docs.snowflake.com/en/user-guide/querying-semistructured#traversing-semi-structured-data

upvoted 1 times

bor4un

4 weeks, 1 day ago

select a.mycolumn:key.subkey, a.mycolumn['key'].subkey, a.mycolumn:key:subkey from ( SELECT { 'key' : { 'subkey': 'value' }} mycolumn ) a;

upvoted 1 times

...

MultiCloudIronMan

1 month, 1 week ago

Selected Answer: CD

I think C D

upvoted 1 times

...

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 1278 discussion

Comments

37ceea2

bor4un

bor4un

MultiCloudIronMan

SY0-701