Category Archives: Cassandra

Apache Cassandra Certification

Mock up test of Cassandra certification.The same mock up is also provided in Data stax site also.

Apache Cassandra Certification has been released on September 22 brought to you by Data Stax and O’Reilly. They are providing various level of certifications.
1.Developer (DS201 and DS220)
2.Administrator (DS201 and DS210)
3.Architect (DS201 , DS210 and DS220)
For more you can visit Data stax web site.

Tombstones are ___________________.


Given the following table, which of the following statements is an example of Data Modification Language (DML) in CQL?

CREATE TABLE comics ( title text, issueNumber int, originalPriceDollars float, PRIMARY KEY ( title, issueNumber ) );


An application tracks a user’s habits. Every time a user clicks a link on a page within your site, the time of the event is recorded as well as the link clicked. In order to write an efficient query, all data must be stored in a single partition. Which of the following tables best models the needs of the application?


Compaction does NOT do which of the following?


Which of these Cassandra technologies work together to keep track of the cluster data center and rack topology? Choose all that apply.


When defining a table in Apache Cassandra, a _________________ must be defined


You have designed a query to return all users by a designated state and designated age from a table holding all user information. Which approach is best for efficient queries like this?


Apache Cassandra achieves high availability by____________?


The main function of a keyspace is to control ___________________.


The CAP theorem states that only two out of three characteristics can be met by a distributed database system simultaneously. Which of the two characteristics does Apache Cassandra value most? Choose 2


Apache Cassandra can be downloaded in which formats, including DataStax Community variants? Choose all that apply


In a Cassandra instance, a table called Orders holds order information. Each time an order is placed, an entry must also be placed in a denormalized table OrdersByCustomer to keep track of order history per customer. How does Cassandra handle this?


Given the following table from a physical data model, what are the most likely  choices for missing data types for the avg_rating, category, and amount_ingredient, in that order?

receipe_name Text

avg_rating  ?

prpe_time INT

cook_time INT

directions TEXT

category ?

amount_ ingredient ?


What does the gossip protocol do?


Durability is the property that ensures that all written data is the same on all nodes that it is written to.


Which of the following is not true for Apache Cassandra?


Which of the following statements about writes is incorrect?


Which of the following is a valid Cassandra data type?


Clients should have ________________ so that the column values will replace older values based on their timestamp.


An SSTable is immutable, meaning that it cannot be modified.