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

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 recover

y 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)

You have a SQL Server 2012 database named DB1.

You have a backup device named Device1.

You discover that the log file for the database is full.

You n

eed to ensure that DB1 can complete transactions.

The solution must not affect the chain of log sequence numbers (LSNs).

Which code segment should you execute?

A. BACKUP LCG DB1 TO Device1 WITH COPY_ONLY

B. BACKUP LOG DB1 TO Device1

C. BACKUP LOG DB1 TO

Device1 WITH NCRECCVERY

D. BACKUP LOG D31 TO Device1 WITH TRUNCATE ONLY

References:

http://msdn.microsoft.com/en-us/library/ms186865.aspx

http://msdn.microsoft.com/en-us/library/ms179478.aspx

http://msdn.microsoft.com/en-us/library/ms190925.as

px