Which SOQL query is valid on the Customer_Transaction__b Big Object?

Universal Containers uses Big Objects to store almost a billion customer transactions called

Customer_Transaction__b.

These are the fields on Customer_Transaction__b:

Account__c

Program__c

Points_Earned__c

Location__c

Transaction_Date__c

The following fields have been identified as Index Fields for the Customer_Transaction__b object: Account__c, Program__c, and Transaction_Date__c.

Which SOQL query is valid on the Customer_Transaction__b Big Object?
A . SELECT Account__c, Program__c, Transaction_Date__c FROM Customer_Transaction__b
WHERE Account__c = ‘001R000000302D3′
AND Program__c =’Shoppers’
AND Transaction_Date__c=2019-05-31T00:00Z
B . SELECT Account__c, Program__c, Transaction_Date__c
FROM Customer_Transaction__b WHERE Account__c = ‘001R000000302D3’
AND Program__c LIKE ‘Shop%’
AND Transaction_Date__c=2019-05-31T00:00Z
C . SELECT Account__c, Program__c, Transaction_Date__c FROM Customer_Transaction__b
WHERE Account__c = ‘001R000000302D3’
AND Program__c INCLUDES (‘Shoppers’, ‘Womens’)
AND Transaction_Date__c=2019-05-31T00:00Z
D . SELECT Account__c, Program__c, Transaction_Date__c FROM Customer_Transaction__b
WHERE Account__c = ‘001R000000302D3’
AND Program__c EXCLUDES (‘Shoppers’, ‘Womens’)
AND Transaction_Date__c=2019-05-31T00:00Z

View Answer

Answer: A