I came across an interesting article trying to compare the main features, pros, and cons of two leading database engines of the relational (MySQL) and non-relational world - MongoDB.
The article focuses on these two database technologies, but they can be extended to the whole realm of RDBMS and NoSQL databases.
Certain aspects of both domains can be considered as advantages or disadvantages, depending on the point of view and particular business case. The flexibility of schema in MongoDB is appealing to teams who implement applications dealing with unstructured data. The strictness of schema definition required by relational databases can be beneficial when the application needs to ensure that the data quality meets certain requirements.
You will find yourself in trouble if you choose the wrong data architecture - performance issues, scalability, data quality problems, and outages are among the things that await you.