Ultimate access to all questions.
You are a Microsoft Fabric Analytics Engineer working with a large retail company that operates globally. The company has a vast amount of data, including daily transactional records, real-time inventory levels across multiple warehouses, and detailed customer demographics from various regions. The management requires a semantic model that supports complex analytics, real-time data access for operational reporting, and the ability to scale with the growing data volume. Considering the need for cost efficiency, compliance with data residency requirements, and minimizing data refresh cycles, which storage mode would you recommend? Choose the best option from the following:
A
In-Memory storage mode, as it offers the fastest query performance and is optimized for large datasets, making it ideal for complex analytics and reporting.
B
DirectQuery mode, as it enables real-time querying of the data source without the need for data refreshes, ensuring up-to-date information for operational reporting and compliance with data residency requirements.
C
Hybrid storage mode, as it leverages both In-Memory and DirectQuery modes to provide a balance between performance and real-time data access, suitable for scalable solutions.
D
None of the above, as the company should consider a custom solution tailored to its specific needs beyond the standard storage modes.