A.You should create a cached data collection B.You should create an on-demand non-cached data collection C.You should create a scheduled non-cached data collection. D.You should create two different SQL Agent jobs. The two jobs are scheduled at the same time. One job uploads the data collection and the other job creates a data collection.
A.On the Products table, you should create a view. B.On the RadioSize column, you should create a clustered index C.On the RadioSize column, you should create a filtered index D.On the RadioSize column, you should create a unique clustered index
A.You should run the bulk copy program utility along with an output file and no format file B.You should run the SQLCmd utility and save the output to a file C.You should run the SQL Import and Export Data Wizard and save the output to a file. D.You should run the bulk copy program utility along with a format file and an output file.
A.You should recreate the publication B.You should upload unsynchronized changes. C.You should reinitialize the publication and generate a new snapshot at once. D.You should upload unsynchronized changes, and then reinitialize the publication
A.bcp.exe B.dta.exe C.dtexec.exe D.sqlmaint.exe