You have a Fabric tenant containing a data warehouse.

You need to load rows into a large Type 2 slowly changing dimension (SCD) while minimizing resource usage.

Which T-SQL statement should you use?