New Year Sale 2026! 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

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
Huey
5 days 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
10 days ago
I remember that Big Objects have some limitations with SOQL queries, especially around the fields we can use.
upvoted 0 times
...
Lasandra
15 days 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
20 days 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
25 days 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
1 month 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
1 month 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