NoSQL Document Management on AWS - Best Options

Best NoSQL Document Management Options on AWS

Question

MSP Bank, Limited is a leading Japanese monetary institution that provides a full range of financial products and services to both institutional and individual customers.

It is headquartered in Tokyo.

MSP Bank is hosting their existing infrastructure on premise. MSP bank has lot of web applications, databases and data warehouse built on Teradata, NoSQL databases, and other types of data stores.

MSP bank has lot of data assets in terms of logs, documents; excel files, CSV files, PDF documents and others. The Web Application has different user workloads at different parts of the day.

MSP Bank is running one of their web application NODE.JS supported by MongoDB Database.

The schema designed is document based.

The team wants to migrate the platform on to AWS.

Which NoSQL Managed service provides the document management capability? select 1 option.

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D.

Answer: C.

Option A is incorrect -Amazon Aurora (Aurora) is a fully managed relational database engine that's compatible with MySQL and PostgreSQL.

You already know how MySQL and PostgreSQL combine the speed and reliability of high-end commercial databases with the simplicity and cost-effectiveness of open-sourcedatabases.

The code, tools, and applications you use today with your existing MySQL and PostgreSQL databases can be used with Aurora.

With some workloads, Aurora can deliver up to five times the throughput of MySQL and up to three times the throughput of PostgreSQL without requiring changes to most of your existing applications.

Amazon Aurora supports relational data models and does not support graph model.

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/CHAP_AuroraOverview.html

Option B is incorrect - Amazon Relational Database Service (Amazon RDS) is a web service that makes it easier to set up, operate, and scale a relational database in the cloud.

It provides cost-efficient, resizable capacity for an industry-standard relational database and manages common database administration tasks.

Amazon RDS supports relational data models and does not support graph model.

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Welcome.html

Option C is correct -Amazon DynamoDB is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability.

DynamoDB lets you offload the administrative burdens of operating and scaling a distributed database, so that you don't have to worry about hardware provisioning, setup and configuration, replication, software patching, or cluster scaling.

https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Introduction.html

Option D is incorrect -Amazon Neptune is a fast, reliable, fully managed graph database service that makes it easy to build and run applications that work with highly connected datasets.

The core of Neptune is a purpose-built, high-performance graph database engine that is optimized for storing billions of relationships and querying the graph with milliseconds latency

https://docs.aws.amazon.com/neptune/latest/userguide/intro.html

The correct answer is C. Amazon DynamoDB Database, being a document database support document models and NoSQL requirements.

Explanation: MSP Bank is currently using MongoDB database for their web application, which is a document-based NoSQL database. Therefore, when migrating their platform onto AWS, they need a managed NoSQL service that supports document management capabilities. Amazon offers various managed NoSQL databases, such as Amazon Aurora, Amazon RDS, Amazon Neptune, and Amazon DynamoDB. Among these, Amazon DynamoDB is the most suitable choice for MSP Bank because it is a document database that provides high-performance, low-latency access to data.

Amazon DynamoDB is designed to handle large amounts of structured and unstructured data and is fully managed, meaning that AWS takes care of the administrative tasks such as hardware provisioning, software patching, and backups. DynamoDB supports document data models, which allows developers to store data in a flexible schema and query the data using JSON-like documents.

Amazon Aurora and Amazon RDS are relational databases that do support document models, but they are better suited for traditional SQL workloads. Amazon Neptune is a graph database, which is optimized for managing highly connected datasets.

In summary, Amazon DynamoDB is the most suitable choice for MSP Bank's web application migration as it is a managed NoSQL document database that can handle large amounts of structured and unstructured data and provides high performance and low latency access to data.