NoSQL - Database Revolution Fresco Play MCQs Answers

NoSQL - Database Revolution Fresco Play MCQs Answers

Disclaimer: The main motive to provide this solution is to help and support those who are unable to do these courses due to facing some issue and having a little bit lack of knowledge. All of the material and information contained on this website is for knowledge and education purposes only.

Try to understand these solutions and solve your Hands-On problems. (Not encourage copy and paste these solutions)

Course Path: Modern Data Platforms/NO SQL/NoSQL - Database Revolution

All Question of the Quiz Present Below for Ease Use Ctrl + F to find the Question.

NoSQL Basics

1.The full form of 'CRUD' is _________.

1. Create-Read-Update-Define
2. None of the options
3. Create-Read-Update-Deliver
4. Create-Run-Update-Delete
5. Create-Read-Update-Delete

Answer: 5)Create-Read-Update-Delete

2.________ distributes different data across multiple servers.

1. None of the options
2. Bucketing
3. Sharding
4. Partitioning

Answer: 3)Sharding

3.The horizontal scaling approach tends to be cheaper as the number of operations, and the size of the data increases.

1. True
2. False

Answer: 1)True

4.NoSQL databases are designed to expand _________.

1. with increase of load
2. vertically
3. hardware wise
4. horizontally

Answer: 4)horizontally

5.Limitation(s) of RDBMS is/are ______________.

1. All the options
2. Ease of Maintenance/Performance
3. Scalability/Database design complexity
4. Less Expensive/Performance

Answer: 3)Scalability/Database design complexity

• List of Fresco Play Courses without Hands-On | Fresco Play
• HMTL5 Semantics Elements MCQs Answers | Fresco Play
• HMTL5 Semantics Elements Hands-On Solutions | Fresco Play
• Styling with CSS3 Hands-On Solutions | Fresco Play
• Blockchain Intermedio MCQs Answers | Fresco Play
• Blockchain - Potentes Nexus MCQs Answers | Fresco Play
• Azure Essentials MCQs Answers | Fresco Play
• AWS Essentials MCQs Answers | Fresco Play

Quiz on NoSQL: Key-Value Store

1.The key-value pair data storages include all, except ________.

1. In-memory
2. Network Attached Storage
3. Disk Storage
4. Cache Storage
5. All the options

Answer: 2)Network Attached Storage

2.Cassandra has properties of both __________ and ____________ .

1. Kudu and Hbase
2. Neo4j / Amazon Dynamo
3. All the options
4. Google Bigtable / Amazon Dynamo
5. MongoDB / Google BigTable

Answer: 4)Google Bigtable / Amazon Dynamo

3.A Riak Convergent Replicated Data Type (CRDT) includes ________.

1. All the options
2. JSON/Maps/Sets
3. JSON/Maps
4. Maps/Sets/Counters
5. Sets

Answer: 4)Maps/Sets/Counters

4.The RDBMS 'table' equivalent terminology in Riak is ________.

1. data store
2. None of the options
3. data segment
4. bucket
5. key-value

Answer: 4)bucket

5.A Key-value store supports Secondary Indexes.

1. False
2. True

Answer: 2)True

Quiz on NoSQL: Columnar Store

1.Pre-join projection is equivalent to ________ as in traditional relational systems.

1. Table
2. Materialized view
3. None of the options
4. Joins
5. Stored Procedure

Answer: 2)Materialized view

2.The column store has to perform _______ IO to insert a new value.

1. Single
2. as many disk blocks
3. Two
4. None of the options
5. Multiple

Answer: 2)as many disk blocks

3.In column-oriented stores, data is stored on a ____________ basis.

1. Column
2. Column Family
3. Row Key

Answer: 2)Column Family

4.HBase tables are divided _________ by row key range into ________ .

1. vertically, region servers
2. horizontally, region servers
3. vertically, regions
4. horizontally, regions
5. horizontally, HDFS Files

Answer: 4)horizontally, regions

5.The row store needs to perform _______ IO to insert a new value.

1. None of the options
2. Two
3. Multiple
4. As many disk blocks as there are columns
5. Single

Answer: 5)Single

6.HBase main server components include all except _________.

1. HBase HFile
2. HBase Master
3. All the options
4. HBase Memstore
5. Region Server
6. ZooKeeper

