Exam C100DBA Topic 3 Question 30 Discussion

updateMany() distinguishes between documents that match the filter and documents whose stored data actually changes. The filter { diagnosis: " Hypertension " } matches Carlos Martinez and Maria Lopez, so matchedCount is 2. Carlos currently has room: 203, and $set: { room: 207 } changes his document, contributing one to modifiedCount. Maria already has room: 207. She still satisfies the filter and therefore counts as a match, but setting a field to the value it already contains does not produce a material modification, so she does not increment modifiedCount. Juan Perez has diagnosis Arrhythmia, so he is neither matched nor modified. The resulting acknowledged operation therefore reports matchedCount: 2 and modifiedCount: 1, corresponding to option D. This distinction is essential when validating whether an update actually changed stored values rather than merely identifying matching records. This distinction is operationally important: a large difference between matched and modified counts can indicate that many matching documents already contained the requested state, not that the update failed. DBAs should use both counters when validating bulk- update behavior.
Study Guide reference/topic:MongoDB Architecture and Core Operations - updateMany(), $set, matchedCount, and modifiedCount.