🔥 3-day streak
Microsoft Fabric Analytics Engineer Associate123 / 150
Question 123 of 150
You are building a query in the Visual Query Editor of a Fabric warehouse SQL analytics endpoint. You drag a Customers table and an Orders table onto the canvas. You need to combine the two so that only customers who have placed at least one order appear, matching on CustomerID. You select the 'Merge queries' step. Which join kind should you choose to meet this requirement with the fewest additional steps?
Reviewed for accuracy · Report an issueNext question