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.)
Explanation:
http://msdn.microsoft.com/en-us/library/ms162802.aspxhttp://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
question is not for 70-463, but 70-462
Yeah 🙂
don’t skip these questions, 462 had few questions from 461, it’s to be expected 463 will have few from previous exams