Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
When optimizing data storage and query performance in Databricks by selecting a partition column, which of the following considerations is most important?
A
Select a column with high cardinality to reduce the number of partitions.
B
Opt for a column with frequent updates to improve partition pruning.
C
Choose a column with a low cardinality that evenly distributes data.
D
Prioritize a column with complex data types for better organization.
E
Use a column unrelated to the data to enhance partitioning efficiency.