Answer-first summary for fast verification
Answer: Create a materialized view that pre-computes and stores the specific set of data, utilizing the materialized view as the shortcut.
Option C is the correct choice because a materialized view pre-computes and stores the result set of a query in a physical table, which significantly reduces query execution time for frequent access patterns. This approach meets all the given requirements by minimizing query time, supporting frequent access, and ensuring data consistency. While options A, B, and D can also provide access to the specific data set, they do not offer the same performance benefits as a materialized view, especially in scenarios requiring quick and repeated access to the same data.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
As a Microsoft Fabric Analytics Engineer working on a project to optimize data access in a lakehouse environment, you are tasked with implementing a solution that allows users to quickly access a specific set of data without the overhead of complex queries. The solution must adhere to the following requirements: 1) Minimize query execution time, 2) Support frequent access patterns, and 3) Ensure data consistency. Considering these constraints, which of the following options would you choose to implement as the most efficient shortcut? (Choose one option.)
A
Implement a standard view that dynamically selects the specific set of data upon each access, leveraging the view as the shortcut.
B
Develop a stored procedure that encapsulates the logic to retrieve the specific set of data, using the stored procedure as the shortcut.
C
Create a materialized view that pre-computes and stores the specific set of data, utilizing the materialized view as the shortcut.
D
Design a user-defined function that returns the specific set of data when called, employing the function as the shortcut.