Data 360 Consultant Segmentation And Insights Practice Question
An organization requires a Calculated Insight to compute the running total of customer purchases ordered by transaction timestamp. Which SQL analytical clause is required to compute running totals in Data Cloud?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
SUM(amount) OVER (PARTITION BY individual_id ORDER BY transaction_date)
Running totals and cumulative calculations in ANSI SQL require window functions using the OVER clause with ORDER BY timestamp partitions.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
TOTAL_ACCUMULATOR(amount)
Why it's wrong here
TOTAL_ACCUMULATOR does not exist in Data Cloud ANSI SQL.
- ✗
RUNNING_TOTAL(amount, transaction_date)
Why it's wrong here
RUNNING_TOTAL is not a standard ANSI SQL function in Data Cloud.
- ✗
CUMULATIVE_SUM() function without arguments.
Why it's wrong here
CUMULATIVE_SUM is not standard ANSI SQL.
- ✓
SUM(amount) OVER (PARTITION BY individual_id ORDER BY transaction_date)
Why this is correct
ANSI SQL window functions with PARTITION BY and ORDER BY clauses compute running totals correctly.
About these practice questions
This Data 360 Consultant question is part of Courseiva's 521-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed August 2026 · checked against the official Salesforce exam blueprint
This Data 360 Consultant practice question is part of Courseiva's free Salesforce certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the Data 360 Consultant exam.