You have a data quality project that focuses on the Products catalog for the company. The data includes a product reference number.

The product reference should use the following format: T

wo letters followed by an asterisk and then four or five numbers. An example of a valid number is

XX*55522

. Any reference number that does not conform to the format must be rejected during the data cleansing.

You need to add a Data Quality Services (DQS)

domain rule in the Products domain.

Which rule should you use?

A. value matches pattern

ZA*9876[5]

B. value matches pattern

AZ[*]1234[5]

C. value matches regular expression

AZ[*]1234[5]

D. value matches pattern

[a-zA-Z][a-zA-Z]*[0-9][0-9][0-9][0-9][0-9]?

Explanation:

For a pattern matching rule:

Any letter (A-¦Z) can be used as a pattern for any letter; case insensitive

Any digit (0-¦9) can be used as a pattern for any digit

Any special character, except a letter or a digit, can be used as a

pattern for itself

Brackets, [], define optional matching

Example: ABC:0000

This rule implies that the data will contain three parts: any three letters followed by a colon (:), which is again followed by any four digits.