Part of your deployment strategy should be to secure not only the databases but also the data itself. Examine dynamic data masking, a feature in SQL Server 2016 that can be used to limit exposure to sensitive data.
Learning Objectives
{"describe dynamic data masking "}