Which data import command and recovery model should you choose?

DRAG DROP
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 should you choose? (To answer, drag the
appropriate data import command or recovery model to the appropriate location 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 drag the split bar between panes or scroll to view content.)

DRAG DROP
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 should you choose? (To answer, drag the
appropriate data import command or recovery model to the appropriate location 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 drag the split bar between panes or scroll to view content.)

Answer:

Explanation:
References:
http://msdn.microsoft.com/en-us/library/ms162802.aspx
http://msdn.microsoft.com/en-us/library/ms188365.aspx
http://msdn.microsoft.com/en-us/library/ms175937.aspx
http://msdn.microsoft.com/en-us/library/aa337544.aspx



Leave a Reply 2

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


Islam

Islam

this question has nothing to do with the 70-463 it’s related to the 70-462

grsty

grsty

Tell it to Microsoft