Browse LATEST Cassandra Interview Questions & Answer [ 2020 ]
Cassandra Interview Questions and Answers

Browse LATEST Cassandra Interview Questions & Answer

Last updated on 03rd Jul 2020, Blog, Interview Questions

About author

Kannan (Lead Data Engineer - Cassandra )

He is a Proficient Technical Expert for Respective Industry Domain & Serving 10+ Years. Also, Dedicated to Imparts the Informative Knowledge's to Freshers. He Share's this Blogs for us.

(5.0) | 16547 Ratings 711

These Apache Cassandra Interview Questions have been designed specially to get you acquainted with the nature of questions you may encounter during your interview for the subject of Apache Cassandra . As per my experience good interviewers hardly plan to ask any particular question during your interview, normally questions start with some basic concept of the subject and later they continue based on further discussion and what you answer.we are going to cover top Apache Cassandra  Interview questions along with their detailed answers. We will be covering Apache Cassandra  scenario based interview questions, Apache Cassandra  interview questions for freshers as well as Apache Cassandra  interview questions and answers for experienced. 

1) Why is Apache Cassandra developed? 


Cassandra is a distributed database management system. It is initially developed at Facebook to improve its performance, and it is a tool made to power the Facebook inbox search feature. Due to its outstanding technical features, Cassandra became very popular and a top-level project.

2) What is Apache Cassandra?


Cassandra is an open-source, distributed and decentralized database. It is also used for managing a large amount of structured data which is spread out everywhere. 

3) Describe the benefits of using Cassandra?


Cassandra has features which are very beneficial as it is easy to work with; Some of those are high performance, fault tolerance, predictable scaling, distributed database. It has high scores on these parameters, and it is also preferred because its an open-source distributed and NoSQL database management system.

4) What are the applications of Cassandra?


  • Cassandra has become the primary choice for many companies when it comes to app development and data management. Even new start-ups are preferring it because of the ease with which an operator can work.
  • Cassandra is a great application where data is collected at high speed from different kinds of sources. As the internet of things application could use Cassandra. It could also be used in a product and retail apps, messaging, social media analytics, and even by a recommendation engine.

5) Explain Apache Cassandra vs Traditional Databases


Although traditional databases provide you with many other features here are some highlights and benefits only a database like Cassandra have:

S.No Traditional databases Cassandra database
Data is written in mostly one location. Data is written in many locations.
Data volumes are moderate. Processing data volumes are high.
It can handle only moderate incoming data. It can handle high incoming data volumes.
Supports complex transactions Supports simple transactions.
Lines up for just read scalability. Supports both read and write scalability.

6) Name the features of Cassandra.


Cassandra has become famous for its outstanding technical features. Here are some features you must know:

  • Elastic scalability
  • Always on architecture
  • Fast linear and scale performance
  • Flexible in data storage
  • Easy to do data distribution
  •  Excellent transaction support.

7) What are the main components of Cassandra?


The components of Cassandra include:

  • Node
  • Data cluster
  • Commit log
  • Cluster
  • Meme-table
  • SSTable 
  • Bloom filter

8) What are the functions of Cassandra?


Ans: This database supports two main categories of functions:

  • Scalar functions: Its primary purpose is taking some groups of values and producing an output with it. 
  • Aggregate functions: Its primary function is producing a combined result using selected multiple rows.

9) What are the key terms in Cassandra?


They go as follows:

  • Nodes
  • Data centre
  • Rack
  • Cluster
  • Commit log
  • SSTable
  • MemTable
  • Replication

10) What is a node?


  • A node is a basic unit of Cassandra, and it is a system which is part of a cluster. Node is the main area where the data is stored. 
  • And the units of a node is represented as computer/server

11) What is the data centre?


A data centre is a collection of Cassandra nodes.The data in a datacenter is stored in the form of a cluster, where the cluster is also referred to as a collection of nodes.

12) Describe what is memtable?


  • MemTable is a location where data is written and stored temporarily. Data is written in memtable after the data is completed in the commit log.
  • Memtable is a storage engine in Cassandra. Data in MemTable is classified into a key, and where the data is retrieved using the key as each column category has its own MemTable. When the write memory is full, it deletes the messages automatically.

13) What is SSTable?


SSTable also means ‘Sorted String Table’. SSTable is a data file in Cassandra, and its main function is to save data which is flushed from memtable. Unlike MemTable, SSTbale doesn’t delete any data or lets any further addition once data is written. 

