Ultimate access to all questions.
You are working on a batch processing solution that reads data from multiple sources and writes it to a Delta Lake. The data needs to be upserts, meaning that if a record with the same primary key exists, it should be updated, and if not, it should be inserted. How would you implement this functionality?