Ultimate access to all questions.
As a Microsoft Fabric Analytics Engineer Associate, you are tasked with implementing a function in a lakehouse to calculate the moving average of a time series dataset containing daily stock prices for a company. The solution must be flexible to accommodate various user requirements, including the ability to specify the type of moving average (simple or exponential) and its parameters (window size or decay factor). Additionally, the solution should be scalable to handle large datasets efficiently and comply with data governance policies. Which of the following approaches BEST meets these requirements? (Choose one option)