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.
To minimize disk contention caused by change data capture, configure change data capture to use a secondary filegroup. This approach helps separate the changes tracked by CDC into a different part of the disk, reducing the load on the primary filegroup and minimizing contention. Since change data capture creates additional tables to track changes, placing these tables in a secondary filegroup can help distribute the IO workload more effectively.
I don't agree with the answer. The right answer is probably C - to change autogrown value of log file as it is constant (10MB) now and we have no information about the data in DB. So data will grown by 25% each time, but the log only 10MB...
I think D is correct. Change Data Capture is also create TABLE. So to "minimize disk contention" we need to save Data Capture TABLE in to another filegroup