You are creating a Windows application by using the .NET Framework 3.5.
The application must import data from a legacy database.
A comma-delimited text file that has 10,000 rows of data is exported from the database frequently. The
data is displayed and processed by the Windows application.
The text file is not trusted and can contain invalid data. The application database must store valid data.
You need to create a strategy to optimally validate and process the application data.
What should you do?
A.
Create OLEDB connections to directly access the text file.
Validate the data before you retrieve it.
B.
Use OLEDB connection to directly access the text file.
Load the data into a dataset.
Validate the data in the dataset before you display it.
C.
Use bulk import to import data daily to the production tables.
Connect to the production tables.
Validate the data before you retrieve it.
D.
Use bulk import to import data daily to temporary tables.
Validate the data and merge the temporary tables with production tables.
Connect to the production tables to retrieve data.