DRAG DROP
You administer a Microsoft SQL Server 2012 database.
The database uses SQL Server Agent jobs to perform regular FULL and LOG backups. The
database uses the FULL recovery model.
You plan to perform a bulk import of a very large text file.
You need to ensure that the following requirements are met during the bulk operation:
The database transaction log is minimally affected.
The database is online and all user transactions are recoverable.
All transactions are fully recoverable prior to the import.
Which three actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)
Answer: 
log backup should by on the last posititon (3)
Nope. The transaction log backup need to be done BEFORE the bulk import. The question asks that XLog is to be MINIMALLY affected also. So the answer order displayed is correct.
The 3rd answer could NEVER be right. The first two are correct. If you restored the XLog between those hours, you would bring the database state right back to where it was before the restore – with the dropped tables and stored procedures. One big time wasting looop……
I’m confused. The tables aren’t dropped until after 22:40, so how does restoring the transaction logs between 22:00 – 22:40 bring the db back to where it was before the restore?
Maybe, tables might have been dropped at 22:40 during the XLog backup, but I think that the answer is correct is this case.
The question could be made better (for example saying that the tables had been dropped from 22:45)
I have the same question.
I agree.
Another point is why not the first step to be “Restore the most recent Full backup”? It’s essentially the same as “Restore full backup from previous night”, isn’t it ? Providing tow same options in the question is wrong.
tow should be read two in previous post (typo)
The most recent backup is at 23:00 of the same night. Tables started dropping at 22:40, 20 minutes before this backup. So, you need the backup from the previous night. Then the 22:00 differential Then log backups to 22:40, of which there should be 4.
The answer is not wrong, but in real life scenario, I would rather take the log backup after changing the recovery model to Bulk_logged. This is to include any transaction happens during the time the recovery model is being changed (even milliseconds).
The database is currently configured with the FULL recovery model; so, before you change it to the BULK-LOGGED model (for the data load), perform a T-Log backup. After the data load, perform a T-Log backup again before reverting the DB back to the FULL recovery model.
I have a question, can it only restore the differential backup taken at 22:00 hours? Because between the full backup on previous night and today 22:00 hours, there are still a set of differential backup