You have a SQL Server 2014 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.
The bulk-logged recovery model

B.
The full recovery model

C.
A new partitioned table

D.
A new log file

E.
A new file group

Explanation:

Compared to the full recovery model, which fully logs all transactions, the bulk-logged
recovery model minimally logs bulk operations, although fully logging other transactions. The
bulk-logged recovery model protects against media failure and, for bulk operations, provides
the best performance and least log space usage.
Note:
The bulk-logged recovery model is a special-purpose recovery model that should be used
only intermittently to improve the performance of certain large-scale bulk operations, such as
bulk imports of large amounts of data.