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 correct answer is A. 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 chiamaka_o· Mar 5, 2026Design and implement database solutions for SQL Server

Question

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?

Options

AThe bulk-logged recovery model
BThe full recovery model
CA new partitioned table
DA new log file
EA new file group

How the community answered

(51 responses)

A
75% (38)
B
14% (7)
C
2% (1)
D
6% (3)
E
4% (2)

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.

Topics

#Transaction log management#recovery models#bulk operations#data import

Community Discussion

No community discussion yet for this question.

Full 70-465 Practice