How would you describe a lakehouse table stored on OneLake enabling BI-friendly SQL with ACID transactions?

• A. A NoSQL key-value store
• B. A relational database managed separately
• C. A CSV file
• D. A Delta Lake table on OneLake enabling BI-friendly SQL queries with ACID transactions

Answer: (D)

Using a Delta Lake table on OneLake gives you a lakehouse that supports BI-friendly SQL with ACID transactions. Delta Lake adds ACID guarantees, scalable metadata management, and data versioning on top of cloud storage, so you can perform reliable, concurrent reads and writes and run SQL-based queries for business intelligence without worrying about partial writes. On OneLake, this means you query the data with familiar SQL tools while preserving transactional integrity, combining the openness of a data lake with the reliability and queryability you expect from a database. The other options don’t fit because a NoSQL key-value store typically lacks full SQL access and strong ACID behavior at scale; a plain CSV file has no transactional guarantees or optimized BI querying; and a relational database managed separately isn’t leveraging the lake storage pattern and the Delta Lake capabilities.