<< Prev Question Next Question >>

Question 37/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: HOTSPOT You have a series of analytic data models and report...
Question 2: Note: This question is part of a series of questions that us...
Question 3: Note: This question is part of a series of questions that pr...
Question 4: HOTSPOT You have a database named DB1. You create a Microsof...
Question 5: Note: This question is part of a series of questions that pr...
Question 6: Note: This question is part of a series of questions that us...
Question 7: Note: This question is part of a series of questions that pr...
Question 8: DRAG DROP You administer a Microsoft SQL Server Master Data ...
Question 9: HOTSPOT You are testing a Microsoft SQL Server Integration S...
Question 10: Note: This question is part of a series of questions that pr...
Question 11: HOTSPOT You manage an inventory system that has a table name...
Question 12: HOTSPOT You have the Microsoft SQL Server Integration Servic...
Question 13: DRAG DROP Note: This question is part of a series of questio...
Question 14: Note: This question is part of a series of questions that us...
Question 15: Note: This question is part of a series of questions that us...
Question 16: DRAG DROP You have a data warehouse. You need to move a tabl...
Question 17: DRAG DROP Note: This question is part of a series of questio...
Question 18: DRAG DROP You deploy a Microsoft Server database that contai...
Question 19: You have a Microsoft SQL Server Integration Services (SSIS) ...
Question 20: HOTSPOT You have a Microsoft SQL Server Data Warehouse insta...
Question 21: Note: This question is part of a series of questions that pr...
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 pr...
Question 24: Note: This question is part of a series of questions that us...
Question 25: HOTSPOT You deploy a Microsoft Azure SQL Data Warehouse inst...
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 pr...
Question 28: HOTSPOT You create a Microsoft SQL Server Integration Servic...
Question 29: DRAG DROP You have a Microsoft SQL Server Integration Servic...
Question 30: HOTSPOT You manage a data warehouse in a Microsoft SQL Serve...
Question 31: Note: This question is part of a series of questions that pr...
Question 32: HOTSPOT Your company has a Microsoft SQL Server data warehou...
Question 33: DRAG DROP Note: This question is part of a series of questio...
Question 34: DRAG DROP You have a series of analytic data models and repo...
Question 35: HOTSPOT You have a Microsoft SQL Server Integration Services...
Question 36: Note: This question is part of a series of questions that pr...
Question 37: You have a data quality project that focuses on the Products...
Question 38: Note: This question is part of a series of questions that us...
Question 39: Note: This question is part of a series of questions that pr...
Question 40: Note: This question is part of a series of questions that pr...