Ultimate access to all questions.
In a scenario where you have a dataset of user activities on a social media platform, which includes columns like user_id, activity_type, timestamp, and location. Explain how you would decide on the appropriate partitioning strategy for this dataset to optimize query performance. Consider the frequency of queries and the nature of the data.