In a Fabric lakehouse, which join type should you use to include products with no sales when analyzing by product?

• A. INNER JOIN
• B. RIGHT JOIN
• C. FULL OUTER JOIN
• D. LEFT JOIN

Answer: (D)

This question tests how to preserve rows from the left table when joining to the right table, so products with no sales are still shown. When you join the products table (left) to the sales data (right) with a left join, every product row is kept, and only matching sales rows are brought in. If a product has no sales, the sales fields come back as NULL, which you can convert to 0 if needed. This lets you analyze by product and ensure every product appears, including those without any sales.

Using a different join would lose some products with no sales: an inner join would drop them because there’s no match; a right join would keep sales rows but may omit products without sales; a full outer join would include all products and all sales but adds unnecessary complexity. So a left join is the appropriate choice when you want to include products with no sales.