Cassandra Query Language by Examples

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.