You have a SQL Server 2012 database named DB1. You plan to import a large number of records from a SQL
Azure database to DB1. You need to recommend a solution to minimize the amount of space used in the
transaction log during the import operation. What should you include in the recommendation?
A.
a new log file
B.
a new filegroup
C.
the full recovery model
D.
a new partitioned table
E.
the bulk-logged recovery model
Option E.
Bulk logged recovery model minimizes impact on transaction log when huge data are transferred.
https://technet.microsoft.com/en-us/library/ms191244(v=sql.105).aspx
https://technet.microsoft.com/en-us/library/ms175987(v=sql.105).aspx
0
0