As a data engineer, you're tasked with querying data from an e-commerce website's events table, which includes a geo field of struct type containing a country subfield. How would you correctly query the data based on the country subfield?

Real Exam

SELECT geo:country FROM events WHERE geo:country = ‘India‘

9.7%

SELECT geo.country FROM events WHERE geo.country = ‘India‘

36.9%

SELECT country FROM events WHERE country = ‘India‘

3.7%

SELECT geo.country FROM events WHERE geo.country = ‘India‘

43.8%

SELECT struct.country FROM events WHERE struct.country = ‘India‘

6.0%

SELECT geocountry FROM events WHERE geocountry = ‘India‘

Databricks Certified Data Engineer - Associate