Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
In a scenario where you have a dataset of medical records, which includes columns like patient_id, doctor_id, diagnosis, and timestamp. 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.