You administer a Microsoft SQL Server database. Youwant 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.)
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
Bulk Insert
Bulk-logged
Go through below links for recovery models.
http://msdn.microsoft.com/en-us/library/ms189275(v=sql.110).aspx
according to the link and the only left answer
Bulk logged & Full
but which one the answer ?
461 question