snowpro-core question 921 discussion

Question 921

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?

• B. select src.dealership from car_sales;
• C. select src:Dealership from car_sales;
• D. select dealership from car_sales;