MENU
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?
To fulfill the manager's request for a report showing only customers who are on a monthly billing cycle, use a MoreCash or Vista credit card, and whose credit card expires within 60 days, the filtering conditions need to precisely combine these criteria.
B . Credit Card equals MoreCash OR Credit Card equals Vista AND Billing Cycle equals monthly AND Expiration Date equals next 60 days: This set of conditions accurately captures the required filters. The use of 'OR' between the Credit Card conditions allows for the inclusion of customers with either MoreCash or Vista credit cards. The 'AND' conjunction with Billing Cycle equals monthly ensures that only those on a monthly billing cycle are included. Lastly, specifying that the Expiration Date equals the next 60 days filters for credit cards expiring within the specified timeframe. This combination of conditions ensures the report displays precisely the desired data.
Option A incorrectly uses 'AND' for credit card types, which is logically impossible since a credit card cannot be both types simultaneously. Option C inaccurately suggests using a condition on the billing cycle that is not aligned with the requirement and incorrectly frames the expiration date condition. Option D simplifies the conditions but lacks the precise logical structure provided in option B, potentially leading to confusion or incorrect implementation.