Apache Cassandra Quiz

Create an image of a modern database architecture concept, featuring elements like distributed nodes, data columns, and a representation of Cassandra's structure, with a tech-inspired background.

Mastering Apache Cassandra Quiz

Test your knowledge of Apache Cassandra with this engaging quiz designed for database enthusiasts and practitioners. Whether you're a beginner or looking to sharpen your skills, this quiz will challenge your understanding of Cassandra's architecture, features, and usage.

9 thought-provoking questions
Instant feedback on your answers
Perfect for developers, data engineers, and database administrators

9 Questions2 MinutesCreated by QueryMaster247

1. Cassandra is a

Centralized database

Distributed database

Scalable database

None of the above

2. Cassandra’s orientation is :

Header

Row

Column

None of the above

3. A column family is an collection of :

Rows

Columns

Rings

None of the above

4. Super columns store :

Map of columns

Byte array value

Pointer to rings

None of the above

5. Which of these properties is not associated with Cassandra :

Partition tolerence

Soft-state

Scalability

Highly consistent

6. Which of the following techniques are used by Cassandra to distribute data :

Distributed hash table

Clustered Index

Consistent hashing

Map/Reduce

7. Which of the following techniques are used as a Writing Strategie in Cassandra :

Read Repair

Hinted Handoffs

Gossip

All of the above

8. Suppose we have the following schema :
CREATE TABLE Restaurant ( id INT, Name VARCHAR, borough VARCHAR, BuildingNum VARCHAR, Street VARCHAR, ZipCode INT, Phone text, CuisineType VARCHAR, PRIMARY KEY ( id ) );
CREATE INDEX fk_Restaurant_cuisine ON Restaurant ( CuisineType ) ;

CREATE TABLE Inspection ( idRestaurant INT, InspectionDate date, ViolationCode VARCHAR, ViolationDescription VARCHAR, CriticalFlag VARCHAR, Score INT, GRADE VARCHAR, PRIMARY KEY ( idRestaurant, InspectionDate ) ) ;

CREATE INDEX fk_Inspection_Restaurant ON Inspection ( Grade ) ;

What is the result of this request : SELECT Name FROM Restaurant WHERE borough='BROOKLYN' ;

The name of the restaurents in 'BROOKLYN'

Error from server: code=2200 [Invalid query]

None of the above

9. We want the names of the restaurants having at least an "A" grade in their inspections. Give the CQL query ?

This is not possible in CQL, because we can't join tables in cassandra. We can use spark for example to do this.

Apache Cassandra Quiz

Mastering Apache Cassandra Quiz

More Quizzes