Sunday, August 27, 2023

NoSQL – Database Revolution Questions and Answers


NoSQL – Database Revolution Questions and Answers

Hbase main server components include all except _
Hbase Memstore – Correect

In column-oriented stores, data is stored on a basis.
Column Family – Correct

In Hbase, ‘Columns’ are named and specified in table definition.
Fales —— Correct

HBase Tables are divided _ by row key range into .
horizontally – regions ———– Correct

Columnar databases are preferable for OLTP systems.
False – Correct

Cassandra allows to define composite Primary Keys.
True – Correct

Pre-join projection is equivalent to as in traditional relational systems.
Materialized view – Correct

In a column-database a row is being uniquely identified by __.
Row-key – Correct

In Cassandra, the _ determines how many copies of the data will be maintained across multiple nodes.
Replication factor – Correct

The column store has to perform _ IO to insert a new value.
as many disk blocks —– Correct

The row store needs to perform _ IO to insert a new value.
Single — Correct

In a columnar database, the columns are stored together on disk, achieving a higher compression ratio is an expensive operation.
False —– Correct

A column-database used to store __ versions of each cells.
Multiple —– Correct

NoSQL databases are designed to expand _
horizontally — Correct

Horizontal scaling approach tends to be cheaper as the number of operations and the size of the data increases.
True — Correct

distributes different data across multiple servers.
Sharding — Correct

Limitations of RDBMS are .
Scalability/Database design complexity — Correct

Full-form of ‘CRUD’ is _.
Create-Read-Update-Delete — Correct

Key-value pair data storages include all except .
Network Attached Storage

Cassandra has properties of both and __
Google Bigtable / Amazon Dynamo

A Riak convergent replicated data type (CRDT) includes

A Key-value store does not support Secondary Indexes.

The RDBMS ‘table’ equivalent terminology in Riak is .

In MongoDB, there is a similar feature of ‘like’ expression as like RDBMS
False — Correct

The MATCH clause is roughly equivalent to the clause in SQL and the RETURN clause to a _ clause.
Where, Select —- Correct

__ is a syntax for retrieving specific elements from an XML document.
Xpath —- Correct

MongoDB read/write performance can be tuned with the help of Stored Procedures.
False — Correct

An RDBMS equivalent component for a “document identifier” in a Document database:
Foreign Key-value — Correct

An RDBMS equivalent component for a “document” in a Document database:
Row — Correct

Document databases split a document into its constituent name/value pairs for indexing purpose.
False —– Correct

An RDBMS equivalent component for a “collection” in a Document database:
Tables — Correct

JSON documents are built up of _.
Both the option — Correct

Only Nodes have properties in Graph database.
False — Correct

The major components of a Graph include all except _.
JSON — Correct

Cypher query language is associated with __
Neo4j — Correct

Neo4j architecture is a self-driven and independent architecture because of __
Both the options — Correct

Graph databases are generally built for use with .
OLTP — Correct

Hbase Data blocks metadata information are being maintained by _ .
NameNodes — Correct

Hbase Region assignment operation is being handled by _.
Hbase Master — Correct

In case of a Strict consistency, a read will always return the most recent data value.

Sorted Column store would provide higher compression ratio by representing each column as compared to the preceding one.
Delta — Correct

Some of the common Read Consistency level in Cassandra include all except __.

Some of the common Write Consistency level in Cassandra include all except _.

The equivalent Hbase structure of an in-memory tree in Log-structured Merge Trees is __.
Hfile —- Wrong

_ are replicated to allow failover in MongoDB.

Read overhead in a Columnar database can be partly reduced by Multicolumn projection and _.
Sorted Column — Wrong

In Cassandra, if the replication factor is 3, the coordinator will send replicas of the data item to the next _ nodes on the ring.
2 (n-1) — Correct

Wiredtiger storage engine is a part of _.
MongoDB — Correct

Kudu can be accessed via all except _.

The equivalent Hbase structure of an on-disk trees in Log-structured Merge Trees is _.

In case of an Eventual consistency, reads may not return the most recent value, but reads will not return values “out of sequence.”
Fales — Correct

Transactional integrity is relevant in case of batch-centric Hadoop-based analytics on warehoused data.
False — Correct

Riak demonstrates dual nature of
key/value store and a document database — Correct

Cassandra’s Gossip Protocol can take care of the heartbeat lost due to _ in a widely distributed system.
Both node failure and network issue — Correct

The process through which the on-disk tree files periodically merged to create larger consolidated stores is called __.
Compaction — Correct

In Risk, consistency model is implemented
Eventual — Correct

Like most relational databases, Kudu also offers secondary indexes and uniqueness constraints.
False — Correct

Hbase DDL Operations (create, delete tables) are maintained by _.
Hbase Master — Correct

Cassandra lightweight transactions (LWT) supports pattern.
Compare-and-set — Correct

No comments:

Post a Comment