You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft
SQL Server 2012 infrastructure. You have a database named CorpDB. CorpDB contains 2TB of data. You plan
to import a large amount of data into tables in CorpDB. You want to minimize the size of the transaction log
while the data is imported. What should you do?
A.
You should configure the recovery model of the database to Full.
B.
You should configure the recovery model of the database to Bulk-Logged.
C.
You should start a new transaction log file.
D.
You should configure a new filegroup for the existing log file.
B. is the right answer. More details about this recovery model:
https://technet.microsoft.com/en-us/library/ms190692(v=sql.105).aspx