An e-commerce analytics team needs to generate sales reports by product category and month. The dataset is large.
Which strategies help improve performance?

Question

An e-commerce analytics team needs to generate sales reports by product category and month. The dataset is large. 
 Which strategies help improve performance?

Answer

Use aggregation pipelines with  $match  and  $group  stages

Answer

Denormalize only after reading

Answer

Rely on client-side aggregation

Answer

Create compound indexes on  (category, month)

Crowdly

An e-commerce analytics team needs to generate sales reports by product category...

Want instant access to all verified answers on moovit.vit.ac.in?