how are Updates and Deletes handled in both Data Warehouses and Data Lakes?

Question

I'm trying to understand how Update and Delete functions are performed in Data Warehouses, Lakes and Lakehouses.

Databricks argues that they can perform upserts easily, which I would understand as adding CRUD capabilities.

I've read elsewhere that data lakes only get CR, and warehouses CRU.

Is this correct? how are Updates and Deletes handled in both Data Warehouses and Data Lakes?

Answer 1

Data lakes and data warehouses are both widely used for storing and accessing big data.

Azure Data Lake Storage can be used for storing files today and any modifications to these files need to be done from ETL tools/Scripts/Programming only. As per my research there should be no deletes or updates to the fact tables in a properly designed data warehouse, only inserts.