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.

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?

 
 
 
 

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

 
 
 
 

Compaction does NOT do which of the following?

 
 
 
 

Which of the following statements about writes is incorrect?

 
 
 
 

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

 
 
 
 

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

 
 
 

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 ?

 
 
 
 

Apache Cassandra achieves high availability by____________?

 
 
 

Which of the following is a valid Cassandra data type?

 
 
 
 

Tombstones are ___________________.

 
 
 
 

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?

 
 
 
 

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

 
 
 
 

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

 
 

What does the gossip protocol do?

 
 
 

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 ) );

 
 
 
 

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?

 
 
 
 

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

 
 
 
 

Which of the following is not true for Apache Cassandra?

 
 
 

The main function of a keyspace is to control ___________________.

 
 
 
 

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