You need to minimize disk contention caused by change data capture

You have a database named DB1.
You plan to configure change data capture on the existing tables in DB1.
The database file settings for the DB1 are shown in the exhibit. (Click the Exhibit button.)

You need to minimize disk contention caused by change data capture.
What should you do?
More than one answer choice may achieve the goal. Select the BEST answer.

You have a database named DB1.
You plan to configure change data capture on the existing tables in DB1.
The database file settings for the DB1 are shown in the exhibit. (Click the Exhibit button.)

You need to minimize disk contention caused by change data capture.
What should you do?
More than one answer choice may achieve the goal. Select the BEST answer.

A.
Increase the autogrowth value of the database file.

B.
Set the database recovery model to simple.

C.
Increase the autogrowth value of the log file.

D.
Configure change data capture to use to a secondary filegroup.



Leave a Reply 1

Your email address will not be published. Required fields are marked *