A. INSERT … SELECT
D. None of the mentioned
The question was asked at a job interview.
This interesting question is from Bulk Operations in chapter Data Connectivity of SQL Server
Best explanation: INSERT … SELECT is a Transact-SQL statement that uses the OPENROWSET bulk rowset provider to bulk import data into a SQL Server table by specifying the OPENROWSET(BULK…) function to select data in an INSERT statement.