Question 4: Select correct statement which applies for CQL.

  1. CQL and SQL share the same abstract idea of a table constructed of columns and rows.
  2. Cassandra emphasizes denormalization through CQL features like collections and clustering specified at the schema level
  3. Cassandra does not support joins.
  4. Cassandra does not support subqueries.

 

  1. A, B, C
  2. B, C, D
  3. A, C, D
  4. A, B, C, D

Correct Answer: 4

Explanation: Cassandra Query Language (CQL) is the primary interface into the Cassandra DBMS. Using CQL is similar to using SQL (Structured Query Language). CQL and SQL share the same abstract idea of a table constructed of columns and rows. The main difference from SQL is that Cassandra does not support joins or subqueries. Instead, Cassandra emphasizes denormalization through CQL features like collections and clustering specified at the schema level.

CQL is the recommended way to interact with Cassandra. Performance and the simplicity of reading and using CQL is an advantage of modern Cassandra over older Cassandra APIs.