HOTSPOT
You have a data warehouse that is hosted in a SQL Server instance. The data in the data warehouse is
loaded by running bcp.exe You discover that the transaction logs regularly fill up the local hard disk on
the server and that a WRITELOG wait is present. You need to reduce the amount of disk space used to
store the transaction logs and to remove the WRI7TLOG wait.
Which two database property settings should you modify? To answer, select the appropriate settings in
the answer area.
