A table named 'customers' was created from a Kafka payload containing binary-encoded JSON values. After converting the 'key' and 'value' columns to String type, the 'value' column contains JSON data but remains as a String type. Which SQL statement correctly accesses the JSON data fields 'name', 'email', 'country', and 'age'?

Real Exam

SELECT key, value.* FROM customers*

6.1%

SELECT key, value.name, value.email, value.country, value.age FROM customers

27.1%

SELECT key, EXPLODE(value) FROM customers

15.5%

SELECT key, value:name, value:email, value:country, value:age FROM customers

45.9%

SELECT key, value:* FROM customers*

5.5%

Databricks Certified Data Engineer - Associate