Exam4Training

Which set of filtering condition returns a report with the desired data?

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

Which set of filtering condition returns a report with the desired data?
A . Credit Card equals MoreCash OR Credit Card equals Vista AND Billing Cycle is not quarterly AND Expiration Date is less than 60 days
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 AND Credit Card equals Vista AND Billing Cycle equals monthly AND Expiration Date is 60 days greater than today
D . Credit Card equals MoreCash or Vista, Billing Cycle monthly, and Expiration Date equals next 60 days

Answer: B

Exit mobile version