Salesforce Platform Developer II Exam

Question : 30 of 33

Marks: +1, -0

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?

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
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
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
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

Validate

Go to Question:

Prev Question

Next Question