Microsoft Fabric Analytics Engineer Associate DP-600
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
You are working as a data engineer for a retail company that uses Microsoft Fabric to manage its data warehouse. The company wants to analyze customer purchase behaviors to tailor marketing strategies. You are tasked with writing a SQL query that retrieves the total purchase amount and the most recent purchase date for each customer from a dataset named 'CustomerPurchases', which includes columns for CustomerID, ProductID, PurchaseDate, and PurchaseAmount. The solution must efficiently handle large volumes of data and provide accurate results for strategic decision-making. Which of the following SQL queries best meets these requirements? (Choose one option)
Explanation:
Option A is the correct answer because it accurately groups the data by CustomerID, calculates the total purchase amount for each customer using the SUM() function, and identifies the most recent purchase date for each customer with the MAX() function. This query efficiently retrieves the required information without unnecessary sorting or filtering, making it the best choice for analyzing customer purchase behaviors in a large dataset.