Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Salesforce Certified Platform Developer II (Plat-Dev-301) Exam - Topic 1 Question 124 Discussion

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

Salesforce Certified Platform Developer II (Plat-Dev-301) Exam - Topic 1 Question 124 Discussion

Actual exam question for Salesforce's Salesforce Certified Platform Developer II (Plat-Dev-301) exam
Question #: 124
Topic #: 1
[All Salesforce Certified Platform Developer II (Plat-Dev-301) Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: A

The valid SOQL query on a Big Object must match the indexed fields exactly. Since Account__c, Program__c, and Transaction_Date__c are the indexed fields, the SOQL query must specify those fields exactly in the WHERE clause, including exact match conditions (no LIKE or INCLUDES).


by Ronnie at Jan 25, 2026, 04:35 PM

Limited Time Offer

25%

Off

Get Premium Salesforce Certified Platform Developer II (Plat-Dev-301) Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Ardella
24 days ago
I’m not sure about that, isn’t there a limit on how many fields you can query?
upvoted 0 times
...
Eladia
29 days ago
I think the query needs to include all index fields.
upvoted 0 times
...
Rickie
1 month ago
Wait, can you really handle a billion records like that?
upvoted 0 times
...
Pearly
1 month ago
Totally agree, makes sense!
upvoted 0 times
...
Merilyn
1 month ago
You can only query indexed fields in Big Objects.
upvoted 0 times
...
Amber
2 months ago
I bet the person who came up with "Customer_Transaction__b" as a name was feeling a little too creative that day.
upvoted 0 times
...
Lindsey
2 months ago
Looks like a straightforward query, as long as you use those indexed fields.
upvoted 0 times
...
Ashlee
2 months ago
Hmm, I wonder if they have a field for "Snacks Purchased" - that's the real important data here.
upvoted 0 times
...
Angella
2 months ago
Definitely need to use the indexed fields to get the best results from that massive Big Object.
upvoted 0 times
...
Albina
2 months ago
The SOQL query should include the indexed fields to ensure efficient performance.
upvoted 0 times
...
Juliana
3 months ago
I feel like there was something about the order of fields in the query that matters, but I can't recall the specifics right now.
upvoted 0 times
...
Kenny
3 months ago
I practiced a similar question where we had to filter by date, but I’m not sure if we can use multiple filters in the same query for Big Objects.
upvoted 0 times
...
Huey
3 months ago
I think we can only query on indexed fields, so we should definitely focus on Account__c, Program__c, and Transaction_Date__c for the query.
upvoted 0 times
...
Nelida
4 months ago
I remember that Big Objects have some limitations with SOQL queries, especially around the fields we can use.
upvoted 0 times
...
Lasandra
4 months ago
This looks straightforward enough. I'll just need to make sure I'm using the right index fields and syntax for the SOQL query. I think I can handle this one.
upvoted 0 times
...
Hana
4 months ago
I've got a strategy in mind. Since the index fields are specified, I'll try to use those in the WHERE clause to narrow down the results. Then I'll select the fields I need from the object. Hopefully that will give me a valid SOQL query.
upvoted 0 times
...
Raymon
4 months ago
I'm a bit confused about the "Big Object" part. Does that change how I need to approach the SOQL query? I'll need to do some research on Big Objects before I feel confident answering this.
upvoted 0 times
...
Gaynell
4 months ago
Okay, let's see. The question mentions that Account__c, Program__c, and Transaction_Date__c are the index fields. I think I'll start there and try to build a query that leverages those.
upvoted 0 times
...
Levi
5 months ago
Hmm, this seems like a tricky one. I'll need to think carefully about the index fields and how to structure the SOQL query.
upvoted 0 times
...

Save Cancel