1 / 5
Fill in: 'We ___ a compound index that matches the exact query shape our application actually runs.'
-
-
-
-
We 'create an index' — the standard, simple collocation for adding a new index. The other options are less idiomatic here.
2 / 5
Fill in: 'A missing index on a filtered field can ___ MongoDB into scanning every document in the collection.'
-
-
-
-
We say a missing index will 'force' a collection scan — the standard collocation for the resulting behaviour. The other options aren't idiomatic here.
3 / 5
Fill in: 'We ___ the query plan with explain() to confirm an index is actually being used, not just present.'
-
-
-
-
We 'check' a plan — the standard, simple collocation for examining execution details. The other options are less idiomatic here.
4 / 5
Fill in: 'We ___ unused indexes periodically since every extra index adds write overhead on every insert.'
-
-
-
-
We 'remove an index' — the standard, simple collocation for deleting one that's no longer needed. The other options aren't idiomatic here.
5 / 5
Fill in: 'We ___ index builds in the background on a live collection so reads and writes aren't blocked.'
-
-
-
-
We 'run a build' — the standard, simple collocation for executing an index-creation operation. The other options are less idiomatic here.