Implementing a SQL Data Warehouse — Question 9

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: Two 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?

Answer options

• 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]?

Correct answer: A

Explanation

The correct answer is A because it accurately captures the required format of two letters followed by an asterisk and then four or five digits. Options B and C do not align with the specific format needed, and option D has a syntax that does not enforce the asterisk in the correct position, making them invalid.