You have an Azure subscription that contains an Azure Synapse Analytics serverless SQL pool named Pool1. You plan to deploy a data lake that will record the history of transactions executed against…

JSON files do not inherently support ACID transactions, making them unsuitable for ensuring transactional integrity for data lake history.

Avro files are a row-based binary format but do not natively provide transactional capabilities required for atomically writing transaction history.

Delta Lake format provides ACID (Atomicity, Consistency, Isolation, Durability) properties, enabling transactional operations on data lake storage. This ensures that data writes, including transaction history, are atomic and consistent, critical for maintaining data integrity in the scope of a transaction.

Parquet files are a columnar storage format optimized for analytical queries but lack built-in ACID transaction support, which is necessary for the specified requirement.