You are choosing a NoSQL database to handle telemetry data submitted from millions of Internet-of-Things (IoT) devices. The volume of data is growing at 100 TB per year, and each data entry has about 100 attributes. The data processing pipeline does not require atomicity, consistency, isolation, and durability (ACID).
However, high availability and low latency are required.
You need to analyze the data by querying against individual fields. Which three databases meet your requirements? (Choose three.)
A. Redis
B. HBase
C. MySQL
D. MongoDB
E. Cassandra
F. HDFS with Hive
|
Download Printable PDF. VALID exam to help you PASS. |
 |
by the way, hive is not a good solution if we have streaming data….that one is best for static information (counting words in a bunch of books for example) but not with tons of incoming data
redis is key value, not good
HBase yes, excelent case for linear growth and a column oriented database
mysql not good, too big and no need for transactionality
Mongodb, document db with flexible schema.
Yes Cassandra, good use case
You can use Hive, for analysis over static datasets, but if you have streaming logs, I really wouldn’t suggest Hive for this. It’s not a search engine and will take minutes just to find any reasonable data you’re looking for
so it is B,D,E
Redis is not a plain key-value store, it is actually a data structures server, supporting different kinds of values …….https://redis.io/topics/data-types-intro#:~:text=Redis%20is%20not%20a%20plain,supporting%20different%20kinds%20of%20values.&text=Hashes%2C%20which%20are%20maps%20composed,to%20Ruby%20or%20Python%20hashes.
while in traditional key-value stores you associate string keys to string values, in Redis the value is not limited to a simple string, but can also hold more complex data structures.
also MySQL is relational, hive is not relational but it uses HQL