Microsoft Certified: Fabric Analytics Engineer AssociateImplement and manage semantic models (30-35%)Medium
A data architect is designing a semantic model in Microsoft Fabric. The model will consume data from a large Azure SQL Database, which is updated hourly. Users require near real-time insights for critical operational dashboards, but also need to perform complex analytical queries that could be slow against the live source. The architect wants to balance query performance for analytical queries with data freshness for operational dashboards. Which storage mode configuration would best meet these requirements?
- AImport Mode for all tables
- BDual Storage Mode for critical tables, DirectQuery Mode for others
- CDirectQuery Mode for all tables
- DDual Storage Mode for critical tables, Import Mode for others
Show answer & explanationAnswer & explanation
Correct answer: B. Dual Storage Mode for critical tables, DirectQuery Mode for others
Dual Storage Mode allows tables to behave as both Import and DirectQuery. This is ideal for critical tables needing both real-time access (DirectQuery for operational dashboards) and high performance for complex analytical queries (Import mode for cached data). Combining this with DirectQuery for other tables (which might not need the same performance or freshness for complex analytics) optimizes the overall solution.
Why the other options are wrong
- A. Import Mode provides high performance but sacrifices data freshness for near real-time needs.
- C. DirectQuery Mode ensures data freshness but can lead to slow performance for complex analytical queries.
- D. Import Mode for 'other' tables would compromise freshness, which is not ideal for the 'hourly updated' source and near real-time needs.
Dual Storage Mode
Dual Storage Mode in Microsoft Fabric semantic models allows a table to operate in both Import and DirectQuery modes simultaneously, providing the benefits of both.
- Cached for fast queries (Import).
- Queries live data for freshness (DirectQuery).
- Optimizes performance for different query types.
Memory trick: Import is Fast, Direct is Fresh, Dual is Both.