14) What is the difference between memtable and SSTable?


  • In MemTable it doesn’t store the data. It temporarily accumulates ‘write data’, but it cannot store it into the disk.
  • Whereas in SStable, it is used to store the data from Memtable into Cassandra database. The data stored in SSTable is permanent and cannot be changed. 

    Subscribe For Free Demo

    15) How is data distribution done?


    Cassandra database is a highly-available database, and it stores data by evenly dividing the data around its nodes. For this, it uses the Murmur3 partitioning function to distribute given data in nodes evenly. 

    16) How does Cassandra store data?


    The data storage path in Cassandra begins with the memtable where the data is stored temporarily and is also called a commit log. And once committed, the data is periodically flushed and written into SSTable 

    17) What are the general operations of Cassandra CQL?


    There are two types of operations carried  by Cassandra:

    • Read operation and
    • Write operation

    18) What is a direct request?


    Direct request in Cassandra is a part of the read operation. In this, the coordinator node contacts the replica node.

    19) Define digest request?


    When the coordinator node contacts replicas, it actually requests those nodes which reply fastest. Then these contacted nodes respond with a digest of the data required.

    20) Explain read repair request?


    When the coordinator node sends requests, it checks in the nodes for any outdated data. This data is sent for a background read and repair and is replaced with the updated data. Read and repair requests, is a method to keep the data updated, and it also makes sure that the requested row is consistent on all replicas. 

    21) What is a write operation?


    There are step by step operations in writing, which goes as follows. 

    • Step1: It is as soon as it receives its request it sends the data to the commit log to save the data.
    • Step2: Data is inserted upon request and then sent to commit log to save data. 
    • Step3: If the memtable reaches its limit then data is flushed to SSTable.

    22) What is Cassandra: CAP Theorem?


    The CAP theorem, also knowns Brewer’s theorem, states that a distributed computer system can’t use all its three properties at the same time which are

    • Consistency, 
    • Availability,
    • Partition-tolerance.

    23) What do you mean by ACID?

    ACID stands for

    • Atomicity: Which means either your transaction can fail or commit
    • Consistency: Its definition changes from software to software or an application to application, but its general meaning is that data has to stay consistent.
    • Isolation: Data has to be isolated and separated from each other 
    • Durability: It assures you that once the database receives data, it should ensure that the data is processed. So it is an advantage if the database fails, then the data will not be lost.

    24) What is BASE?


    Not every application or software needs this strong consistency, so this is where base comes into action. The BASE stands for Basically Available Soft-state Eventually-consistent properties.NoSQL databases basically use these models.

    25) Explain, what is tunable consistency?


    Consistency refers to updating and synchronizing a row of Cassandra data in all of its replicas. By offering tunable consistency for a given operation (read/write), helps the application to decide the right consistency of data.

    Course Curriculum

    Learn Hands-on Experience from Cassandra Certification Training Course

    Weekday / Weekend BatchesSee Batch Details

    26) What is the relation between tunable consistency and Cassandra?


    Tunable consistency ensures proper levels of consistency for its reads and writes which is the main reason why Cassandra prefers NoSQL databases.

    27) What are the best monitor tools of Cassandra?


    Although Cassandra comes with built-in tolerance features, it still needs to be monitored for effective results. Here are some tools which Cassandra uses to monitor its databases:

    • Solarwind server and application monitor
    • Instana
    • Instaclustr
    • AppDynamics
    • Dynatrace
    • Machine engine applications manager.

    28) What is the NoSQL database?


    The primary purpose of usage of NoSQL databases is because it provides smooth handling of large data. Its simplicity of design and simplicity in horizontal scaling to clusters and fine control are few of the reasons why Cassandra uses a NoSQL database.

    29) What are the objectives of NoSQL?


    The primary objectives of NoSQL DB are:

    • To have the simplicity of design
    • More exceptional control over availability and 
    • Horizontal scaling

    30) Describe a bloom filter?


    A bloom filter is a tool used by Cassandra. The read path of Cassandra has to go through Memtable and the row cache. A bloom filter is a partition cache, and its role is the read path is to avoid checking every SStable to find one particular data.

    31) What is CQL?


    • Initially, Cassandra required an API to do some of the basic tasks like insert, get and delete. But over time, these basic queries were improved and then named Cassandra Query Language. (CQL).  
    • CQL provides a great set of built-in data types, and it also helps the applications to make their own custom data types. Cassandra is also classified as a NoSQL database.

    32) Name the key roles of CQL?


    It is very necessary to provide different types of users with different kinds of roles depending upon their requirements. It ensures the security of database users. and their key roles goes as follows:

    • Create a role
    • Alter role
    • Drop role
    • Grant role
    • Revoke role
    • List role

    33) What is a cluster in Cassandra?


    A cluster is a collection of nodes. This collection of nodes represents a single system. It is the outermost structure of the ring in Cassandra.

    34) What are CRUD operations?


    These operations are used to make changes in the Cassandra database.

    CRUD stands for 

    • Create operation
    • Read operation
    • Update operation and
    • Delete/drop operation.

    35) Describe Keyspace.


    A keyspace is a part of the cluster which controls the replication of the data in a database. A cluster contains one keyspace per node.

    36) Name the types of Keyspace in Cassandra?


    Cassandra keyspace contains 3 types of operations which go as follows:

    • Create keyspace
    • Alter keyspace
    • Drop keyspace

    37) Define column family in Cassandra?


    Column family in Cassandra is defined as the collection of rows in an ordered and systematic way. It is used to represent the stored data in a structured manner. These are contained in a keyspace, at least one column family in a keyspace

    38) What are the characteristics of a column family?


    There are many characteristics of a column family, and few of them goes as follows:

    • Key cached
    • Rows cached
    • Preload row cache

    39) Explain about the super column in Cassandra?


    • A super column in Cassandra is an extraordinary and important column. It has so much value because it has the roadmap to all the sub-columns in the database.
    • These super columns are used to improve the performance of the database
    • These are some important interview questions on Cassandra for beginners and experienced candidates. I hope these questions will help you get familiarise with the concepts and insights of Cassandra and help you prepare for the interviews as well. 

    40)  Define replication factor


    The data in a node undergoes replication. The data is copied from one node to another to ensure fault tolerance. The replication factor is the number of copies of the data that are sent to different nodes.

    Course Curriculum

    Enroll in Cassandra Training with Industry Oriented Modules from Expert Instructors

    • Instructor-led Sessions
    • Real-life Case Studies
    • Assignments
    Explore Curriculum

    41)  Define replication strategy.


    These strategies define the technique of how the replicas are placed in a cluster. There are mainly two types of Replication Strategy:

    • Simple strategy
    • Network Topology Strategy

    42)  Name some features of Apache Cassandra.


    Cassandra has following features:

    • High Scalability
    • High fault tolerant
    • Flexible Data storage
    • Easy data distribution
    • Tunable Consistency
    • Efficient Wires
    • Cassandra Query Language

    43)  Name different types of NoSQL database.


    There are four types of NoSQL Database:

    • Key Value Store type database
    • Document Store type database
    • Column STore type database
    • Graph Database

    44)  Define NoSQL Database.


    It is a database that deals with the non-relational database. It is referred to as a Not only SQL database. It provides a mechanism to store and retrieve the different type of data that includes images, sounds etc.

    45) Give key features of any NoSQL database.


    The features of NoSQL Database are:

    • Schema Agnostic
    • AutoSharding and Elasticity
    • Highly Distributable
    • Easily Scalable
    • Integrated Caching

    46) Define a column family.


    A keyspace contains many column families. They basically represent the table. Furthermore, it basically defines titles or application specific tables.

    47) Define Node.


    A node represents a system that is a part of a cluster. It is the main area in which data is stored.

    48)  Define data centre.


    Data centre consists of all the data that is contained in Cluster.

    49)  What is a Keyspace?


    Keyspace is the outermost storage unit in a node. It contains many column families.

    50)  Give the data storage units in Cassandra.


    The storage units are:

    • Cluster
    • Node
    • Keyspace
    • Column Family
    • Row
    • Column

    51)  Give the name of some components of Cassandra.


    Some components of Cassandra are:

    • Table
    • Node
    • Cluster
    • Data Centre
    • Memtable
    • SSTable
    • Commit log
    • Bloom Filter

    52)  Tell something about the query language used in Cassandra Database.


    Cassandra query language is used for Cassandra Database. It is an interface that a user uses to access the database. It basically is a communication medium. All the operations are carried out from this panel.

    53)  Give some advantages to Cassandra.


    These are the advantages if Cassandra:

    • Since data can be replicated to several nodes, Cassandra is fault tolerant.
    • Cassandra can handle a large set of data.
    • Cassandra provides high scalability.

    54)  Define Cassandra.


    Cassandra is a free and open source distributed database management system. It is used to handle a large amount of data with a high fault tolerance and high scalability.

    55)  Who developed Cassandra and in which language?


    Avinash Lakshman and Prashant Malik developed Cassandra using Java. Later Apache took it under it for further development.

    56)  What is the main objective of creating Cassandra?


    The main objective of Cassandra is to handle a large amount of data. Furthermore, the objective also ensures fault tolerance with the swift transfer of data.

    57)  Define data replication.


    Data replication is an operation in which data from one node is copied to different nodes in the cluster. This operation ensures redundancy and fault tolerance in the database. The replication factor decides the number of copies and the replication strategy decides the nodes in which the data is copied.

    58)  Define commit log.


    It is a mechanism that is used to recover data in case the database crashes. Every operation that is carried out is saved in the commit log. Using this the data can be recovered.

    59)  Define composite key.


    Composite keys include row key and column name. They are used to define column families with a concatenation of data of different types.

    Apache Spark Sample Resumes! Download & Edit, Get Noticed by Top Employers! Download

    60)  Define consistency.


    This is a technique to synchronize and update rows of Cassandra data and its replica.  

    61)  Name the types of tunable consistency.


    Cassandra support two types of consistencies:

    • Eventual Consistency
    • Strong Consistency

    62)  Describe Memtable.


    Memtables are basically a cache space containing content in key and column format.

    63)  Define SSTable.


    SSTable is a Sorted String Table. It is a data file that accepts regular Mem Tables.

    64)  Name the management tools in Cassandra.


    These are the management tools used in Cassandra.

    • DataStaxOpsCenter
    • SPM

    Are you looking training with Right Jobs?

    Contact Us
    Get Training Quote for Free