Exam Certified Data Engineer Associate topic 1 question 68 discussion

C is correct

c is correct when performing left join the sales values are only taken.

C is correct

C is correct answer

The LEFT JOIN keyword returns all records from the left table (table1), and the matching records from the right table (table2). The result is 0 records from the right side, if there is no match.

C is the correct answer

The answer is C. this is a Left Join. In this case you show everything on the left side regardless of whether they appear on the right. When it does not appear on the right you represent that with a Null. So, for a3, store id is null.

C is the correct answer. In a LEFT JOIN, all the records from the left table are included, and only the matching records from the right table are added. In this case, "a1" and "a4" from the left table (favorite_stores) match with "a1" and "a4" from the right table (sales). So, these matching records are fetched. Additionally, all the records from the left table, including "a3," are included. Since "a3" has no corresponding store_id in the right table, the store_id for "a3" will be NULL. Therefore, after the LEFT JOIN, the result will include "a1," "a3" (with a NULL store_id), and "a4."

C is correct. please refer to this simple blog if any confusion regarding JOINS https://sql.sh/cours/jointures

c is corret

Ans C: Left join only keeps left recs and only the matching recs from Right table. in other words : the left table is preserved as is.

A typical LEFT JOIN scenario

The LEFT JOIN keyword returns all records from the left table, even if there are no matches in the right table.