A social media app needs to show the latest 50 posts for each user quickly. Older posts can be archived.
Which two design choices are most appropriate?

Question

A social media app needs to show the latest 50 posts for each user quickly. Older posts can be archived. 
 Which two design choices are most appropriate?

Answer

Limit query results to 50 most recent posts

Answer

Use a single global table for all users

Answer

Use  user_id  as partition key and  post_timestamp  as clustering key

Answer

Perform a full table scan for each user’s feed

Crowdly

A social media app needs to show the latest 50 posts for each user quickly. Olde...

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