CompTIA: Advanced Security Practitioner (CASP) Exam Prep

Answer - A - Online transaction processing (OLTP) provides for fault tolerance and higher performance when databases are clustered. OLTP provides mechanisms that watch for problems and deal with them appropriately when they do occur. The main goal of OLTP is to ensure that transactions happen properly or they don’t happen at all. Transaction processing usually means that individual operations are taking place independently. If the operations fails, the rest of the operations needs to be rolled back to ensure that only accurate data is entered into the database.