You work as a senior database administrator at ABC.com. The ABC.com network consists of a
single domain named ABC.com. ABC.com makes use of Microsoft SQL Server 2012 in their
environment.
You are running a training exercise for Microsoft SQL Server 2012 junior administrators. You are
discussing copying data between data sources.
Which of the following is the simplest method of achieving this?
A.
The SELECT INTO Transact SQL statement.
B.
The SQL Server Import and Export Wizard.
C.
The bcp command prompt utility.
D.
SQL Server replication.
Explanation: