Your company stored customer data, including credit card numbers, in a Microsoft SQL Server database. The CreditCardNum column is configured as a varchar(16). When viewing the CreditCardNum column, only the last four digits of the card number should be displayed.

You have the following Transact-SQL statement. (Line numbers are included for reference only.)

You need to implement dynamic data masking for the CreditCardNum column.

Which Transact-SQL segment should you insert at line 05?

A.

B.

C.

D.

Example:

Using -partial- function

ALTER TABLE Ari_Users_Tbl ALTER COLUMN [CreditCard]
ADD MASKED WITH (FUNCTION = partial(0,-XXXX-XXXX-XXXX–,4))

References: https://social.technet.microsoft.com/wiki/contents/articles/35003.sql-server-exposing-masked-data.aspx#Goal_2_Find_the_CreditCard_number_for_UserID_1