Question

You are building a data quality check in a Fabric warehouse. You have a staging table 'stg_Customers' that was just loaded and a production table 'dim_Customers'. You need to write a T-SQL query that returns only the rows present in 'stg_Customers' that do NOT already exist in 'dim_Customers', comparing all columns for an exact match. Which T-SQL construct should you use?

Accepted Answer

SELECT * FROM stg_Customers EXCEPT SELECT * FROM dim_Customers

Answer

SELECT * FROM stg_Customers INTERSECT SELECT * FROM dim_Customers

Answer

SELECT * FROM stg_Customers UNION SELECT * FROM dim_Customers

Answer

SELECT * FROM stg_Customers s INNER JOIN dim_Customers d ON s.CustomerKey = d.CustomerKey