Concurrent Integration Performance Issue:
"During a stress test of an integration where many records are created in parallel in F&O, you observe performance bottlenecks traced to number sequence generation. What could cause these performance issues with number sequences under high concurrency, and what configurations or design changes could improve throughput?"
Interviewer guidance: The candidate should identify potential locking/contention due to number sequences - likely because a continuous sequence is used, which serializes generation, or due to lack of caching. They should suggest enabling Preallocation (caching) for the sequence to reduce database hits and locks, and consider switching to a noncontinuous sequence (if possible) to avoid the overhead of continuous allocation. They might also mention scaling by splitting workload or serializing calls intentionally if needed, but primarily focusing on number sequence config changes to handle concurrency.