SP System Architecture and Design 2

Question 1

A company needs to integrate Salesforce with an external ERP system that sends high-volume transactional data. Which integration pattern best handles backpressure and prevents apex governor limit failures?

Accepted Answer

Batch Apex with Platform Events as a queue

Answer

Using Platform Events as a buffer with Batch Apex consumer decouples ingestion from processing and respects governor limits at scale.

Question 2

Which Salesforce feature allows an architect to enforce that a custom object record cannot be deleted when related child records exist, without writing Apex code?

Accepted Answer

Lookup relationship with Restrict Delete setting

Answer

A Lookup relationship configured with the 'Restrict Delete' option prevents parent deletion when children exist, declaratively.

Question 3

An org has 50 million Account records. A nightly Batch Apex job queries all Accounts modified in the last 24 hours. Which governor limit is most at risk and how should it be mitigated?

Accepted Answer

SOQL rows returned — use scope size and incremental LastModifiedDate index

Answer

SOQL row limits in large orgs are mitigated by reducing scope size and leveraging indexed fields like LastModifiedDate.

Question 4

A solution architect must expose Salesforce data to a mobile app with strict latency requirements. Which approach provides the best performance while keeping data secure?

Accepted Answer

Composite REST API with field-level query

Answer

The Composite REST API reduces round trips and allows field-level filtering, minimizing payload size and latency.

Question 5

In a multi-org Salesforce architecture, which mechanism provides the most reliable way to synchronize master data across orgs in near real-time?

Accepted Answer

Platform Events published to a shared event bus

Answer

Platform Events provide a durable, near-real-time pub/sub channel that decouples the publishing org from subscribing orgs.

SP (Certified Service Provider) Practice Test

SP (Certified Service Provider) Practice Test

SP System Architecture and Design 2