CompTIA Data+ DA0-001 – Question09

A data analyst has been asked to derive a new variable labeled "Promotion_flag" based on the total quantity sold by each salesperson. Given the table below:

Which of the following functions would the analyst consider appropriate to flag "Yes" for every salesperson who has a number above 1,000,000 in the Quantity_sold column?

A.
Date
B. Mathematical
C. Logical
D. Aggregate

Correct Answer: D