Which command(s) or tool(s) should you use?

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.)

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.)

Answer:



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Maddy

Maddy

No BULK INSERT option given. So OPENROWSET is first choice.