Exam SnowPro Core topic 1 question 1238 discussion

Actual exam question from Snowflake's SnowPro Core

Question #: 1238
Topic #: 1

A table named car_sales contains a single VARIANT column named src.

Below is the output of the query SELECT * FROM car_sales;

Which queries will return the element "phone number" from the data? (Choose two.)

A. SELECT src:customer.’phone number’ FROM car_sales;
B. SELECT SRC:customer."phone number" FROM car_sales;
C. SELECT src:customer."phone number" FROM car_sales;
D. SELECT SRC:customer.phone number FROM car_sales;
E. SELECT SRC:CUSTOMER."phone number" FROM car_sales;

Show Suggested Answer

Suggested Answer: BC 🗳️

by 37ceea2 at Jan. 31, 2025, 12:58 p.m.

Comments

Submit Cancel

Billhardy

2 months, 1 week ago

Selected Answer: BC

When you’re navigating a VARIANT column’s JSON, any key that contains special characters (like a space) must be wrapped in double quotes, and JSON field names are case‑sensitive SELECT SRC:customer."phone number" FROM car_sales; SELECT src:customer."phone number" FROM car_sales;

upvoted 2 times

...

37ceea2

5 months ago

Selected Answer: BC

Customer is first element. It is mandatory to be case sensitive.

upvoted 4 times

...