单项选择题
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.
多项选择题 You need to ensure that survey customers are automatically notified when their survey results are available. You must also ensure that customers can manage their own recipient lists. Which two actions should you perform?()
多项选择题 YouaredesigningaperformancemonitoringplanforthedatabasethatsupportsAPP1.Youneedtomonitoronlynecessaryindicators.Whichindicatororindicatorsshouldyouincludein thebaseline?()