Is scaling out a NoSql database in the cloud easier than scaling out an RDBMS?

The company I work at uses Sql Server mainly for persistence and are planning to move to AWS. I hear that scaling out RDBMS in cloud is really hard and costly because of the Geographical regions that you have to cover for fail-over scenarios. does moving to a NoSql database alleviate the problem of scaling out in the cloud?