Cassandra lets you tweak the C or A trade-off on each query by setting the consistency level. So yes, the same system can provide both guarantees, depending on which you need.

> if you want strong consistency, you need a relational database

You can have consistency without transactions.

Overall, it really sounds like you've never used or know much about Cassandra, and are possibly confused on the CAP theorem.