A data analyst has been asked to manipulate the data in the table below by first applying a DISTINCT function, and then applying a SUM function, to get the total product cost for a customer:
Which of the following is the final cost of the product?
If we apply DISTINCT (Product, Cost), we will keep all unique (Product, Cost) pairs instead of just distinct products. The table already has unique (Product, Cost) pairs, meaning no rows are removed.
So, when we sum all values, we get:
1500+1600+1356+890+745+2008+543=8,642
Let me help solve this step by step.
1) First, I need to apply the DISTINCT function to the data. This will remove duplicates and give us one row per unique product and cost combination:
Ground beef: $1,500
Ground beef: $1,600
Lamb chops: $1,356
Lamb chops: $890
Lamb chops: $745
Crab meat: $2,008
Cow's milk: $543
2) Then, I need to SUM all these costs:
$1,500 + $1,600 + $1,356 + $890 + $745 + $2,008 + $543 = $8,642
Therefore, the final cost of the product after applying DISTINCT and then SUM is $8,642.
The DISTINCT function kept all the unique product-cost combinations (didn't eliminate any rows since each cost was different even for the same product), and then the SUM function added all these costs together.
D is correct.
Since all the cost values are different, none of the cost values are removed by the DISTINCT functions, so we really only need to find the sum. 1500 + 1600 + 1356 + 890 + 745 + 2008 + 543 = 8642.
The DISTINCT function removes duplicate values, not different values for the same product.So Summing up all the value its is option D
upvoted 1 times
...
...
This section is not available anymore. Please use the main Exam Page.DA0-001 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
ducko
2 months, 3 weeks agoMLadis
2 months, 4 weeks agoDoaa3690
5 months agoAdonisy
6 months agoSwift_and_Quick
1 year agoNextTopic
1 year ago07fd0a0
2 months, 3 weeks ago