Salesforce Decode
Salesforcedecode
Back to questions
ApexAdvancedencryptionshieldsecurity

Handle encryption and Shield Platform Encryption in Apex

Real World Scenario

Encrypted fields break SOQL WHERE clauses in integration queries filtering on email.

Expected Answer

• Deterministic encryption required for equality filters • Probabilistic encryption prevents SOQL filter—redesign query approach • Filter on alternate hashed token field for lookups • Encryption-aware integration patterns documented • Test with encrypted fields in scratch org with Shield • Avoid logging decrypted values in debug logs in production

Follow-Up Questions & Answers

Click to expand — each follow-up includes a direct, interview-ready answer

Stay within limits by: Deterministic encryption required for equality filters. Bulkify everything — never query or DML in loops. Filter on alternate hashed token field for lookups. Encryption changes query architecture—design token fields before enabling Shield on filter columns. Optimize for scale and operational observability.

Architect Perspective

Encryption changes query architecture—design token fields before enabling Shield on filter columns.