Which data import command and recovery model shouldyou choose?

You administer a Microsoft SQL Server database.
You want to import data from a text file to the database.
You need to ensure that the following requirements are met:
Data import is performed by using a stored procedure.
Data is loaded as a unit and is minimally logged.
Which data import command and recovery model shouldyou choose? (To answer, drag the appropriate data
import command or recovery model to the appropriatelocation or locations in the answer area. Each data
import command or recovery model may be used once, more than once, or not at all. You may need to dragthe
split bar between panes or scroll to view content.)
Select and Place:

You administer a Microsoft SQL Server database.
You want to import data from a text file to the database.
You need to ensure that the following requirements are met:
Data import is performed by using a stored procedure.
Data is loaded as a unit and is minimally logged.
Which data import command and recovery model shouldyou choose? (To answer, drag the appropriate data
import command or recovery model to the appropriatelocation or locations in the answer area. Each data
import command or recovery model may be used once, more than once, or not at all. You may need to dragthe
split bar between panes or scroll to view content.)
Select and Place:

Answer:

Explanation:



Leave a Reply 5

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


Koala5KK

Koala5KK

Why not BCP as Data import command.
Is BULK INSERT a stored procedure?

Dave

Dave

Because BCP doesn’t a TSQL command, so you can’t use it in a stored procedure.

Brian K

Brian K

BCP.exe is a command line utility ( a program in itself). BULK INSERT is a TSQL command.

WalterG

WalterG

BULK INSERT and recovery Simple

Donk

Donk

Bulk insert and Bulk Logged is correct.

BTW. Question is part of 70-463 exam