5.49Questions they may ask
Q: Is SOQL just SQL?
“It's SQL-like, but designed specifically around Salesforce objects and relationships. Rather than arbitrary SQL joins, you usually traverse defined Salesforce parent/child relationships.”
Excellent.
Q: What's Account.Name in a Contact query?
“That's child-to-parent relationship traversal: I'm querying Contact but retrieving a field from its parent Account.”
Q: How do I query Account with all its Contacts?
“Use a parent-to-child relationship subquery, such as
SELECT Id, Name, (SELECT Id, Email FROM Contacts) FROM Account.”
Q: What's __c?
“A custom Salesforce field or object API name typically ends in
__c.”
Q: What's __r?
“It's commonly used when traversing a custom relationship rather than directly accessing the custom lookup field.”
Q: What's SOQL vs SOSL?
“SOQL is structured querying when I know the objects and fields; SOSL is more appropriate for text-search scenarios across potentially multiple objects.”
Q: Would you issue a Salesforce query inside a Mule For Each for 1,000 input records?
“I'd try hard not to. That's an N+1 API pattern. I'd generally collect identifiers and query Salesforce in batches using
INor another appropriate bulk strategy.”
That answer sounds experienced.