Answer: 4)HBase Memstore

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

1. False
2. True

Answer: 1)False

8.Columnar databases are preferable for OLTP systems.

1. False
2. True

Answer: 1)False

9.In HBase, 'Columns' are named and specified in the table definition.

1. True
2. False

Answer: 2)False

10.In a column-database, a row is uniquely identified by __________.

1. Column-identifier
2. None of the options
3. Row-key
4. Column-family

Answer: 3)Row-key

11.In Cassandra, the _________ determines how many copies of the data will be maintained across multiple nodes.

1. Read Consistency
2. None of the options
3. Replication factor
4. Write Consistency

Answer: 3)Replication factor

12.A column-database is used to store ________ versions of each cell.

1. Two
2. Latest
3. Single
4. None of the options
5. Multiple

Answer: 5)Multiple

13.The column store has to perform _______ IO to insert a new value.

1. Multiple
2. as many disk blocks
3. None of the options
4. Single
5. Two

Answer: 2)as many disk blocks

Quiz on NoSQL: Document Store

1.JSON documents are built up of _________.

1. arrays
2. objects
3. All the options
4. values

Answer: 3)All the options

2.An RDBMS equivalent component for a document in a document database is ___________.

1. Column
2. Row
3. Primary Key
4. Table
5. None of the options

Answer: 2)Row

3.______ is the syntax for retrieving specific elements from an XML document.

1. XPath
2. None of the options
3. XQuery
4. XSLT

Answer: 1)XPath

4.MongoDB read/write performance can be tuned with the help of Stored Procedures.

1. False
2. True

Answer: 1)False

5.An RDBMS equivalent component for a document identifier in a document database is ________.

1. Foreign Key
2. Table
3. None of the options
4. Column
5. Primary Key

Answer: 1)Foreign Key

6.In MongoDB, there is a similar feature of 'like' expression similar to that in RDBMS.

1. True
2. False

Answer: 2)False

7.Document databases split a document into its constituent name/value pairs for indexing purposes.

1. True
2. False

Answer: 2)False

8.An RDBMS equivalent component for a collection in a document database is ___________.

1. None of the options
2. Table
3. Primary Key
4. Column
5. Row

Answer: 2)Table

9.The MATCH clause is roughly equivalent to the _______ clause in SQL and the RETURN clause to a ______ clause.

1. In, From
2. In, Select
3. None of the options
4. Where, Select
5. Between, Select

Answer: 4)Where, Select

Quiz on NoSQL: Graph Store

1.Graph databases are generally built for use with ________.

1. Data Warehouse Batch Processing
2. OLTP
3. OLAP
4. All the options

Answer: 2)OLTP

2.Neo4j architecture is a self-driven and independent architecture because of ________________.

1. Both the options
2. Cluster Manager auto sync-up functionality
3. Neo4j database instances auto sync-up functionality

Answer: 1)Both the options

3.Only Nodes have properties in the Graph database.

1. False
2. True

Answer: 1)False

4.Cypher query language is associated with __________.

1. None of the options
2. MongoDB
3. Sybase
4. Cassandra
5. Neo4j

Answer: 5)Neo4j

5.The major components of a graph include the following, except _______.

1. All the options
2. Properties
3. JSON
4. None of the options
5. Nodes
6. Relationships

Answer: 3)JSON

• List of Fresco Play Courses without Hands-On | Fresco Play
• HMTL5 Semantics Elements MCQs Answers | Fresco Play
• HMTL5 Semantics Elements Hands-On Solutions | Fresco Play
• Styling with CSS3 Hands-On Solutions | Fresco Play
• Blockchain Intermedio MCQs Answers | Fresco Play
• Blockchain - Potentes Nexus MCQs Answers | Fresco Play
• Azure Essentials MCQs Answers | Fresco Play
• AWS Essentials MCQs Answers | Fresco Play

NoSQL Final Assessment

1.Terrastore is an example of __________.

1. Document datastore
2. Columnar datastore
3. Graph datastore
4. Key Value datastore

Answer: 1)Document datastore

2.__________ is a Columnar database that runs on a Hadoop cluster.

1. Redis
2. Apache HBase
3. None of the options
4. Cassandra

Answer: 2)Apache HBase

3.In Riak Key Value datastore, the Replication Factor 'N' indicates __________.

