You want to merge two Azure SQL tables so the combined table contains all rows from Product and the matching rows from ProductCategory. Which join configuration should you use?

• A. a left anti join Product to ProductCategory
• B. a left anti join ProductCategory to Product
• C. a left outer join Product to ProductCategory
• D. a left outer join ProductCategory to Product

Answer: (C)

Use a left outer join with the Product table as the left side and ProductCategory as the right side. A left outer join returns every row from the left table and the matching rows from the right table; if there is no match, the right-side columns appear as null. This exactly produces all products, plus their category information when it exists, while still showing every product even if it has no category.

If you used a left anti join, you’d get only products that have no matching category, which is the opposite of what you want. Swapping the tables and using a left outer join would return all rows from ProductCategory (the right side in that arrangement) rather than all products, which isn’t the goal.