Ultimate access to all questions.
In a scenario where you have a dataset of employee records, which includes columns like employee_id, department, salary, and hire_date. 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.