What capability do Delta Lake tables provide in Fabric lakehouse?

• A. ACID transactions and BI-friendly SQL queries
• B. Graph queries only
• C. In-memory processing only
• D. No transaction support

Answer: (A)

Delta Lake tables in Fabric lakehouse provide reliable data management by adding ACID transactions on top of the data lake. The Delta log records every change, enabling atomic writes, consistent reads, and safe concurrent access, so you can insert, update, delete, or upsert data without corrupting results. This also supports schema enforcement and evolution, time travel to reproduce or roll back data states, and efficient MERGE operations for large-scale updates. All of this makes SQL queries behave predictably for BI tools, delivering BI-friendly SQL queries that work well with dashboards and reporting. The other options don’t fit because Delta Lake isn’t limited to graph queries or in-memory processing, and it does provide transaction support.