5.42Scenario 1 — find the Account
Requirement:
Find the Salesforce Account corresponding to upstream customer C001.
SELECT
Id,
Name
FROM Account
WHERE External_Customer_ID__c = :customerId
Expected:
0 results
→ not found
1 result
→ normal
>1
→ serious data integrity problem