exam questions

Exam 70-462 All Questions

View all questions & answers for the 70-462 exam

Exam 70-462 topic 2 question 6 discussion

Actual exam question from Microsoft's 70-462
Question #: 6
Topic #: 2
[All 70-462 Questions]

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.)
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
mickeygeorge
4 years, 5 months ago
Its references "Data loaded as a unit and is minimally logged" so should it not be Bulk Logged as it has reduced logging and helps to reduce the size of the transaction log
upvoted 1 times
...
mr_corte
5 years, 5 months ago
the second one could be Full
upvoted 1 times
...
Varad
5 years, 7 months ago
1. BULK INSERT 2. BULK LOGGED
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago