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: CE 🗳️

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

Comments

Submit Cancel

surya610

1 month, 1 week ago

Selected Answer: CE

C and E,using :

upvoted 1 times

...

37ceea2

4 months, 4 weeks 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 3 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

5 months, 1 week 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

5 months, 2 weeks ago

Selected Answer: CD

I think C D

upvoted 1 times

...