Microsoft Certified: Fabric Analytics Engineer AssociateImplement and manage semantic models (30-35%)Medium
A data engineer is configuring a semantic model in Microsoft Fabric. The model sources data from an Azure Data Lake Storage Gen2 account, specifically from Delta Lake tables. The requirement is to provide the fastest possible query performance for reports, without having to load the entire dataset into memory or frequently refresh the data. The data in the Delta Lake tables is updated continuously. Which storage mode is specifically designed for this scenario in Microsoft Fabric?
- AImport mode
- BDirect Lake mode
- CDual mode
- DDirectQuery mode
Show answer & explanationAnswer & explanation
Correct answer: B. Direct Lake mode
Direct Lake mode is Microsoft Fabric's groundbreaking capability to directly query Delta Lake tables in OneLake. It bypasses the need to import data or use DirectQuery, providing the best of both worlds: performance similar to Import mode and real-time data access similar to DirectQuery, specifically for Delta Lake sources.
Why the other options are wrong
- A. Import mode would require loading the entire dataset into memory, which contradicts the 'without having to load the entire dataset into memory' requirement and would require refreshes.
- C. Dual mode combines Import and DirectQuery, but Direct Lake is a more specialized and optimized solution for Delta Lake sources.
- D. DirectQuery mode would query the Delta Lake tables directly but might not offer the 'fastest possible query performance' compared to Direct Lake, which is optimized for Delta Lake.
Direct Lake Mode
Direct Lake mode in Microsoft Fabric semantic models allows direct querying of Delta Lake tables in OneLake without importing or duplicating data. It combines the performance benefits of Import mode with the real-time capabilities of DirectQuery for Delta Lake sources.
- Queries Delta Lake tables directly from OneLake.
- No data movement or duplication.
- Offers Import-like performance with DirectQuery-like freshness.
- Optimized for large-scale analytics on Delta Lake.
Memory trick: For Delta Lake, go Direct to the Lake for speed and freshness.