Big Data - NoSQL introduction

Which of the following is not one of the four V’s of Big Data?

• Velocity

• Volume

• Variety

• Value

Which function is responsible for consolidating the results produced by each of the Map() functions/tasks?

• Reduce

• Map

• Reducer

• All of them

Which of the following is true about MapReduce?

• It provides resource management.

• It is an open source data warehouse system for querying and analyzing large datasets stored in hadoop files.

• It is a data processing layer of hadoop.

• None of the statements are true.

Which of the following maps input key/value pairs to a set of intermediate key/value pairs?

• Mapper

• Reducer

• Both of them

• None of them

What is CAP stands for?

• Consistency, Atomicity & Partition tolerance

• Captivity, Atomicity & Permanence

• Consistency, Availability & Permanence

• Consistency, Availability & Partition tolerance

Consider the scenario below and decide which type of database would be the best fit: SQL or NoSQL?

A rapidly growing e-commerce company needs a database to handle millions of product listings, customer orders, and inventory management. They require strong ACID guarantees for maintaining data integrity and transactional support.

• SQL

• NoSQL

Answer explanation

In this scenario, a SQL database would be the best fit. SQL databases are known for their strong ACID guarantees, which ensure data integrity and transactional consistency. The structured nature of SQL databases allows for efficient querying, complex joins, and powerful indexing capabilities, making them well-suited for managing structured data like product listings, customer orders, and inventory records.

Consider the scenario below and decide which type of database would be the best fit: SQL or NoSQL?
A high-traffic online gaming platform wants to implement a caching layer to improve the performance of their game leaderboards. The leaderboards display the rankings of players based on their scores, and they are frequently accessed by millions of players worldwide. The platform wants to store the leaderboard data in a database that can provide fast and efficient read operations.

• SQL

• NoSQL

Answer explanation

In this scenario, a NoSQL key-value store would be the best fit. Key-value stores excel at caching frequently accessed data, making them an ideal choice for implementing a leaderboard caching layer. Each player's score and ranking can be stored as a key-value pair, with the player's unique identifier as the key and their score as the value. Key-value stores offer fast key lookups, allowing for quick retrieval of leaderboard data based on player IDs. Additionally, key-value stores can be integrated with in-memory caching mechanisms, further enhancing the performance of leaderboard queries. The simplicity and high performance of key-value stores make them well-suited for scenarios where fast read operations and caching are paramount.

Consider the scenario below and decide which type of database would be the best fit: SQL or NoSQL?

A transportation logistics company needs a database to manage its extensive fleet of vehicles, track real-time GPS data, and optimize routes for efficient delivery operations. They require high scalability to handle increasing data volumes and the ability to perform geospatial queries for route optimization.

• SQL

• NoSQL

Answer explanation

In this scenario, a NoSQL database, specifically a geospatial database or a column-based database, would be the best fit. Geospatial databases, like PostGIS or MongoDB with geospatial features, are designed for efficient storage and querying of geospatial data, making them suitable for tracking real-time GPS data and performing geospatial queries for route optimization. Column-based databases, such as Apache Cassandra, offer high scalability and can handle large data volumes, making them a good choice for managing extensive vehicle fleets and their associated data.

Which of the following is a characteristic of key-value stores?

• They enforce a rigid schema for data storage.

• They are primarily optimized for complex joins and aggregations.

• They provide strong ACID guarantees for data consistency.

• They offer high scalability and fast key lookups.

Which of the following do you consider is a common use case for key-value stores?

• Storing and querying complex relationships in a social network.

• Performing ad-hoc queries on unstructured textual data.

• Managing inventory and order data in an e-commerce system.

• Analyzing and processing large volumes of time-series data.