多做题,通过考试没问题!

微软认证考试

睦霖题库>其他计算机考试>微软认证考试

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.
正确答案:C
答案解析:
进入题库查看解析

微信扫一扫手机做题