Question 1
A financial services company has a critical BusinessWorks process that writes transaction records to a primary and a secondary audit database using two separate JDBC Update activities. A requirement states that a transaction record must be written to both databases or neither; a partial write is unacceptable. Which configuration provides the most efficient and reliable mechanism to enforce this requirement within the process definition?
Answer and explanation
Correct answer: B
A JDBC Transaction group is the correct mechanism to ensure atomicity across multiple JDBC activities. It manages a single database transaction that encompasses all activities within the group. If any activity fails, the entire transaction is rolled back, preventing partial writes and ensuring data consistency across both databases, assuming they participate in the same transaction context.