The interviewer question was adversarial... don't think it puts them in a good light.

More importantly I appreciate the OP for describing lessons learned through this hard experience. I worked in finance: Cassandra is no kind of answer for systems of record

Thanks