Also, if we need to have different environments, like Dev, Preprod and Prod, how is that implmeneted at Prefect cloud level?

This depends on your use-case. Some users will just create projects for these within a single tenant. Enterprise client will sometimes have a separate tenant for each of these environments.