Question: You are designing a MongoDB schema to support queries that will include lookups. What should you do?

  1. Create an index on the key value used as the primary key.
  2. Create an index on the key value used as the foreign key.
  3. Create a multicolumn index on the key value used as the foreign key and the most unique column in the document.
  4. 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.