You work as an expert consultant for Advanced Azure Learning where the IT team is working on an Azure SQL database titled AAL_Targets which has a table titledTargets_2021. In the table, there is a field Targets_ID having type varchar(22). 
Required: The team is to implement masking for the Targets_ID field as given below: 
• Setting the initial 3 prefix characters as "exposed" 
• Setting the final 3 suffix characters as "exposed" 
• Setting the rest of the characters as "masked" 
The IT team is planning to use data masking with a credit card function mask. 
As an expert, you need to tell if the given solution meets the requirements and achieves the goal.

Answer options:

A.Yes
B.No

Correct Answer: B 
The below figure described the various masking functions with their masking logic: 

As can be seen from the above image, utilizing data masking with a credit card function mask won`t be successful. To accomplish the requirements, AAL needs to use Custom Text data masking, which will expose the first and last characters as mentioned and add a custom padding string in the middle. 
Reference:
To know more about dynamic data masking, please visit the below-given link: 

https://docs.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview