Cassandra MCQ (Quiz) : W3Schools, Tutorials Point

1 .

Who developed Cassandra?

A)

Google

B)

Apple

C)

Microsoft

D)

Facebook

Correct Answer : Facebook

Explanation : Apache Cassandra was developed by Avinash Lakshman and Prashant Malik when both were working as engineers at Facebook. The database was designed to power Facebook's inbox search feature, making it easy for users to quickly find the conversations and other content they were looking for.

2 .

When the Initial release date of Cassandra?

A)

July 2008

B)

July 2007

C)

July 2006

D)

July 2005

Correct Answer : July 2008

Explanation :

Avinash Lakshman, one of the authors of Amazon's Dynamo, and Prashant Malik initially developed Cassandra at Facebook to power the Facebook inbox search feature. Facebook released Cassandra as an open-source project on Google code in July 2008. In March 2009 it became an Apache Incubator project. On February 17, 2010 it graduated to a top-level project.

Facebook developers named their database after the Trojan mythological prophet Cassandra, with classical allusions to a curse on an oracle.

3 .

Which of the following is true about Apache Cassandra?

A)

Apache Cassandra is a distributed

B)

Apache Cassandra has wide column store

C)

Apache Cassandra is a free and open-source

D)

All of the above

Correct Answer : Apache Cassandra is a free and open-source

4 .

By default, Cassandra uses __________ for cluster communication.

A)

9000

B)

7000

C)

5000

D)

3000

Correct Answer : 7000

Explanation : By default, Cassandra uses 7000 for cluster communication (7001 if SSL is enabled), 9042 for native protocol clients, and 7199 for JMX.

5 .

Which of the following API is used for Column Families and Tables in Cassandra?

A)

Column Family-CQL API ;Table-CQL API

B)

Column Family-CQL API ;Table-Thrift API

C)

Column Family-Thrift API ;Table-CQL API

D)

Column Family-Thrift API ;Table-Thrift API

Correct Answer : Column Family-CQL API ;Table-Thrift API

6 .

User cannot set Durable_Writies property with which one of the following?

A)

CQLSH

B)

Replication

C)

Simple Strategy

D)

Network Topology Strategy

Correct Answer : Simple Strategy

7 .

Which of them is a place where data is stored?

A)

Node

B)

SSTable

C)

Data center

D)

Bloom filter

Correct Answer : Node

Explanation : It is the place where data is stored.

8 .

What is CQL stands for?

A)

Commit Query Language

B)

Cluster Query Language

C)

Component Query Language

D)

Cassandra Query Language

Correct Answer : Cassandra Query Language

Explanation : Users can access Cassandra through its nodes using Cassandra Query Language (CQL).

9 .

Which method builds the cluster with the given contact points?

A)

Cluster build()

B)

Session connect()

C)

ResultSet execute()

D)

Cluster.Builder addContactPoint()

Correct Answer : Cluster build()

Explanation : Cluster build() : This method builds the cluster with the given contact points.

10 .

Apache Cassandra is a massively scalable open source _______ database.

A)

SQL

B)

NoSQL

C)

NewSQL

D)

All of the above

Correct Answer : NoSQL

Explanation : Cassandra is perfect for managing large amounts of data across multiple data centers and the cloud.

11 .

Cassandra uses a protocol called _______ to discover location and state information.

A)

gossip

B)

goss

C)

intergos

D)

All of the above

Correct Answer : gossip

Explanation : Gossip is used for internode communication.

12 .

A __________ determines which data centers and racks nodes belong to it.

A)

Snitch

B)

Partitioner

C)

Client requests

D)

None of the above

Correct Answer : Snitch

Explanation : Client read or write requests can be sent to any node in the cluster because all nodes in Cassandra are peers.

13 .

A __________ is a special column, therefore, it is also a key-value pair, but it stores a map of sub-columns.

A)

column

B)

sub column

C)

key column

D)

super column

Correct Answer : super column

Explanation : A super column is a special column, therefore, it is also a key-value pair. But a super column stores a map of sub-columns.

14 .

Which method used to close the cluster instance?

A)

close()

B)

void close()

C)

data close()

D)

cassendra close()

Correct Answer : void close()

Explanation : void close() : It is used to close the cluster instance.

15 .

Cassandra has peer-to-peer distributed system across its nodes.

A)

True

B)

False

C)

Can not say

D)

--

Correct Answer : True

Explanation : Cassandra has peer-to-peer distributed system across its nodes, and data is distributed among all the nodes in a cluster.

16 .

Programming language used in Cassandra?

A)

C

B)

C++

C)

Java

D)

.Net

Correct Answer : Java

17 .

Primary key in a keyspace is a ____.

A)

Row

B)

Column

C)

Data

D)

Column family

Correct Answer : Column

18 .

Which of the following is the command to run the queries in CQLSH.

A)

execute()

B)

run()

C)

run query()

D)

execute query()

Correct Answer : execute()

19 .

Which database is best suitable for handling data in small volumes.

A)

NoSQL database

B)

Relational database

C)

Both (A) and (B)

D)

None of the above

Correct Answer : Relational database

20 .

Which of the following is not a part of Cassandra architecture?

A)

MemTable

B)

Commit log

C)

Column

D)

Bloom Filter

Correct Answer : Column

21 .

What is the main pre-requisite for Cassandra?

A)

CQLSH

B)

Memory

C)

Windows OS

D)

Java

