🔥 3-day streak
Microsoft Fabric Analytics Engineer Associate144 / 150
Question 144 of 150
A Fabric Analytics Engineer manages a warehouse containing three separate tables: SalesNorth, SalesSouth, and SalesWest. Each table has an identical schema (OrderID, ProductID, Amount, OrderDate) but holds regional data. The engineer needs to build a query that returns every sales row from all three regions in a single result set, preserving duplicate orders that legitimately appear in more than one region's table due to shared distribution centers. Which T-SQL approach should the engineer use?
Reviewed for accuracy · Report an issueNext question