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, ... Read More

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 Read Less