Apache Cassandra Quiz
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
1. Cassandra is a
Centralized database
Distributed database
Scalable database
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 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.
{"name":"Apache Cassandra Quiz", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"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 questionsInstant feedback on your answersPerfect for developers, data engineers, and database administrators","img":"https:/images/course4.png"}