Answer-first summary for fast verification
Answer: 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.
Given the company's requirements for real-time data access, compliance with data residency, and the need to minimize data refresh cycles, DirectQuery mode is the most suitable. It allows for querying the data source directly, ensuring that reports reflect the most current data without the latency associated with data refreshes. While In-Memory mode offers fast query performance, it may not be practical for the company's scale and real-time needs. Hybrid mode is not a standard option for storage mode selection, and a custom solution (Option D) would introduce unnecessary complexity and cost.
Author: LeetQuiz Editorial Team
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.
No comments yet.