
Cassandra Query Language by Examples: Puzzles with Answers
Included in This Course
- Practice Test #1 (Cassandra Query Language)50 questions
- Practice Test #2 (Cassandra Query Language)50 questions
Description
TWO original and high-quality practice tests of 50 questions each must help you learn and/or better understand Apache Cassandra, especially its CQL (Cassandra Query Language):
Each practice test has 50 questions. To challenge you, we timed them for 60 minutes, with a 80% passing score.
Domains: Data Modeling, Data Definition, Data Types, Data Search, Data Modification, Functions, CQL Shell, Performance, Security.
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.
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.
How should I use these tests?
Try first practice test. And do not worry about the time or if you fail. You are expected to fail, this is how you learn...
Stop the exam anytime, if you're not patient enough to go over all 50 questions.
Once done, you get your total score, plus per domain.
Click Review Questions and scroll down to both the right and wrong choices for each individual question.
Read the detailed Explanation for each question.
Repeat with the second practice test.
Repeat these tests again and again, until you score at least 90% on each.
"Cassandra Query Language by Examples: Puzzles with Answers" is also available as a Kindle ebook, on Amazon.
Who this course is for:
- Cassandra developers who want to master the CQL and know more about the product overall
- Those preparing for DataStax professional certification exams
- Database practitioners who want to better understand why and how CQL is different from SQL
- All those puzzled and a bit confused by the partition and clustering keys in Cassandra
- All those baffled by the different query-first approach of the Cassandra data modeling
Instructor
Decades of practical experience in software design and implementation. Former Microsoft employee. Architect of the Data Xtractor Suite - with a visual SQL editor, data visualization charts, data modeling... Former assistant professor at the "Polytechnica" University of Bucharest.
I live in beautiful Vancouver/Canada. The mountain is my backyard, and the sea delights me with her horizons. I enjoy tennis and hiking...