FlashKeepers

Databases · College · College and University

Cassandra, DynamoDB and Wide-Column Stores

Partition keys, clustering keys, consistency levels, tunable consistency, single-table design and eventual consistency.

About this set

35 basic cards for College Databases. It opens with "What is a partition key in Cassandra or DynamoDB?" and "How does Cassandra distribute data using partition keys?". Study it alongside the other College sets below.

35 cards · basic cards · AI-written, checked twice. Edit anything.

Study this set free Look inside first Get FlashKeepers for iPhone

Opens in your browser, no account. Get the iPhone and iPad app · Android app

What is a partition key in Cassandra or DynamoDB?
Show answerThe primary key component that determines which node stores the data through hash-based distribution.
How does Cassandra distribute data using partition keys?
Show answerThe partition key is hashed to determine which nodes own the partition.
Can you have a composite partition key in Cassandra?
Show answerYes, multiple columns can be combined to form a single partition key.
What happens if a partition key hash leads to uneven data distribution?
Show answerSome nodes become hot spots and receive more data than others, causing performance imbalance.
What is a clustering key in Cassandra?
Show answerA column that determines the sort order of rows within a partition.
How do clustering keys differ from partition keys?
Show answerPartition keys determine which node stores data, clustering keys determine sort order within a partition.
Can you perform range queries on clustering keys in Cassandra?
Show answerYes, range queries (greater than, less than, between) on clustering keys are efficient.
In what order are rows sorted within a partition in Cassandra?
Show answerBy the clustering key columns, in the order they are defined.
How is a row uniquely identified in Cassandra?
Show answerBy the combination of partition key and clustering key together.
Why would you choose a timestamp as a clustering key?
Show answerTo keep time-series events ordered within a partition, allowing efficient range queries by time.
What is a consistency level in Cassandra?
Show answerA setting that specifies how many replicas must respond before a read or write is acknowledged.
What does the ONE consistency level mean in Cassandra?
Show answerOnly one replica must respond for the operation to be acknowledged.
What does the QUORUM consistency level mean in Cassandra?
Show answerA majority (more than half) of replicas must respond for the operation to be acknowledged.
What does the ALL consistency level mean in Cassandra?
Show answerAll replicas must respond for the operation to be acknowledged.
How does stricter consistency affect performance in Cassandra?
Show answerStricter consistency (more replicas required) increases latency but reduces staleness.

20 more cards in the app

Study this set free