Exam 70-464 topic 1 question 43 discussion

Actual exam question from Microsoft's 70-464

Question #: 43
Topic #: 1

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.

Show Suggested Answer

Suggested Answer: D 🗳️

by Kepty at Nov. 22, 2020, 8:07 p.m.

Comments

Submit Cancel

Kepty

4 years, 6 months ago

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...

upvoted 1 times

LiamLin

3 years, 9 months ago

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

upvoted 1 times

...