Snowflake
COF-R02 · Question #239
The following JSON is stored in a VARIANT column called src of the CAR_SALES table: A user needs to extract the dealership information from the JSON. How can this be accomplished?
The correct answer is A. select src:dealership from car_sales. See the full explanation below for the reasoning.
Question
The following JSON is stored in a VARIANT column called src of the CAR_SALES table:
A user needs to extract the dealership information from the JSON. How can this be accomplished?
Exhibit
Options
- Aselect src:dealership from car_sales;
- Bselect src.dealership from car_sales;
- Cselect src:Dealership from car_sales;
- Dselect dealership from car_sales;
How the community answered
(49 responses)- A73% (36)
- B14% (7)
- C4% (2)
- D8% (4)
Community Discussion
No community discussion yet for this question.