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 correct answer is E. the bulk-logged recovery model. 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…

Submitted by ravi_2018· Mar 5, 2026Design and implement database solutions for SQL Server

Question

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?

Options

Aa new log file
Ba new filegroup
Cthe full recovery model
Da new partitioned table
Ethe bulk-logged recovery model

How the community answered

(24 responses)

C
4% (1)
D
4% (1)
E
92% (22)

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. 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. Recovery Models (SQL Server)

Topics

#transaction log#bulk-logged recovery model#data import#recovery models

Community Discussion

No community discussion yet for this question.

Full 70-465 Practice