You are designing a data pipeline where data from an external source needs to be loaded into a Delta Lake table without duplicating existing records. Which SQL command would you use for this purpose, and why is it effective in preventing data duplication?