Which SOQL query is...
 
Notifications
Clear all

Which SOQL query is valid on the Customer_Transaction__b Big Object?

1 Posts
1 Users
0 Likes
53 Views
Theo
 Theo
(@baintheo)
Noble Member
Joined: 6 months ago
Posts: 367
Topic starter  

Of 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__¢ 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 EXCLUDES (‘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 INCLUDES (‘Shoppers’, ‘Womens’)
    AND
    Transaction_Date__c=2019-05-31T00:00Z

Show Answer Hide Answer

Suggested Answer: A

   
Quote
Share: