Cassandra Query Language by Examples - Puzzles with Answers - E-book - ePub

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.