Hi M201 Courseware Folks,
In M201 the following quiz lists only the top answer as correct. I believe that the second answer should also be correct, If there’s an index on one of the fields for an exact match query it will first do an index scan on the indexed field and then a scan of those documents to match on the second unindexed field.
Is this correct? If not, why?