CASSANDRA CQL and Data Modeling

Question 1

What CQL statement is used to create a new keyspace in Cassandra?

Accepted Answer

CREATE KEYSPACE

Answer

CREATE DATABASE

Answer

CREATE SCHEMA

Answer

CREATE NAMESPACE

Question 2

What is the difference between a partition key and a clustering key in a Cassandra primary key?

Accepted Answer

The partition key determines data distribution; clustering keys determine sort order within a partition

Answer

There is no difference; they are synonyms

Answer

The clustering key determines which node stores data; the partition key sorts rows

Answer

The partition key is optional; the clustering key is mandatory

Question 3

Which CQL clause restricts the result set of a SELECT query to a specific partition?

Accepted Answer

WHERE partition_key = value

Answer

GROUP BY

Answer

LIMIT

Answer

ORDER BY

Question 4

What does the TTL (Time To Live) option do when inserting data in Cassandra?

Accepted Answer

Automatically deletes the data after the specified number of seconds

Answer

Sets a timeout for the write operation

Answer

Limits the number of reads before expiry

Answer

Reserves space in the MemTable

Question 5

What is a 'materialized view' in Cassandra?

Accepted Answer

A read-only cached copy of a base table with a different primary key for alternate access patterns

Answer

A writable denormalized copy of a table managed by the user

Answer

A view stored in memory only, not persisted to disk

Answer

A cross-keyspace join of two tables

Question 6

Which CQL data type should be used to store a universally unique identifier in Cassandra?

Accepted Answer

UUID or TIMEUUID

Answer

TEXT

Answer

BIGINT

Answer

BLOB