Which of the following can be used for bidirectional data transfers and is a stand-alone application that is run from a command prompt?
A)BULK INSERT SQL
B)bcp utility
C)SSIS
D)ETL

Question

Quizplus · Accepted Answer

The bcp utility is a command-line tool that can be used for bidirectional data transfers. It allows for efficient bulk copy operations between SQL Server and other data sources. It is a stand-alone application that is run from a command prompt. BULK INSERT SQL is also used for bulk import operations but is not a stand-alone application and requires the use of T-SQL. SSIS and ETL are both used for data integration and transformation but are not specifically designed for bidirectional data transfers.

Which of the Following Can Be Used for Bidirectional Data