MONITORING INTEGRATION-ARCHITECT Practice Questions (Page 3)

Questions 11–15

1. 11foundation · easy

   An integration syncs data from Salesforce to a data warehouse. Recently, some records are missing in the warehouse. Logs show that the integration job runs successfully, but the source query returns fewer rows than expected. Which log or metric would most directly help isolate the root cause?

   • AThe network latency between systems
   • BThe authentication logs of the integration user
   • CThe CPU usage of the data warehouse
   • DThe number of records returned by the source query
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   An integration between Salesforce and an external billing system fails intermittently. Logs show that the billing system returns HTTP 503 errors, but only when the billing system's CPU usage is above 90%. What is the most likely root cause of the integration failure?

   • AThe data payload is malformed
   • BThe network connection is down
   • CThe billing system is overloaded
   • DThe Salesforce API credentials are invalid
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A company has a real-time integration that pushes lead data from a web form to Salesforce. The integration sometimes fails because the web form sends duplicate submissions, causing duplicate leads in Salesforce. The business wants to prevent duplicates without losing any legitimate leads. What is the best approach?

   • AImplement a caching mechanism in the middleware to store recent submissions and ignore duplicates.
   • BAdd a unique identifier to the web form and use an external ID field in Salesforce to upsert records.
   • CUse a Salesforce Flow to check for existing leads before creating a new one.
   • DUse Salesforce duplicate rules to merge duplicates after they are created.
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   An integration frequently retrieves the same reference data from an external system, causing slow response times and high API usage. Which approach would most directly reduce the number of API calls and improve performance?

   • AImplement caching of the reference data
   • BAdd more retry logic
   • CSwitch to a synchronous API
   • DIncrease the API timeout
   Reveal Solution Discussion Select an answer first
6. 15application · medium

   A company has an integration that sends data from Salesforce to an external data warehouse using a batch process that runs every night. The process sometimes fails because the data warehouse is unavailable during the scheduled window. The business requires that the data be loaded successfully, but the warehouse team cannot guarantee availability at that time. What is the best approach to ensure the data is loaded?

   • AAsk the warehouse team to provide a maintenance window notification.
   • BUse a middleware tool that can queue the data and deliver it when the warehouse is available.
   • CImplement a retry mechanism that attempts the load multiple times with a delay between attempts.
   • DChange the schedule to run during a time when the warehouse is more likely to be available.
   Reveal Solution Discussion Select an answer first