1.The best way to deal with null values in a dimension data set when doing data cleanse is: A. Delete the records with null values B. Replace null values with descriptive non-null values based on context C. replace null values with an empty string D. leave them as is 2. Which task is not available in SSDT/SSIS data flow package? A. derived column B. multicast C. merge D. add surrogate key 3.Which of the following is NOT done as a Control Flow task in SSIS package design? A. send email B. FTP C. move a file to another directory D. read data from an excel file 4. Data in different database systems (SQL Server or Oracle) is an example of: A. Semantic heterogeneity B. Structural heterogeneity C. Syntax heterogeneity D. System heterogeneity 5. Which of the following action is a transformation? A.Read an XML file B. Replace all two letter state names with full state names C.Insert a record in the table D.Get data from a webpage