Given a table `temp_data` with a column `raw` containing JSON data that records temperatures for every four hours in the day for Chicago, how would you calculate the maximum temperature ever recorded at 12:00 PM across all days? Parse the JSON data and use the necessary array function to find the max temperature._

Real Exam

select max(raw.chicago.temp[3]) from temp_data_

13.4%

select array_max(raw.chicago[*].temp[3]) from temp_data*

12.6%

select array_max(from_json(raw[‘chicago‘].temp[3],‘array‘)) from temp_data_

18.3%

select array_max(from_json(raw:chicago[*].temp[3],‘array‘)) from temp_data*_

41.0%

select max(from_json(raw:chicago[3].temp[3],‘array‘)) from temp_data

14.7%

Databricks Certified Data Engineer - Associate