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.


A data engineer needs to analyze customer preferences and store sales by combining information from two distinct tables. The first table, named favorite_stores, captures the relationship between customers and their preferred stores. The second table, named sales, records the sales amounts associated with each store. Below are the tables used in this task:

Table 1: favorite_stores

store_idcustomer_id
a1c1
a3c2
a4c3

Table 2: sales

store_idsale_amount
a1200
a2150
a4300

The data engineer executes the following SQL query to perform a left join between these tables:

SELECT favorite_stores.store_id, sales.sale_amount FROM favorite_stores LEFT JOIN sales ON favorite_stores.store_id = sales.store_id;

What will be the result set returned by this SQL query?

Exam-Like



Powered ByGPT-5