All posts (questions, answers, and comments) are stored in the database. If the database runs out of disk space Q2A will obviously not be able to write posts to the database anymore, meaning that users will not be able to ask, answer, or comment. The attempt should throw an error, at least in the logs.
I'm not aware of a way to create/use the kind of "federated" database you describe in Q2A.