nerdexam
CompTIA

CAS-002 · Question #311

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

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…

Technical Integration of Enterprise Components

Question

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

Options

  • AOnline Transaction Processing
  • BCell Suppression
  • CContent-dependent Access Control
  • DPolyinstantiation

How the community answered

(33 responses)
  • A
    88% (29)
  • B
    6% (2)
  • C
    3% (1)
  • D
    3% (1)

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.

Topics

#database clustering#fault tolerance#OLTP#high availability

Community Discussion

No community discussion yet for this question.

Full CAS-002 Practice