NoSQL - Database Revolution | Fresco Play

Question 1: Hbase main server components include all except _

Answer: Hbase Memstore

Question 2: In column-oriented stores, data is stored on a basis.

Answer: Column Family

Question 3: In Hbase, 'Columns' are named and specified in table definition.

Answer: False

Question 4: HBase Tables are divided _ by row key range into .

Answer: horizontally, regions

Question 5: Columnar databases are preferable for OLTP systems.

Answer: False

Question 6: Cassandra allows to define composite Primary Keys.

Answer: True

Question 7: Pre-join projection is equivalent to as in traditional relational systems.

Answer: Materialized view

Question 8: In a column-database a row is being uniquely identified by __.

Answer: Row-key

Question 9: In Cassandra, the ___ determines how many copies of the data will be maintained across multiple nodes.

Answer: Replication factor

Question 10: The column store has to perform _ IO to insert a new value.

Answer: as many disk blocks

Question 11: The row store needs to perform _ IO to insert a new value.

Answer: Single

Question 12: In a columnar database, the columns are stored together on disk, achieving a higher compression ratio is an expensive operation.

Answer: False

Question 13: A column-database used to store __ versions of each cells.

Answer: Multiple

Question 14: NoSQL databases are designed to expand _

Answer: horizontally

Question 15: Horizontal scaling approach tends to be cheaper as the number of operations and the size of the data increases.

Answer: True

Question 16: distributes different data across multiple servers.

Answer: Sharding

Question 17: Limitations of RDBMS are .

Answer: Scalability/Database design complexity

Question 18: Full-form of 'CRUD' is _.

Answer: Create-Read-Update-Delete

Question 19: Key-value pair data storages include all except .

Answer: Network Attached Storage

Question 20: Cassandra has properties of both and __

Answer: Google Bigtable/Amazon Dynamo

Question 21: A Riak convergent replicated data type (CRDT) includes

Answer: Maps/Sets/Counters

Question 22: A Key-value store does not support Secondary Indexes.

Answer: False

Question 23: The RDBMS 'table' equivalent terminology in Riak is .

Answer: bucket

Question 24: In MongoDB, there is a similar feature of 'like' expression as like RDBMS

Answer: False

Question 25: The MATCH clause is roughly equivalent to the clause in SQL and the RETURN clause to a _ clause.

Answer: Where, Select

Question 26: ______ is a syntax for retrieving specific elements from an XML document.

Answer: Xpath

Question 27: MongoDB read/write performance can be tuned with the help of Stored Procedures.

Answer: False

Question 28: An RDBMS equivalent component for a "document identifier" in a Document database:

Answer: Foreign Key

Question 29: An RDBMS equivalent component for a "document" in a Document database:

Answer: Row

Question 30: Document databases split a document into its constituent name/value pairs for indexing purpose.

Answer: False

Question 31: An RDBMS equivalent component for a "collection" in a Document database:

Answer: Table

Question 32: JSON documents are built up of _.

Answer: All the options

Question 33: Only Nodes have properties in Graph database.

Answer: False

Question 34: The major components of a Graph include all except _.

Answer: JSON

Question 35: Cypher query language is associated with __

Answer: Neo4j

Question 36: Neo4j architecture is a self-driven and independent architecture because of __

Answer: Both the options

Question 37: Graph databases are generally built for use with .

Answer: OLTP

Question 38: Hbase Data blocks metadata information are being maintained by _ .

Answer: NameNodes

Question 39: Hbase Region assignment operation is being handled by _.

Answer: Hbase Master

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

Answer: True

Question 41: Sorted Column store would provide higher compression ratio by representing each column as compared to the preceding one.

Answer: Delta

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

Answer: 1. ONE|TWO|THREE 2. All the options

Question 43: Some of the common Write Consistency level in Cassandra include all except ___.

Answer: ONE|TWO|THREE

Question 44: The equivalent Hbase structure of an in-memory tree in Log-structured Merge Trees is __.

Answer: MemStore

Question 45: _ are replicated to allow failover in MongoDB.

Answer: Shards

Question 46: Read overhead in a Columnar database can be partly reduced by Multicolumn projection and _.

Answer: Sorted Column

Question 47: In Cassandra, if the replication factor is 3, the coordinator will send replicas of the data item to the next _ nodes on the ring.

Answer: 3

Question 48: Wiredtiger storage engine is a part of ___.

Answer: MongoDB

Question 49: Kudu can be accessed via all except _.

Answer: Mapreduce

Question 50: The equivalent Hbase structure of an on-disk trees in Log-structured Merge Trees is ___.

Answer: StoreTable

Question 51: In case of an Eventual consistency, reads may not return the most recent value, but reads will not return values “out of sequence.”

Answer: False

Question 52: Transactional integrity is relevant in case of batch-centric Hadoop-based analytics on warehoused data.

Answer: False

Question 53: Riak demonstrates dual nature of

Answer: Key/value Store and Document Database

Question 54: Cassandra's Gossip Protocol can take care of the heartbeat lost due to _ in a widely distributed system.

Answer: Both node failure and network issue

Question 55: The process through which the on-disk tree files periodically merged to create larger consolidated stores is called __.

Answer: Compaction

Question 56: In Riak, consistency model is implemented

Answer: Eventual

Question 57: Like most relational databases, Kudu also offers secondary indexes and uniqueness constraints.

Answer: False

Question 58: Hbase DDL Operations (create, delete tables) are maintained by ___.

Answer: Hbase Master

Question 59: Cassandra lightweight transactions (LWT) supports pattern.

Answer: Compare-and-set

Question 60: In Cassandra, if the replication factor is 5, the coordinator will send replicas of the data item to the next _________ nodes on the ring.

Answer: 4