
Ultimate access to all questions.
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.