Cyber Monday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Oracle Exam 1Z0-1041-23 Topic 7 Question 14 Discussion

Actual exam question for Oracle's 1Z0-1041-23 exam
Question #: 14
Topic #: 7
[All 1Z0-1041-23 Questions]

As part of an analysis, you have the following set of data:

Assuming, you have entered the Aggregate function SUM (Revenue) in the second column.

Show Suggested Answer Hide Answer
Suggested Answer: C

Based on the image of the chart, the aggregate function SUM (Revenue) will calculate the sum of revenue for each product category. The chart shows that Product A has two rows with revenue values of 500 and 500, so the sum is 1000. Product B has two rows with revenue values of 1000 and 1000, so the sum is 2000. Reference: Oracle Analytics Cloud - Data Visualization User's Guide


Contribute your Thoughts:

Mohammad
7 months ago
I see your point, Haley. It does make sense to choose option C) based on the aggregation function.
upvoted 0 times
...
Haley
7 months ago
But if we sum the Revenue in the data set, it should be 1000 + 2000 = 3000, so I think Genevive's answer is correct.
upvoted 0 times
...
Genevive
7 months ago
I disagree, I believe the answer is C) Row 1: 1000 Row 2: 2000.
upvoted 0 times
...
Haley
7 months ago
I think the correct answer is B) Row 1: 1000 Row 2: 3000.
upvoted 0 times
...

Save Cancel
az-700  pass4success  az-104  200-301  200-201  cissp  350-401  350-201  350-501  350-601  350-801  350-901  az-720  az-305  pl-300  

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77