You need to cleanse and standardize the data on potential survey participants prior to inserting it into the staging database. What should you do?()

A . Import the data into a staging table by using the OPENROWSET BULK statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database. B . Import the data into a staging table by using the BULK INSERT statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database. C . Create a SQL Server Integration Services (SSIS) package to import, standardize, and cleanse the data. D . Create a CLR stored procedure to import the data into a staging table, to cleanse and standardize the data, and to insert the data into the database.

时间:2022-11-09 13:20:34 所属题库:MCITP(70-441)题库

相似题目