NoSQL
databases are designed to expand _.
Horizontally
Horizontal scaling approach tends to be cheaper as the number of operations
and the size of the data increases.
True
Full-form of 'CRUD' is _.
Create-Read-Update-Delete
Limitations of RDBMS are .
Scalability/Database
design complexity
distributes different data across multiple servers.
Sharding
A Key-value store does not support Secondary Indexes
False
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 .
Maps/Sets/Counters
The RDBMS 'table' equivalent terminology in Riak is
bucket
Cassandra allows to define composite Primary Keys.
True
In Cassandra, the ___ determines how many copies of the data will be
maintained across multiple nodes.
Replication factor
In a column-database a row is being uniquely identified by __.
Row-key
In column-oriented stores, data is stored on a basis.
Column Family
The column store has to perform _ IO to insert a new
value.
as many disk blocks
A column-database used to store __ versions of each cells.
Latest / Multiple
In a columnar database, the columns are stored together on disk, achieving
a higher compression ratio is an expensive operation.
False
Columnar databases are preferable for OLTP systems.
False
In Hbase, 'Columns' are named and specified in table definition.
False
The row store needs to perform _ IO to insert a new value.
Single
Hbase main server components include all except _.
Hbase Memstore
Pre-join projection is equivalent to as in traditional relational systems.
Materialized view
HBase Tables are divided _ by row key range into .
horizontally,
HDFS Files / horizontally, region servers
The MATCH clause is roughly equivalent to the clause in SQL and the
RETURN clause to a _ clause.
Where, Select
An RDBMS equivalent component for a "document identifier" in a
Document database:
Foreign Key
An RDBMS equivalent component for a "collection" in a Document
database:
Table
In MongoDB, there is a similar feature of 'like' expression as like RDBMS.
False
Document databases split a document into its constituent name/value pairs
for indexing purpose.
False
JSON documents are built up of _
All the options
______ is a syntax for
retrieving specific elements from an XML document.
Xpath
An RDBMS equivalent component for a "document" in a Document
database:
Row
MongoDB read/write performance can be tuned with the help of Stored
Procedures
False
The major components of a Graph include all except _.
JSON
Graph databases are generally built for use with .
OLTP
Cypher query language is associated with __
Neo4j
Only Nodes have properties in Graph database.
False
Neo4j architecture is a self-driven and independent architecture because of
__.
Both the options
Transactional integrity is relevant in case of batch-centric Hadoop-based
analytics on warehoused data.
True
Read overhead in a Columnar database can be partly reduced by Multicolumn
projection and _.
Sorted Column
Wiredtiger storage engine is a part of ___.
MongoDB
Sorted Column store would provide higher compression ratio by representing
each column as compared to the preceding one.
Delta
In case of a Strict consistency, a read will
always return the most recent data value.
False
The equivalent Hbase structure of an
in-memory tree in Log-structured Merge Trees is __.
MemStore
Cassandra's Gossip Protocol can take care of
the heartbeat lost due to _ in a widely distributed system.
Both node failure and network issue
Riak demonstrates dual nature of _.
Key/value Store and Document Database
Like most relational databases, Kudu also offers secondary indexes and
uniqueness constraints.
False
In case of an Eventual consistency, reads may
not return the most recent value, but reads will not return values “out of
sequence.”
False
Cassandra lightweight transactions (LWT)
supports pattern.
Check-and-set
Kudu can be accessed via all except _.
Apache Hive
Comments
Post a Comment