Is it safe to create 'Database Master Key' on production database

Question

Recently, we have implemented bulk insert (import data from the file stored in Azure Blob Storage) in our application and for that there is required ‘Database Master Key’ to create external data source (i.e. Azure Blob Storage)  but somehow its not exist in our production Azure SQL database where its exist in our test Azure SQL database (So this import function works fine on test environment but not on production) .

We can create the ‘Database Master Key’ using below query.

 

CREATE MASTER KEY ENCRYPTION BY PASSWORD=

Answer 1

It is safe, not everybody can create a database master key, only a user with Control permissions can create a database master key on the database but is your responsibility to keep the password used confidential and in a secure place.