Exam 70-765 topic 3 question 125 discussion

Actual exam question from Microsoft's 70-765

Question #: 125
Topic #: 3

You have a SQL Server 2016 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

Show Suggested Answer

Suggested Answer: A 🗳️
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.
References:
https://technet.microsoft.com/en-us/library/ms190692(v=sql.105).aspx

by [deleted] at April 4, 2025, 4:10 a.m.

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!