A data architect is designing a Power BI report for a global manufacturing company. The report needs to display real-time production line status from an IoT hub, which streams data continuously. Historical production data (last 5 years) is stored in an Azure Data Lake Gen2 and is used for trend analysis. The report must offer both immediate status updates and historical insights. Which combination of data connectivity modes would be most appropriate for these two data sources?
- ABoth in DirectQuery mode.
- BIoT Hub data in Import mode, Data Lake data in DirectQuery.
- CIoT Hub data in DirectQuery, Data Lake data in Import mode.
- DBoth in Import mode with frequent refresh.
Show answer & explanationAnswer & explanation
Correct answer: C. IoT Hub data in DirectQuery, Data Lake data in Import mode.
Real-time data from an IoT hub ('streams data continuously', 'immediate status updates') requires DirectQuery to ensure the latest information. Historical data from an Azure Data Lake Gen2, used for trend analysis, benefits from Import mode for better performance on large datasets and complex aggregations, as it doesn't require real-time freshness.
Why the other options are wrong
- A. DirectQuery for historical Data Lake data would likely be slow and inefficient for trend analysis on 5 years of data, impacting report performance.
- B. Import mode for real-time IoT data fails the 'immediate status updates' requirement. DirectQuery for historical data is inefficient.
- D. Import mode for real-time IoT data would not provide immediate updates. Frequent refreshes would be resource-intensive and still not real-time.
Mixed Storage Mode Strategy
A Mixed Storage Mode strategy in Power BI involves using different data connectivity modes (e.g., DirectQuery, Import) for different tables or parts of a data model, optimizing for diverse requirements such as real-time freshness for operational data and performance for historical analytical data.
- Combines DirectQuery and Import modes.
- Balances real-time needs with query performance.
- Tailors connectivity to specific data source characteristics and reporting needs.
Memory trick: Fresh for fast, Stored for deep, both make the insights leap.