CompTIA
DA0-001 · Question #9
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
Sign in or unlock DA0-001 to reveal the answer and full explanation for question #9. The question stem and answer options stay visible for context.
Data Analysis
Question
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?
Exhibit
Options
- ADate
- BMathematical
- CLogical
- DAggregate
Unlock DA0-001 to see the answer
You've previewed enough free DA0-001 questions. Unlock DA0-001 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Logical functions#Conditional logic#Data transformation#Deriving new variables