Correct Answer : Java

22 .

Which among the following is a shell command in CQLSH?

A)

Color

B)

Insert

C)

Consistency

D)

Create Index

Correct Answer : Color

23 .

How can a user create a cluster in Cassandra?

A)

Create Cluster

B)

Cluster build()

C)

Cluster.builder()

D)

None of the above

Correct Answer : Cluster.builder()

24 .

Which of the following are Features of Cassandra?

A)

Elastic scalability

B)

Flexible data storage

C)

Easy data distribution

D)

All of the above

Correct Answer : All of the above

25 .

Cassandra uses the ________ in the background to allow the nodes to communicate with each other and detect any faulty nodes in the cluster.

A)

Mem Protocol

B)

Gossip Protocol

C)

Talk Protocol

D)

Commit Protocol

Correct Answer : Gossip Protocol

26 .

Which of them is a memory-resident data structure?

A)

SSTable

B)

Mem-table

C)

Data center

D)

Bloom filter

Correct Answer : Mem-table

Explanation : Mem-table : A mem-table is a memory-resident data structure. After commit log, the data will be written to the mem-table. Sometimes, for a single-column family, there will be multiple mem-tables.

27 .

Which of the following is the command for verification of the operation?

A)

Check

B)

Clear

C)

Verify

D)

Describe

Correct Answer : Describe

28 .

What command is used to delete all the rows in a table?

A)

Truncate

B)

Drop

C)

Clear

D)

Delete

Correct Answer : Truncate

29 .

What command is used to delete the table?

A)

Clear

B)

Delete

C)

Drop

D)

Truncate

Correct Answer : Drop

30 .

Which of the following attribute can be used to execute a statement repeatedly?

A)

Index

B)

Repeat

C)

Batch

D)

Copy Paste

Correct Answer : Batch

31 .

What type of lines can be executed in Cassandra?

A)

Statement

B)

Query

C)

Both (A) and (B)

D)

None of the above

Correct Answer : Both (A) and (B)

32 .

___________ is the outermost container for data in Cassandra.

A)

Keyspace

B)

network

C)

topology

D)

replication

Correct Answer : Keyspace

33 .

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

A)

Hive

B)

Cassandra

C)

Sqoop

D)

None of the above

Correct Answer : Cassandra

34 .

Authorization capabilities for Cassandra use the familiar _________ security paradigm to manage object permissions.

A)

GRANT

B)

COMMIT

C)

ROLLBACK

D)

None of the above

Correct Answer : GRANT

Explanation : Once authenticated into a database cluster using either internal authentication, the next security issue to be tackled is permission management.

35 .

Client-to-node encryption protects data in flight from client machines to a database cluster using ___________

A)

SSH

B)

SSM

C)

SSN

D)

SSL

Correct Answer : SSL

Explanation : Client-to-node encryption establishes a secure channel between the client and the coordinator node.

36 .

Which of the following is a unit of replication in Cassandra?

A)

Row

B)

Column

C)

Both A and B

D)

None of the above

Correct Answer : Row

Explanation : Row is a unit of replication in Cassandra and Column is a unit of storage in Cassandra.

37 .

Which of the following data type is NOT used for numerical inputs?

A)

float

B)

variant

C)

boolean

D)

counter

Correct Answer : boolean

38 .

Which of the following is NOT of significance for monitoring of Cassandra?

A)

Table Statistics

B)

Column data metrics

C)

Cluster Statistics

D)

Compaction Metrics

Correct Answer : Column data metrics

39 .

Which of the tools is used to view the statistics of a table?

A)

JConsole

B)

Nodetool

C)

GossipStage

D)

Compaction Executor

Correct Answer : Nodetool

40 .

Project of Cassandra was taken by which of the following developer?

A)

Amazon

B)

Facebook

C)

Google

D)

Apache

Correct Answer : Apache

41 .

Which of the following is NOT a property of Cassandra?

A)

ACID operations

B)

Simple Transactions

C)

Decentralized deployments

D)

Supports every type of data

Correct Answer : ACID operations

42 .

In which of the following data type order of the element entered is maintained?

A)

Set

B)

Map

C)

List

D)

None of the above

Correct Answer : List

43 .

Which of the following of the data types is used to create data types of our own?

A)

Collection data types

B)

User-defined data types

C)

Both (A) and (B)

D)

None of the above

Correct Answer : User-defined data types

44 .

If there are no syntax errors, how can there be an error in Cassandra?

A)

Changes in system

B)

Changes in cluster

C)

Changes in version

D)

All of the above

Correct Answer : All of the above

45 .

Internal authentication stores usernames and bcrypt-hashed passwords in the ____________ table.

A)

system_auth.creds

B)

system.credentials

C)

sys_auth.credentials

D)

system_auth.credentials

Correct Answer : system_auth.credentials

Explanation : Password Authenticator is an IAuthenticator implementation that you can use to configure Cassandra for internal authentication out-of-the-box.

46 .

Which of the following decides the distribution of data in a cluster?

A)

Partitioner

B)

Compaction

C)

Commit log

D)

Gossip Protocol

Correct Answer : Partitioner

47 .

Using ___________ file means you don’t have to override the SSL_CERTFILE environmental variables every time.

A)

cqshrc

B)

qlshrc

C)

cqlshrc

D)

None of the above

Correct Answer : cqlshrc

Explanation : cqlsh is used with SSL encryption.

Cassandra MCQs with Answers