Ultimate access to all questions.
You are working as a Fabric Analytics Engineer and are tasked with optimizing a SQL query for a large dataset in a Fabric warehouse. The dataset contains detailed customer information, including names, email addresses, and purchase history. Your goal is to identify the top 10 customers based on their total purchase amounts, including their names and email addresses, to target them for a high-value marketing campaign. The solution must be efficient, scalable, and comply with data privacy regulations. Which of the following SQL queries best meets these requirements? (Choose one option)