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 from a Windows batch file.
• 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. 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.)
Select and Place:

microsoft-exams

One thought on “Which data import command and recovery model should you choose?

  1. Answer should be: bcp and bulk-logged since the requirement is to perform data import via batch file.

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.