You are a database administrator for AIOTestKing.com. You receive nightly data feeds from your consumer electronics suppliers that show their inventory levels. The data value format that you receive from each supplier is not necessarily consistent. You need to ensure that the data that you import into your database is accurate and is not duplicated.
What should you do?
A.
Use a Fuzzy Lookup transform in SQL Server Integration Services (SSIS) to import the data into your database.
B.
Write a query that includes the HAVING clause to remove duplicate values before the data is imported into your database.
C.
Write a query that uses the CHARINDEX function to import the data by using the SQL Server Import Wizard and configure it to ignore duplicate values.
D.
Configure CHECK constraints on the table that contains the imported data.
Explanation:
The Fuzzy Lookup transformation performs data cleaning tasks such as standardizing data, correcting data, and providing missing values.