SAA Integration Architecture 2 — Questions and Answers
Question 1: A company needs to sync large volumes of Salesforce records nightly to an external data warehouse. Which integration pattern is most appropriate?
- Request-Reply
- Batch Data Synchronization (Correct answer)
- Event-Driven Messaging
- Remote Call-In
Correct answer: Batch Data Synchronization
Batch Data Synchronization is designed for moving large volumes of data on a scheduled basis, making it ideal for nightly data warehouse syncs.
Question 2: Which Salesforce feature allows external systems to subscribe to Salesforce record changes in near real-time using a push mechanism?
- Outbound Messages
- Change Data Capture (Correct answer)
- Apex Callouts
- Platform Cache
Correct answer: Change Data Capture
Change Data Capture publishes change events to the event bus whenever Salesforce records are created, updated, deleted, or undeleted, enabling external systems to subscribe via CometD.
Question 3: A client wants to expose Salesforce data as an OData feed for consumption by Microsoft Power BI. Which Salesforce capability should an architect recommend?
- Salesforce Connect with OData 4.0 adapter (Correct answer)
- Salesforce Bulk API 2.0
- External Services
- Canvas Apps
Correct answer: Salesforce Connect with OData 4.0 adapter
Salesforce Connect with an OData adapter allows Salesforce to act as an OData producer, exposing external objects or Salesforce data as OData-compliant feeds.
Question 4: When designing a real-time integration where an external system must query Salesforce and receive an immediate response, which API is most appropriate?
- Bulk API 2.0
- Streaming API
- REST API (Correct answer)
- Metadata API
Correct answer: REST API
The REST API supports synchronous request-reply interactions, allowing external systems to query Salesforce records and receive immediate JSON or XML responses.
Question 5: An architect is evaluating middleware options for a complex integration involving multiple systems. Which capability is most critical for an Enterprise Service Bus (ESB) in this scenario?
- Native Salesforce data storage
- Message transformation and routing (Correct answer)
- Salesforce user authentication
- Apex code execution
Correct answer: Message transformation and routing
An ESB's core value is its ability to transform message formats and route them between heterogeneous systems, decoupling producers from consumers.
Question 6: Which Salesforce governor limit is most critical to consider when designing integrations that use Apex callouts triggered by record saves?
- Maximum SOQL queries per transaction
- Maximum callouts per transaction (100) (Correct answer)
- Maximum heap size per transaction
- Maximum CPU time per transaction
Correct answer: Maximum callouts per transaction (100)
Salesforce limits Apex transactions to 100 callouts, so bulk trigger scenarios must be carefully architected to avoid hitting this limit when calling external services.
Question 7: A company wants to store a subset of external ERP records directly in Salesforce without data migration, keeping data live in the ERP. What is the recommended approach?
- Periodic ETL batch loads
- Salesforce Connect with External Objects (Correct answer)
- Heroku Connect
- Cross-Org Adapter
Correct answer: Salesforce Connect with External Objects
Salesforce Connect with External Objects provides real-time, on-demand access to data stored in external systems without replicating it into Salesforce storage.
SAA Integration Architecture 2
A company needs to sync large volumes of Salesforce records nightly to an external data warehouse.
Which integration pattern is most appropriate?