Which three actions should you perform in sequence?

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.)

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:

Explanation:
Reference:
http://technet.microsoft.com/en-us/library/ms187048.aspx
http://technet.microsoft.com/en-us/library/ms189272.aspx



Leave a Reply 0

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