1. Number of Write Operations
2. Number of Data Copies to be maintained across nodes

Answer: 2)Number of Data Copies to be maintained across nodes

4.The scalability of Key-Value database is achieved through __________.

1. Peer to Peer Replication
2. Master-Slave Replication
3. Sharding Replication

Answer: 3)Sharding Replication

5.__________ in Key-Value Databases are similar to 'Tables' in RDBMS.

1. Keys
2. Values
3. None of the options
4. Buckets

Answer: 4)Buckets

6.Columnar datastore avoids storing null values.

1. True
2. False

Answer: 1)True

7.The Specialized Query Language(s) used in Graph datastore is/are __________.

1. Cypher
2. None of the options
3. Gremlin
4. All the options

Answer: 1)All the options

8.Cassandra was developed by __________

1. Google
2. None of the options
3. Amazon
4. Facebook

Answer: 1)Facebook

9.In Riak Key Value datastore, the variable 'W' indicates __________.

1. Number of Data Copies to be maintained across nodes
2. Number of Write Operations

Answer: 1)Number of Data Copies to be maintained across nodes

10.The type of Graph Store that works in real-time is __________.

1. None of the options
2. All the options
3. Graph Compute Engine
4. Graph Database

Answer: 2)All the options

11.The syntax for retrieving specific elements from an XML document is __________.

1. XMLSchema
2. XQuery
3. XPath

Answer: 3)XPath

12.Which Replication model has the strongest resiliency power?

1. Sharding Replication Model
2. All the options
3. Master-Slave Replication Model
4. Peer to Peer Replication Model

Answer: 2)Peer to Peer Replication Model

13.The famous XML Database(s) is/are _________.

1. eXist
2. MarkLogic
3. eXist, MarkLogic and Cassandra
4. Cassandra
5. eXist and MarkLogic

Answer: 5)eXist and MarkLogic

14.Which type of scaling handles voluminous data by adding servers to the clusters?

1. Horizontal
2. Vertical

Answer: 1)Horizontal

15.Apache Kudu distributes data through Vertical Partitioning.

1. False
2. True

Answer: 1)False

16.NoSQL can handle __________.

1. Unstructured and Semi-structured data
2. None of the options
3. Semi-structured data only
4. Unstructured Data only

Answer: 1)Unstructured and Semi-structured data

17.Which type of datastore supports nodes that are connected by relationships?

1. Key Value datastore
2. Columnar datastore
3. Document datastore
4. Graph datastore

Answer: 4)Graph datastore

18.Which type of database requires a trained workforce for the management of data?

1. NoSQL
2. RDBMS

Answer: 2)RDBMS

19.Hash Table Design is similar to __________.

1. Document datastore
2. Key Value datastore
3. Columnar datastore
4. Graph datastore

Answer: 2)Key Value datastore

20.__________ requires data in a structured format as per the defined data model.

1. RDBMS
2. NoSQL

Answer: 1)RDBMS

21.The most popular Navigational DBMS system is/are __________.

1. Integrated Management System and Integrated Database System
2. None of the options
3. Integrated Management System
4. Integrated Database System

Answer: 1)Integrated Management System and Integrated Database System

22.Which of the following does not have restrictions on the data type it stores?

1. All the options
2. Columnar Family in Columnar Datastore
3. Columns in RDBMS
4. None of the options

Answer: 1)Columnar Family in Columnar Datastore

23.Example(s) of Columnar Database is/are __________.

1. Cassandra and HBase
2. Cassandra, HBase and Redis
3. Cassandra
4. HBase
5. Redis

Answer: 1)Cassandra and HBase

24.In a Column Data Model, the number of columns that a row can have __________.

1. remains the same
2. varies

Answer: 2)varies

25.In the Master-Slave Replication model, the slave node services __________.

1. None of the options
2. Write operations
3. Read operations
4. Read and Write operations

Answer: 3)Read operations

26.The Property Graph Model is similar to __________.

1. Entity Relationship Diagram
2. None of the options
3. Use Case Diagram
4. Sequence Diagram

Answer: 1)Entity Relationship Diagram

27.The file format(s) that can be stored and retrieved from the Document Store NoSQL data model is/are __________.

1. XML
2. JSON
3. BSON
4. All the options

Answer: 4)All the options

28.Which Replication model supports database read and write operations in all the nodes?

