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.
Explanation:
http://msdn.microsoft.com/en-gb/library/ms190925.aspx
Answer is B
B
definitly B