CAS-002 Question #311: Real Exam Question with Answer & Explanation

The correct answer is A: Online Transaction Processing. 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

Question

What provides for fault tolerance and higher performance when databases are clustered?

Options

AOnline Transaction Processing
BCell Suppression
CContent-dependent Access Control
DPolyinstantiation

Explanation

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.

Community Discussion

No community discussion yet for this question.

Full CAS-002 Practice