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 SQL Database and needs to support both real-time analytical queries and historical reporting. The real-time queries require immediate data availability, while historical reports can tolerate slightly older data. Which storage mode should the data engineer choose for the semantic model to best meet these requirements?
- AImport mode
- BMixed mode
- CDirect Lake mode
- DDirectQuery mode
Show answer & explanationAnswer & explanation
Correct answer: B. Mixed mode
Mixed mode, which combines Import and DirectQuery, allows for the flexibility to have some tables in Import for performance and others in DirectQuery for real-time access, satisfying both requirements.
Why the other options are wrong
- A. Import mode caches all data, providing high performance but not real-time data availability.
- C. Direct Lake mode is optimized for OneLake data and offers excellent performance but is not directly applicable for real-time Azure SQL Database integration in this context.
- D. DirectQuery mode provides real-time data but can suffer from performance issues on complex queries, especially on large datasets.
Mixed Mode Storage
A semantic model storage mode in Microsoft Fabric that combines Import and DirectQuery modes, allowing different tables to use different storage types.
- Offers a balance between performance and real-time data access.
- Tables can be configured individually as Import or DirectQuery.
- Useful for scenarios requiring both high performance and fresh data.
Memory trick: Mix and match for the best data dance.