1. Master-Slave Replication
2. All the options
3. None of the options
4. Peer to Peer Replication Model

Answer: 4)Peer to Peer Replication Model

29.Riak DB leverages the CAP Theorem to improve its scalability.

1. True
2. False

Answer: 1)True

30.In the Master-Slave Replication model, the node which pushes all the updates in data to subordinate nodes is __________.

1. Slave Node
2. All the options
3. Master Node

Answer: 3)Master Node

31.The language to transform XML documents into other formats, like non-XML formats such as HTML is _________.

1. XPath
2. XSLT
3. XQuery
4. XML

Answer: 2)XSLT

32.NoSQL is a Relational Data Model.

1. False
2. True

Answer: 1)False

33.In the Master-Slave Replication model, different Slave Nodes contain __________.

1. Different data
2. Same data

Answer: 2)Same data

34.The key parameter(s) to be taken into consideration while weighing NoSQL databases against each other is/are __________

1. Performance
2. Database Features
3. Context-based Criteria
4. All the options

Answer: 4)All the options

35.Which among the following is the correct API call in Key-Value datastore?

1. put(key,value)
2. put(key)
3. put(value)
4. None of the options

Answer: 1)put(key,value)

36.Which type of Key-Value datastore DB has its key and value sorted?

1. Solid-State Key-Value datastore
2. RAM Key-Value datastore
3. Ordered Key-Value datastore
4. Eventually Consistent Key-Value datastore

Answer: 3)Ordered Key-Value datastore

37.An expressive structure with the collection of nodes and relationships interlinking them is __________.

1. Graph datastore
2. Key-Value datastore
3. Columnar datastore

Answer: 1)Graph datastore

38.Which among the following is used by Amazon to store the user's shopping cart details?

1. MemCached
2. Riak
3. Redis
4. DynamoDB

Answer: 4)DynamoDB

39.NoSQL data replication is __________.

1. Heterogenous
2. Homogenous

Answer: 2)Homogenous

40.All NoSQL databases are similar.

1. True
2. False

Answer: 2)False

41.Which of the following has properties attached to it in the Graph datastore?

1. None of the options
2. Nodes
3. Nodes and Relationships
4. Relationships

Answer: 3)Nodes and Relationships

42.The Document base unit of storage resembles __________ in an RDBMS.

1. Columns
2. Rows

Answer: 2)Rows

43.The core principle of NoSQL is __________.

1. None of the options
2. ACID
3. BASE

Answer: 3)BASE

44.__________ are chunks of related data often accessed together.

1. All the options
2. Columns
3. Documents
4. Column Families

Answer: 4)Column Families

45.In a columnar Database, __________ uniquely identifies a record.

1. None of the options
2. All the options
3. Column-Key
4. Row-Key

Answer: 4)Row-Key

46.Relational Database satisfies __________.

1. ACID Properties
2. All the options
3. BASE Properties

Answer: 2)All the options

47.CAP represents __________.

1. Consistency, Availability, Partition Tolerance
2. None of the options
3. Cost free, Availability, Portability

Answer: 1)Consistency, Availability, Partition Tolerance

48.__________ is an Object Oriented Database.

1. NoSQL
2. RDBMS

Answer: 1)NoSQL

49.In a Key-Value datastore, both keys and values need to be unique.

1. True
2. False

Answer: 2)False

50.Which of the following factors influence(s) the choice of replication model?

1. Environment
2. All the options
3. Server Capacity
4. Application Demand
5. Throughput

Answer: 2)All the options

51.Document Store database contains data in the format of __________.

1. All the options
2. XML document
3. BSON document
4. JSON document

Answer: 1)All the options

• List of Fresco Play Courses without Hands-On | Fresco Play
• HMTL5 Semantics Elements MCQs Answers | Fresco Play
• HMTL5 Semantics Elements Hands-On Solutions | Fresco Play
• Styling with CSS3 Hands-On Solutions | Fresco Play
• Blockchain Intermedio MCQs Answers | Fresco Play
• Blockchain - Potentes Nexus MCQs Answers | Fresco Play
• Azure Essentials MCQs Answers | Fresco Play
• AWS Essentials MCQs Answers | Fresco Play

If you want answers to any of the fresco play courses feel free to ask in the comment section, we will surely help.