nerdexam
Salesforce

PDII · Question #38

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…

The correct answer is A. SELECT Account__c, Program__c, Transaction_Date__c FROM Customer_Transaction__b. See the full explanation below for the reasoning.

Question

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?

Options

  • ASELECT Account__c, Program__c, Transaction_Date__c FROM Customer_Transaction__b
  • BSELECT Account__c, Program__c, Transaction_Date__c FROM Customer_Transaction__b
  • CSELECT Account__c, Program__c, Transaction_Date__c FROM Customer_Transaction__b
  • DSELECT Account__c, Program__c, Transaction_Date__c FROM Customer_Transaction__b

How the community answered

(44 responses)
  • A
    84% (37)
  • B
    2% (1)
  • C
    9% (4)
  • D
    5% (2)

Community Discussion

No community discussion yet for this question.

Full PDII Practice