Ideally, you should keep your production and test database in different database deployments because of the following reasons:
If you keep both the database in the same deployment you will have a similar connection string except for the database name part of it, which can be confusing and can lead to unexpected data operations in production.
On the other hand, if you keep them in different deployments, you will be able to better analyze the performance and other metrics and see how your respective deployments are doing without the side effects of one on another.
If you have any doubts, please feel free to reach out to us.