Next Question >>

Question 1/41

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 (41q)
Question 1: You have a data quality project that focuses on the Products...
Question 2: Note: This question is part of a series of questions that pr...
Question 3: You are building a server to host a data warehouse. The plan...
Question 4: Note: This question is part of a series of questions that pr...
Question 5: You have a server that has Data Quality Services (DQS) insta...
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 us...
Question 8: Note: This question is part of a series of questions that pr...
Question 9: Note: This question is part of a series of questions that us...
Question 10: HOTSPOT You manage a data warehouse in a Microsoft SQL Serve...
Question 11: HOTSPOT You have the Microsoft SQL Server Integration Servic...
Question 12: Note: This question is part of a series of questions that pr...
Question 13: HOTSPOT You deploy a Microsoft Azure SQL Data Warehouse inst...
Question 14: Note: This question is part of a series of questions that us...
Question 15: You have a Microsoft SQL Server Integration Services (SSIS) ...
Question 16: Note: This question is part of a series of questions that us...
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 us...
Question 19: Note: This question is part of a series of questions that us...
Question 20: Note: This question is part of a series of questions that us...
Question 21: Note: This question is part of a series of questions that pr...
Question 22: You need to ensure that a downstream system can consume data...
Question 23: Note: This question is part of a series of questions that pr...
Question 24: HOTSPOT You have a Microsoft SQL Server Data Warehouse insta...
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 pr...
Question 27: You plan to deploy several Microsoft SQL Server Integration ...
Question 28: You have a data warehouse named DW1. In DW1, you plan to cre...
Question 29: Note: This question is part of a series of questions that pr...
Question 30: Note: This question is part of a series of questions that us...
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 us...
Question 33: DRAG DROP You have a data warehouse. You need to move a tabl...
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: DRAG DROP You have a Microsoft SQL Server Integration Servic...
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: Note: This question is part of a series of questions that us...
Question 40: Note: This question is part of a series of questions that pr...
Question 41: You have a database named DB1 that contains millions of rows...