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

Question

Options

• AOnline Transaction Processing
• BContent-dependent Access Control
• CCell Suppression
• DPolyinstantiation

• A
  88% (38)
• B
  2% (1)
• C
  7% (3)
• D
  2% (1)

Explanation

Online Transaction Processing (OLTP) is a category of database processing optimized for managing large volumes of short, discrete transactions (inserts, updates, deletes) in real time. When databases are deployed in a clustered configuration, OLTP systems benefit directly: clustering distributes the transaction workload across multiple nodes (higher performance) and ensures that if one node fails, others continue serving requests (fault tolerance). Content-dependent Access Control (B) is an access control model that restricts data access based on the content of the data itself - unrelated to clustering. Cell Suppression (C) is a statistical database technique used to hide sensitive aggregate values. Polyinstantiation (D) allows multiple versions of a database record to exist at different security classification levels - a multilevel security concept, not a clustering performance mechanism.

No community discussion yet for this question.