Question about report definition filter conditions

General
,
1

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.

2

@LouisY16949431

B

(CREDITCARD IS MORECASH OR CREDITCARD IS VISTA) AND BILLING CYCLE = MONTHLY AND EXPIRYDATE ≤ 60 DAYS

3

@LouisY16949431

B

F1: CREDITCARD = MORECASH

F2: CREDITCARD = VISTA

F3: BILLING CYCLE = MONTHLY

F4: EXPIRYDATE ≤ 60 DAYS

Logic: (F1 OR F2) AND F3 AND F4

4

Hi @LouisY16949431

‘B’ is the correct answer

Credit Card equals MoreCash OR Credit Card equals Vista AND Billing Cycle equals monthly AND Expiration Date equals next 60 days.

CREDITCARD = MORECASH

CREDITCARD = VISTA

BILLING CYCLE = MONTHLY

EXPIRYDATE ≤ 60 DAYS

5

@LouisY16949431

  • B. Credit Card equals MoreCash OR Credit Card equals Vista AND Billing Cycle equals monthly AND Expiration Date equals next 60 days.