...
ACID transactions – Delta employs an all or nothing approach for data consistency.
Snapshot isolation – Ensures that multiple writers can write to a transformation simultaneously without interfering with jobs that are reading the transformation.
Improve data integrity through schema enforcements.
Checkpoints to ensure data is delivered and read only once even if there are multiple incoming and outgoing streams.
Upserts and deletes support – Being able to handle late arriving and changing records and cases where records should be deleted.
Data versioning capabilities allow organizations to rollback and reprocess data as necessary.
Ensure that all the semantic model which are not eligible for querying must be set to cuboid replication type as None
Query Engines, BI Server and ADLS storage must be in same region
Ensure that there should be enough amount of local disk space available on Query Engine to replicate the built processed semantic models.
For the environments where we are not having sufficient local disk available (Local disk less than semantic model size) - create a segment, create dedicated metadata folder and allocate the prod semantic models to this segment and rest of the semantic models to the default segment.