Cassandra Brass Tacks | Fresco Play

Question 1: Continuous uptime and low latency is achieved in NoSQL systems as compared to traditional relational databases.

Answer: Yes

Question 2: Which of the following statements about NoSQL databases is true?

Answer: Support unstructured data

Question 3: What is meant by 'Active everywhere design'?

Answer: All nodes can be written to and read from

Question 4: Which among the following is a NoSQL db?

Answer: All of the options mentioned

Question 5: Cassandra is not suitable for IoT applications.

Answer: False

Question 6: Cassandra is a __________ architecture.

Answer: peer-to-peer

Question 7: Which type of data model does Cassandra use?

Answer: Both key-value and tabular data models

Question 8: Which command can be used to list all available commands/operations in Cassandra?

Answer: HELP

Question 9: What are ‘seed nodes’ in Apache Cassandra?

Answer: All of the options mentioned

Question 10: A bloom filter can return __________.

Answer: A false positive

Question 11: Which Linux flavour can be used for Cassandra Installation?

Answer: All of the options mentioned

Question 12: Cluster can have multiple seed nodes.

Answer: True

Question 13: SSTable resides in memory.

Answer: False

Question 14: Java instance should be running in the machine inorder to setup Cassandra.

Answer: Yes, java must be running in the machine

Question 15: What is C-A-P, in CAP theorem?

Answer: 1) Consistency 2) Availability and 3) Partition tolerance

Question 16: What is the default partitioner in Apache Cassandra cluster?

Answer: Murmur3Partitioner

Question 17: Pick the correct statements.

Answer: All of the options mentioned

Question 18: Cassandra attaches a timestamp to each version of the record and uses this to merge records .

Answer: Yes

Question 19: The simplest and the fastest read path is when the record is present in the __________.

Answer: Row Cache

Question 20: Authorization capabilities for Cassandra use the familiar__________ security paradigm to manage object permissions.

Answer: GRANT

Question 21: Row cache is an in-memory cache, which stores recently read rows.

Answer: True

Question 22: To be able to read data from compressed blocks, Cassandra consults __________.

Answer: Compression offsets

Question 23: Keyspace is analogous to __________ in realtional world.

Answer: database

Question 24: Which among the following is not a Replica Placement strategy?

Answer: None of the options mentioned

Question 25: Is Timestamp an optional field in Column?

Answer: True

Question 26: Pick the correct statement.

Answer: Each keyspace has at least one and often many column families

Question 27: Which among the following is the right syntax for 'Using a Keyspace'?

Answer: USE

Question 28: Which of the following statements is true about CQL?

Answer: All of the options mentioned

Question 29: Defining a primary key is mandatory while creating a table.

Answer: True

Question 30: Which Linux flavour can be used for Cassandra Installation?

Answer: All of the options mentioned

Question 31: What is the primary language for communicating with the Apache Cassandra™ database?

Answer: CQL

Question 32: Pick the correct statement.

Answer: All of the options mentioned

Question 33: Which directory contains Cassandra configuration files?

Answer: conf

Question 34: Cassandra will keep appending the records into the Commit Log and then to the memtable.

Answer: True

Question 35: How does Murmur3Partitioner work?

Answer: Fast hash-based partitioner

Question 36: Partitioners supported by Cassandra are __________.

Answer: All of the options mentioned

Question 37: Which collection type in Cassandra is dictionary like object?

Answer: Map

Question 38: Which OS does Cassandra support?

Answer: Both Windows and Linux

Question 39: Protocol for communicating timeout info among nodes is __________.

Answer: NTP

Question 40: What can be used to monitor clock drifts?

Answer: NTP

Question 41: The process of turning a Memtable into a SSTable is called

Answer: Flushing

Question 42: What can also be attributed as wide-row in Apache Cassandra?

Answer: Compound Key

Question 43: What is the critical bottleneck faced during creation of data model?

Answer: Hot Spots

Question 44: User accounts may be altered and dropped using the __________ Query Language.

Answer: Cassandra

Question 45: Which among the following is not a performance measurement tool?

Answer: None

Question 46: Partitioned data in Cassandra can be looked up using __________.

Answer: Key-space

Question 47: Which technique is used for error correction for every compressed block?

Answer: CRC

Question 48: Each flush of the memtable results in the creation of __________.

Answer: Sstable

Question 49: A cluster is __________.

Answer: A collection of data centers

Question 50: Minimum JVM version required for Cassandra is __________.

Answer: 1.6

Question 51: Replication can be configured to work across __________.

Answer: one or more Data Centers

Question 52: In Cassandra, data is first written to __________.

Answer: Commit Log and Memtable

Question 53: What is the use of commit log?

Answer: Crash-recovery

Question 54: Primary key is a column that is used to uniquely identify a row.

Answer: True

Question 55: __________ is a collection of related nodes.

Answer: Data center

Question 56: In cassandra consistency is achieved through consistency tuning mechanisms.

Answer: True

Question 57: How does Cassandra store data?

Answer: By dividing all data evenly around a cluster of nodes, which can be visualized as a ring

Question 58: CQL features include __________.

Answer: All of the options mentioned

Question 59: Which of the statements are true?

Answer: All of the options mentioned

Question 60: Which of the following statements is true?

Answer: All of the options mentioned

Question 61: NoSQL db - Cassandra is of type __________.

Answer: Wide-column stores

Question 62: Which collection type is used to maintain uniqueness of data structure?

Answer: Set

Question 63: Cassandra supports ACID transactions?

Answer: False

Question 64: Cassandra promotes __________ operation.

Answer: Read-before-write

Question 65: Which of the following is not part of SSTable?

Answer: Memtable

Question 66: There are __________ types of read requests that a coordinator can send to a replica.

Answer: 3

Question 67: What percentage is the default threshold of memory used for flushing of the largest Memtables?

Answer: 65

Question 68: __________ can be configured per table for non-QUORUM consistency levels.

Answer: Read repair