Microsoft Certified: Fabric Analytics Engineer AssociateImplement and manage semantic models (30-35%)Easy
A data engineer is designing a semantic model in Microsoft Fabric. The model will consume data from a large Azure Data Lake Storage Gen2 account, specifically from Delta Lake tables. Users need to interact with the data with very low latency, and the solution should minimize data movement and duplication. Which storage mode is specifically optimized for this scenario?
- ADual storage mode
- BDirectQuery mode
- CImport mode
- DDirect Lake mode
Show answer & explanationAnswer & explanation
Correct answer: D. Direct Lake mode
Direct Lake mode is a groundbreaking capability in Microsoft Fabric that allows semantic models to directly query data in Delta Lake format from OneLake (which sits on ADLS Gen2), without importing or duplicating data, offering both high performance and real-time access.
Why the other options are wrong
- A. Dual storage mode combines Import and DirectQuery, but Direct Lake is a more specialized and optimized solution for Delta Lake sources in Fabric.
- B. DirectQuery mode would query the Delta Lake table directly but typically with higher latency and less optimization than Direct Lake mode for this specific source.
- C. Import mode would copy the entire Delta Lake table into the semantic model, duplicating data and not providing real-time access.
Direct Lake Mode
Direct Lake mode is a semantic model storage mode in Microsoft Fabric that enables direct querying of Delta Lake tables in OneLake, offering high performance and real-time insights without data duplication or explicit import.
- Queries Delta Lake tables directly in OneLake.
- Combines benefits of Import (speed) and DirectQuery (real-time).
- No data movement between OneLake and semantic model.
- Exclusive to Microsoft Fabric.
Memory trick: Data Lake Direct: No Copy, Just Query!