Cassandra easy
While the Partition Key determines node placement, what is the role of the 'Clustering Key' in a primary key definition?
- A It defines the physical sort order of data *within* a single partition on the disk.
- B It is used to automatically encrypt the entire table if a data breach is detected.
- C It specifies which secondary data center will store the backup of the row.
- D It acts as a human-readable label used only for management console displays.
Answer: A. It defines the physical sort order of data *within* a single partition on the disk.
Clustering keys are vital for 'Range Queries'. For example, if you partition by `Sensor_ID` and cluster by `Reading_Time`, all readings for a sensor are stored together on disk, sorted by time. This allows the database to fetch a day's worth of data in a single, efficient sequential read.
One system design question a day, with spaced repetition so the ones you miss come back.
Get the appRelated questions
- In a Cassandra Keyspace, what does a 'Replication Factor of 3' specifically guarantee for your data redundancy?
- Unlike a Leader-Follower architecture (like MySQL or Redis), how does Cassandra maintain high availability within its node cluster?
- Cassandra Query Language (CQL) looks similar to SQL. What is a fundamental SQL feature that CQL does NOT support to ensure distributed performance?
- What is the critical architectural function of the 'Partition Key' in a Cassandra table?
- Apache Cassandra is fundamentally designed as which architectural category of NoSQL database?
- An extreme financial trading application requires 'Batch' sync for the Commit Log. What is the fundamental throughput limitation introduced by this setting?