LeetQuiz Logo
Privacy Policy•contact@leetquiz.com
© 2025 LeetQuiz All rights reserved.
Databricks Certified Data Engineer - Associate

Databricks Certified Data Engineer - Associate

Get started today

Ultimate access to all questions.


You are tasked with converting temperature readings from Celsius to Fahrenheit in an IoT dataset. Each device has 5 readings stored in an array. Complete the SQL query by selecting the appropriate function to apply the conversion to each element in the array.

Schema: deviceId INT, deviceTemp ARRAY

SELECT deviceId, __(deviceTempC, i -> (i * 9/5) + 32) as deviceTempF FROM sensors

Real Exam




Powered ByGPT-5