Mid SQL

Partition Tolerance: The system continues to operate despite network partitions.?

Trade-offs:

  • CA (Consistency and Availability): Systems that prioritize consistency and

availability will fail during network partitions.

  • CP (Consistency and Partition Tolerance): Systems that prioritize consistency and

partition tolerance may not be available during network issues.

  • AP (Availability and Partition Tolerance): Systems that prioritize availability and

partition tolerance may return stale data.

More from SQL Server Tutorial

All questions for this course