An IoT application has a requirement to collect data from a large number of devices.The data needs to be ingested quickly with very low latency.What would be the recommended option for the database in this scenario?
Click on the arrows to vote for the correct answer
A. B. C. D.Answer: D.
Option A is incorrect because Amazon RedShift is a relational columnar database used as a data warehouse and optimized for reporting and business intelligence applications.It is not suitable for the ingestion of data at low latency.
Option B is incorrect because Amazon RDS is a relational database.It is not optimized for the ingestion of data at very low latency.Further, various devices would collect different types of data.Thus, data would have various schema and is unstructured in nature.Unstructured data is not suitable for a relational database.
Option C is incorrect because Amazon RDS is a relational database.It is not optimized for the ingestion of data at very low latency.Further, various devices would collect different types of data.Thus, data would have various schema and is unstructured in nature.Unstructured data is not suitable for a relational database.
Option D is CORRECT because Amazon DynamoDB is a key-value and document database suitable for unstructured data and optimized for low-latency (sub-millisecond) performance.
Reference:
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Introduction.htmlFor the given scenario, where an IoT application needs to collect data from a large number of devices with low latency, the recommended option would be Amazon DynamoDB.
Amazon DynamoDB is a fully managed NoSQL database that provides fast and predictable performance with seamless scalability. It is designed to handle large amounts of data and can store and retrieve any amount of data, with automatic scaling up and down of throughput capacity. DynamoDB supports both key-value and document data models, and it is highly available with data durability built-in.
In contrast, Amazon Redshift is a data warehousing solution designed for analytics workloads and is optimized for complex queries across large datasets. It is not ideal for low latency data ingestion.
Amazon RDS for PostgreSQL with PostGIS and Amazon RDS for Microsoft SQL are both relational database solutions designed for transactional workloads. They may not be optimized for handling the large volume of data and low latency requirements of an IoT application.
Therefore, for the given scenario, Amazon DynamoDB is the best option as it provides low latency data ingestion, seamless scalability, and high availability.