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.


In a scenario where you are working with a Delta Lake table named 'customer_data' that contains columns 'customer_id', 'first_name', 'last_name', and 'email', you are tasked with creating a new table 'customer_email' that includes only the 'customer_id' and 'email' columns. The solution must optimize for performance and adhere to best practices for Spark SQL queries. Considering the need for efficiency and correctness, which of the following Spark SQL queries would you use to accomplish this task? (Choose one correct option)

Simulated



Powered ByGPT-5