Question
IT
JP
Last activity: 2 Jul 2024 2:33 EDT
Question about report definition filter conditions
Hello, I am preparing for CSA exam and stumbled across a question about report definition filters:
A report contains columns for Customer, Billing Cycle, Credit Card, and Expiration Date. A manager requests that the report show only those customers who meet the following conditions: -> The customer is on a monthly billing cycle -> The credit card is either MoreCash or Vista -> The credit card expires within 60 days Which set of filtering conditions returns a report with the desired data?
- A. Credit Card equals MoreCash AND Credit Card equals Vista AND Billing Cycle equals monthly AND Expiration Date is 60 days greater than today
- B. Credit Card equals MoreCash OR Credit Card equals Vista AND Billing Cycle equals monthly AND Expiration Date equals next 60 days.
- C. Credit Card equals MoreCash OR Credit Card equals Vista AND Billing Cycle is not quarterly AND Expiration Date is less than 60 days
- D. Credit Card equals MoreCash or Vista, Billing Cycle equals monthly, and Expiration Date equals next 60 days
Would the answer be B or D? The conditions listed are basically the same and I’m struggling to identify the difference.