Refer to the exhibit

A customer has loaded the two tables and then added the script:

What will be the result?
Suggested Answer: C
Get Premium QV12BA Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
11 comments · newest first
ER
Erick
11 months ago
The TransactionTime field is key here.
ET
Ettie
11 months ago
Wait, a synthetic table? That sounds complicated!
JU
Julio
12 months ago
Not so sure about that, D seems more accurate.
FR
Francene
12 months ago
I think C is the right answer!
LA
Latia
1 year ago
The Interval table will be joined with the Transactions table.
RO
Roslyn
1 year ago
I’m confused about the synthetic table part. Does it really create a new association, or is it just a way to visualize the connections?
HY
Hyun
1 year ago
I remember a similar question where we had to identify associations between tables. I feel like the synthetic table concept might be relevant here.
DI
Diego
1 year ago
I think the Interval table is supposed to join with the Transactions table, but I'm not entirely sure which field it uses.
MA
Marjory
1 year ago
I'm leaning towards option C, but I can't recall if the TransactionTime field is the right one for the association.
JA
Jamal
1 year ago
Hmm, I'm not sure about the Edit Block. Wouldn't a Step be better to handle the variable number of rows? And then we'd need a Formula to calculate the total for each row.
DA
Daniela
1 year ago
Remote service observation, that's got to be it. I'm pretty confident that's the right answer based on what we've covered in class. Time to move on to the next question.