DRAG DROP
You administer a Microsoft SQL Server 2012 database. The database contains two tables named
Table A and Table B
You perform an import and export operation by using the following steps in sequence, as shown in
the exhibit. (Click the Exhibit button.)
Load data from a third-party database to Table
A.
Insert a subset of records from Table A to Table B. Export the data from Table B to a flat file.
You also create a format file for the data export.
You need to choose the correct command or tool for each task. You need to ensure that each task is
performed efficiently.
Which command(s) or tool(s) should you use? (To answer, drag the appropriate command(s) or
tool(s) to their corresponding task or tasks in the answer area. Answer choices may be used once,
more than once, or not at all. Answer targets may be used once or not at all. Additionally, you may
need to drag the split bar between panes or scroll to view content.) 
Doesn’t seem to have an answer displayed above?
Some suggestions:
Load data from third-party database to Table A: INSERT…SELECT…OPENROWSET
(https://msdn.microsoft.com/en-us/library/ms190312.aspx)
Insert subset of records from Table A to Table B: INSERT…SELECT
(https://social.msdn.microsoft.com/Forums/sqlserver/en-US/4e7a43e3-428c-4a0d-94ee-b49b3270fe25/difference-between-select-into-and-insert-select?forum=transactsql)
Export data from Table B to flat file: BCP
(https://msdn.microsoft.com/en-us/library/ms162802.aspx)
Create format file for data export: BCP
(https://msdn.microsoft.com/en-AU/library/ms191516.aspx)
0
0
– Load data -> Insert..Select..OPENROWSET
– Insert subset… -> INSERT..SELECT
– Export data…-> BCP
– Create format file…-> BCP
0
0
he blog was how do i say it… relevant, finally something that helped me. Thanks
http://www.bastcilkdoptb.com/
0
0
Eli and Pete are correct
http://www.aiotestking.com/microsoft/which-commands-or-tools-should-you-use/
0
0
https://msdn.microsoft.com/en-CA/library/ms162802.aspx
0
0