Cassandra Query Language by Examples - Puzzles with Answers

This book contains two original and high-quality practice tests of 50 questions each. They will help you learn and/or better understand Apache Cassandra, especially its CQL (Cassandra Query Language).

• Each practice test has 50 questions. For more challenge, time them up for 60 minutes, and consider a 80% passing score.

• Domains: Data Modeling, Data Definition, Data Types, Data Search, Data Modification, Functions, CQL Shell, Performance, Security.

• Almost every question offers 3-4 choices. Most questions are single-select, a few with variable multi-selections.

• Every question is unique and original, elaborated, meant to teach you something essential, with no waste of time.

• Detailed explanations with external references for any possible choice, in each practice test question.

• Reference links to relevant pages from the Apache Cassandra Documentation, DataStax documentation, StackOverflow questions.

• While this will also help you pass DataStax certifications exams, the questions here may be very different from the exams.

• Search by title for the same e-book as LIVE practice tests on Udemy.

What you will learn or better understand

• How to properly design tables in CQL. Data modeling with Chebotko diagrams and proper key choices.

• How to properly query Cassandra tables without paying a price in performance.

• How to properly use the partition, clustering or primary keys, in WHERE and ORDER BY clauses.

• When and what keys you may skip in a filter expression or in an explicit query sort order.

• When to create a new denormalized table, secondary index or materialized view.

• Major differences between SQL and CQL, with plenty of examples.

• How to avoid traps, gotcha situations, hidden issues you may not know about.

• What the mysterious TTL actually does. When whole rows may suddenly disappear or not.