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.)
Select and Place:
Answer: 
Explanation:
Are you sure about this? Can anyone please confirm?. The database is already in FULL Recovery.
It should have been:
1. Perform a database LOG backup.
2. Configure the database to use BULK-LOGGED recovery model.
3. Execute the BCP tool.
I think it should be
Bulk logged
BCP
Full recovery
LOG backup – requirement b
BULK logged – requirement a
BCP
You need to ensure that the following requirements are met during the bulk operation:
a.The database transaction log is minimally affected.
b.The database is online and all user transactions are recoverable. All transactions are fully recoverable prior to
the import.
I agree with jason and vish
“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.”
Bulk logging does NOT allow for point in time recovery and therefore with this mode enabled you would not be able to recover user transactions.
FULL recovery is the ONLY mode that allows for this.
If the question specified that you had zero user access to the database during the load then bulk logged would be the correct choice.
Considerations for Switching from the Full or Bulk-Logged Recovery Model
http://technet.microsoft.com/en-us/library/ms190203%28v=sql.105%29.aspx
I would say the correct answers are:
Perform a database log back
Switch Recovery Model to Bulk-Logged
Execute BCP.exe
Leaving the Recovery Model as Full will fill up the transaction log and it states to minimally impact the transaction log. After the bulk-insert, set it back to Full Recovery Model
Under the full recovery model, all bulk operations are fully logged. However, you can minimize logging for a set of bulk operations by switching the database to the bulk-logged recovery model temporarily for bulk operations. Minimal logging is more efficient than full logging, and it reduces the possibility of a large-scale bulk operation filling the available transaction log space during a bulk transaction. However, if the database is damaged or lost when minimal logging is in effect, you cannot recover the database to the point of failure.