You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties include managing a SQL Server 2005 database server named Certkiller -DB01.
Certkiller -DB01 is updated with information exported from another site. Monthly the information is loaded into Certkiller -DB01 from a flat file by using the bcp utility. You have received instruction from the CIO to ensure that the operation is minimally logged. The users report that they receive error messages indicating that the transaction log is full.
After your investigation you detect that the errors occur when information is being imported. You need to prevent this problem from occurring.
What should you do?
A.
You need to use the BULK INSERT statement in order to load the data.
B.
You need to set the database recovery model to bulk-logged.
C.
You need to disable the clustered index.
Thereafter all nonclustered indexes on the target table can be disabled.
D.
You need to set the database recovery model to full.
Explanation:
The bulk-logged model differs from the Full recovery model in various ways, one of which is that bulk-load operations are minimally logged so the transactions will no be filled by the bulk-load operation.