Каков правильный ответ на вопрос:

You have developed a new database for your development group to use when testing their new application. When the database was first passed to them, neither you nor they were concerned with data recovery. As a result, the database initially carried a log file of only 5MB (with autogrow, but no autoshrink) and had its truncate log on checkpoint option set on. Midway through their tests, however, one of the developers turned the option off, and consequently the log automatically grew to its current size of 150MB. Concerned about the low amount of free space remaining on the disk drive holding the log, you turn the option on once again. What configuration would you expect after the next checkpoint has passed?


A . SQL Server will never truncate this particular log
B . The log would have been truncated, but the log allocation remains at 150MB.
C . The log would have been truncated, and the log allocation returns to 5MB
D . The log would have been truncated, and the log allocation would shrink somewhat, but not back to 5MB.

Мой ответ D.