UiADPv1 Exam - Question 55

Question

Considering that the attached table is stored in a variable called "dt":Which LINQ query can be used to return the maximum total Quantity?

Examice · Accepted Answer

To determine the maximum total Quantity, it's important to consider the total quantity of each item, not just the maximum value in the Quantity column. Option C performs a GroupBy operation on the 'Item' column and then calculates the sum of quantities for each item. It then finds the maximum sum among these grouped sums, which represents the maximum total quantity of any single item type in the table. This approach correctly addresses the requirement of finding the maximum total Quantity, considering all instances of each item.

Brandon00777 · Answer

The answer is A. I tested it in studio, it returned the value of 80. Which is the largest value in the "Quantity" column

Brandon00777 · Answer

Correction: C seems to be correct, since the groupby function literally groups interrelated data and the sum function is self-explanatory.

Choudayya · Answer

Both options A and C are giving 80 as output. I tested in studio.

milindkumar · Answer

A is correct as tested in studio.

milindkumar · Answer

Both options A and C are giving 80 as output. I tested in studio.

kingkayy · Answer

The question is quite tricky. 
We are going to get 80 for both option A and C but here is why C is right.
 The question is asking for the maximum of the total quantities. 
In this case, option A just gives as the maximum individual quantity in the quantity column which is Kiwi giving 80. 
In the case of option C, which answers the question, it groups each of the quantity of items(apple, orange, mango, kiwi, pear). 
It goes ahead to sum them (apple - 10+5+12=27, orange-20, mango-5+15=20,kiwi=80,pear=1). 
It finds the maximum of the sums (27, 20, 20, 80, 1). In this case, 80 is the maximum of the total quantities.

BenAndBen · Answer

Answer is A.

UiADPv1 Exam - Question 55

Discussion