Question: You are designing a MongoDB schema to support queries that will include lookups. What should you do?
- Create an index on the key value used as the primary key.
- Create an index on the key value used as the foreign key.
- Create a multicolumn index on the key value used as the foreign key and the most unique column in the document.
- Create a multicolumn index on the key value used as the primary and also the forign key.
Answer: The correct answer of the above question is Option C:Create a multicolumn index on the key value used as the foreign key and the most unique column in the document.