Prévia do material em texto

//*****TCS Internal*******
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 _.
https://www.coursehero.com/file/59623579/Done-NoSQL-Database-Revolution-QAtxt/
Th
is 
stu
dy
 re
so
ur
ce
 w
as
sh
are
d v
ia 
Co
ur
se
He
ro
.co
m
https://www.coursehero.com/file/59623579/Done-NoSQL-Database-Revolution-QAtxt/
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
Maps/Sets/Counters
A Key-value store does not support Secondary Indexes.
False
The RDBMS 'table' equivalent terminology in Riak is .
bucket
-----------------------------------------------------------------------------------
-----------------------------------------------------------
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 _.
https://www.coursehero.com/file/59623579/Done-NoSQL-Database-Revolution-QAtxt/
Th
is 
stu
dy
 re
so
ur
ce
 w
as
sh
are
d v
ia 
Co
ur
se
He
ro
.co
m
https://www.coursehero.com/file/59623579/Done-NoSQL-Database-Revolution-QAtxt/
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.
True
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 __.
ONE|TWO|THREE
Some of the common Write Consistency level in Cassandra include all except ___.
ONE|TWO|THREE -- Wrong
The equivalent Hbase structure of an in-memory tree in Log-structured Merge Trees 
is __.
Hfile ---- Wrong
_ are replicated to allow failover in MongoDB.
Shards
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 _.
Mapreduce
The equivalent Hbase structure of an on-disk trees in Log-structured Merge Trees is
___.
StoreTable 
https://www.coursehero.com/file/59623579/Done-NoSQL-Database-Revolution-QAtxt/
Th
is 
stu
dy
 re
so
ur
ce
 w
as
sh
are
d v
ia 
Co
ur
se
He
ro
.co
m
https://www.coursehero.com/file/59623579/Done-NoSQL-Database-Revolution-QAtxt/
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 Riak, 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
-----------------------------------------------------------------------------------
---------------------------------------------------------
Which type of scaling handles voluminous data by adding servers to the clusters?
Horizontal
__________ in Key-Value Databases are similar to 'Tables' in RDBMS
Keys
The scalability of Key-Value database is achieved through __________.
Peer to Peer Replication
Which among the following options is a challenge in the Master-Slave Replication 
model
(khud se )Write Resilience
Example(s) of Columnar Database is/are
Cassandra and HBase
NoSQL is a Relational Data Model.
(Khud se )False 
In the Master-Slave Replication model, different Slave Nodes contain
khud se Same data
In a Column Data Model, the number of columns that a row can have _ 
https://www.coursehero.com/file/59623579/Done-NoSQL-Database-Revolution-QAtxt/
Th
is 
stu
dy
 re
so
ur
ce
 w
as
sh
are
d v
ia 
Co
ur
se
He
ro
.co
m
https://www.coursehero.com/file/59623579/Done-NoSQL-Database-Revolution-QAtxt/Varies
CAP represents __________.
Consistency, Availability, Partition Tolerance
A Graph Store similar to OLAP in RDMS is __________.
Graph Compute Engine
The syntax for retrieving specific elements from an XML document is ________
XPath
__________ is an Object Oriented Database.
NoSQL
An expressive structure with the collection of nodes and relationships interlinking
them is __________
Graph datastore
Which among the following is used by Amazon to store the user's shopping cart 
details?
khud se Redis 
The famous XML Database(s) is/are _________
eXist and MarkLogic
Distributed Database solutions can be implemented by __________
Sharding Replication Model
__________ requires data in a structured format as per the defined data model.
RDBMS
NoSQL data replication is __________.
Heterogenous
Sharding replication follows__________.
Horizontal Partitioning of Data
Apache Kudu distributes data through Vertical Partitioning.
False
Neo4j is an example of Document Store DB
False
Which of the following does not have restrictions on the data type it stores?
Columnar Family in Columnar Datastore
The language to transform XML documents into other formats, like non-XML formats 
such as HTML is ______
XSLT
The core principle of NoSQL is __________.
BASE
The key parameter(s) to be taken into consideration while weighing NoSQL databases 
against each other is/are __________
All of the above
Which type of Key-Value datastore DB has its key and value sorted?
khud se 
https://www.coursehero.com/file/59623579/Done-NoSQL-Database-Revolution-QAtxt/
Th
is 
stu
dy
 re
so
ur
ce
 w
as
sh
are
d v
ia 
Co
ur
se
He
ro
.co
m
https://www.coursehero.com/file/59623579/Done-NoSQL-Database-Revolution-QAtxt/
Solid-State Key-Value datastore
__________ is a Columnar database that runs on a Hadoop cluster.
Apache H Base
NoSQL can handle __________.
khud s e
semi and Unstructured Data
Which Replication model has the strongest resiliency power?
Master-Slave Replication Model
An expressive structure with the collection of nodes and relationships interlinking
them is __________.
Graph datastore
Key-value databases would not be the best fit if there is/are __________
khud se 
Multioperation Transaction
Hash Table Design is similar to __________
Key Value datastore
In the Master-Slave Replication model, the slave node services __________.
khud se 
Read and Write operations
In Riak Key Value datastore, the variable 'W' indicates __________.
Number of Write Operations
In the Master-Slave Replication model, the node which services all the database 
write operations is __________
Master Node
An example of Key-Value datastore is __________
DynamoDB
The file format(s) that can be stored and retrieved from the Document Store NoSQL 
data model is/are __________
All the above 
Which type of datastore supports nodes that are connected by relationships?
Graph datastore
The type of Graph Store that works in real-time is _______
Graph Database
Riak DB leverages the CAP Theorem to improve its scalability
khud se 
True
Which of the following has properties attached to it in the Graph datastore?
Nodes
In MongoDB, data is represented as a collection of 
JSON documents
The Document base unit of storage resembles __________ in an RDBMS.
https://www.coursehero.com/file/59623579/Done-NoSQL-Database-Revolution-QAtxt/
Th
is 
stu
dy
 re
so
ur
ce
 w
as
sh
are
d v
ia 
Co
ur
se
He
ro
.co
m
https://www.coursehero.com/file/59623579/Done-NoSQL-Database-Revolution-QAtxt/
all
Cassandra was developed by 
FB
https://www.coursehero.com/file/59623579/Done-NoSQL-Database-Revolution-QAtxt/
Th
is 
stu
dy
 re
so
ur
ce
 w
as
sh
are
d v
ia 
Co
ur
se
He
ro
.co
m
Powered by TCPDF (www.tcpdf.org)
https://www.coursehero.com/file/59623579/Done-NoSQL-Database-Revolution-QAtxt/
http://www.tcpdf.org