Which option best describes the use of CAP theorem in a database system?

A. a distributed system cannot simultaneously guarantee strong consistency, availability, and partition tolerance under network partition B. NoSQL databases cannot be replicated C. indexes always remove the need for consistency D. every database must use only SQL