Microsoft Azure Data Engineer Associate - DP-203
Get started today
Ultimate access to all questions.
You are working on a data transformation project using Azure Synapse Analytics. You have a table with customer transaction data, and you need to calculate the total revenue generated by each customer. Which of the following T-SQL queries would you use to achieve this?
You are working on a data transformation project using Azure Synapse Analytics. You have a table with customer transaction data, and you need to calculate the total revenue generated by each customer. Which of the following T-SQL queries would you use to achieve this?
Simulated
Explanation:
Option A is the correct T-SQL query to calculate the total revenue generated by each customer. By using the 'SUM' function in the SELECT statement and grouping the results by customer_id, you can aggregate the transaction amounts for each customer and calculate the total revenue. This query provides a straightforward and efficient way to analyze customer revenue contributions.