<< Prev Question Next Question >>

Question 13/40

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?

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (40q)
Question 1: Note: This question is part of a series of questions that us...
Question 2: Note: This question is part of a series of questions that pr...
Question 3: Note: This question is part of a series of questions that pr...
Question 4: A database has tables named Table1, Table2, and Table3. Tabl...
Question 5: Note: This question is part of a series of questions that us...
Question 6: Note: This question is part of a series of questions that pr...
Question 7: Note: This question is part of a series of questions that us...
Question 8: You have a data warehouse named DW1. In DW1, you plan to cre...
Question 9: You have a data warehouse named DW1. All data files are loca...
Question 10: Note: This question is part of a series of questions that pr...
Question 11: You have a database named DB1 that contains millions of rows...
Question 12: Note: This question is part of a series of questions that pr...
Question 13: You have a data quality project that focuses on the Products...
Question 14: Note: This question is part of a series of questions that pr...
Question 15: Note: This question is part of a series of questions that pr...
Question 16: You plan to deploy several Microsoft SQL Server Integration ...
Question 17: Note: This question is part of a series of questions that us...
Question 18: Note: This question is part of a series of questions that pr...
Question 19: Note: This question is part of a series of questions that pr...
Question 20: Note: This question is part of a series of questions that pr...
Question 21: You have a data warehouse named DW1that contains 20 years of...
Question 22: Note: This question is part of a series of questions that pr...
Question 23: Note: This question is part of a series of questions that us...
Question 24: Note: This question is part of a series of questions that us...
Question 25: Note: This question is part of a series of questions that pr...
Question 26: Note: This question is part of a series of questions that us...
Question 27: Note: This question is part of a series of questions that us...
Question 28: Note: This question is part of a series of questions that pr...
Question 29: You manage Master Data Services (MDS). You plan to create en...
Question 30: Note: This question is part of a series of questions that pr...
Question 31: Note: This question is part of a series of questions that pr...
Question 32: Note: This question is part of a series of questions that pr...
Question 33: Note: This question is part of a series of questions that pr...
Question 34: Note: This question is part of a series of questions that pr...
Question 35: Note: This question is part of a series of questions that us...
Question 36: Note: This question is part of a series of questions that pr...
Question 37: Note: This question is part of a series of questions that pr...
Question 38: Note: This question is part of a series of questions that us...
Question 39: You have a Microsoft SQL Server Integration Services (SSIS) ...
Question 40: Note: This question is part of a series of questions that pr...