Examsnet
Unconfined exams practice
Home
Exams
Banking Entrance Exams
CUET Exam Papers
Defence Exams
Engineering Exams
Finance Entrance Exams
GATE Exam Practice
Insurance Exams
International Exams
JEE Exams
LAW Entrance Exams
MBA Entrance Exams
MCA Entrance Exams
Medical Entrance Exams
Other Entrance Exams
Police Exams
Public Service Commission (PSC)
RRB Entrance Exams
SSC Exams
State Govt Exams
Subjectwise Practice
Teacher Exams
SET Exams(State Eligibility Test)
UPSC Entrance Exams
Aptitude
Algebra and Higher Mathematics
Arithmetic
Commercial Mathematics
Data Based Mathematics
Geometry and Mensuration
Number System and Numeracy
Problem Solving
Board Exams
Andhra
Bihar
CBSE
Gujarat
Haryana
ICSE
Jammu and Kashmir
Karnataka
Kerala
Madhya Pradesh
Maharashtra
Odisha
Tamil Nadu
Telangana
Uttar Pradesh
English
Competitive English
Certifications
Technical
Cloud Tech Certifications
Security Tech Certifications
Management
IT Infrastructure
More
About
Careers
Contact Us
Our Apps
Privacy
Test Index
Salesforce Platform Developer II Exam
Show Para
Hide Para
Share question:
© examsnet.com
Question : 30
Total: 33
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
Solution:
© examsnet.com
Go to Question:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
Prev Question
Next Question