Acquia Cloud Drush commands can be confusing when referencing an environment specific database. Luckily, the API infers from your command which environment the database is in.
Resolution
You might be tempted to add the environment to your database name: