<< Prev Question Next Question >>

Question 35/40

HOTSPOT
You have a Microsoft SQL Server Integration Services (SSIS) package that contains a Data Flow task as shown in the Data Flow exhibit. (Click the Exhibit button.)

You install Data Quality Services (DQS) on the same server that hosts SSIS and deploy a knowledge base to manage customer email addresses. You add a DQS Cleansing transform to the Data Flow as shown in the Cleansing exhibit. (Click the Exhibit button.)

You create a Conditional Split transform as shown in the Splitter exhibit. (Click the Exhibit button.)

You need to split the output of the DQS Cleansing task to obtain only Correct values from the EmailAddress column.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Hot Area:

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...