MSP Bank's Database Migration and Optimization on AWS Cloud
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 MSSQL relational database.
The schema designed is based on 3NF.
MSP Bank want to migrate the database on to AWS cloud.
Also MSP Bank is looking to build a new database solution which is optimized for storing billions of relationships and querying the storage with milliseconds latency.
Which AWS services fulfill the requirement? select 1 option.
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D. E. F.Answer: D.
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.htmlOption 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.htmlOption C 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.htmlAmazon 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.htmlOption D is correct -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
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/CHAP_AuroraOverview.htmlAmazon 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.htmlOption E is incorrect -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.htmlAmazon 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.htmlOption F is incorrect -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.htmlDynamoDB neither supports relational model nor graph model.
MSP Bank is looking to migrate their existing MSSQL relational database to the AWS cloud and also build a new database solution that can store billions of relationships and allow querying with milliseconds latency.
To fulfill the requirements, we need to choose an AWS service that can meet the following criteria:
Migrate MSSQL relational database to AWS cloud: AWS RDS is a fully managed relational database service that supports several popular databases, including SQL Server. Hence, AWS RDS can be used to migrate MSSQL database to the AWS cloud.
Build a new database solution that can store billions of relationships and allow querying with milliseconds latency: AWS provides several database services that can store and manage large amounts of data efficiently. The two primary AWS database services that can meet this requirement are Amazon DynamoDB and Amazon Neptune.
Amazon DynamoDB is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability. It is optimized for storing and querying structured and unstructured data, including documents, key-value pairs, and graph data. DynamoDB supports both relational and graph models. Therefore, it can be used to store billions of relationships and provide fast querying with milliseconds latency.
Amazon Neptune is a fully managed graph database service that is designed to store and process billions of relationships between data points. It supports the popular graph query languages, including SPARQL and Apache TinkerPop Gremlin. Neptune is optimized for handling complex and interconnected datasets that require fast and accurate querying. Therefore, it can be used to store billions of relationships and provide fast querying with milliseconds latency.
Hence, the correct option is: Option D. AWS Aurora fulfils the relational database requirements while AWS Neptune supports managing relationships through its graph model.
Option A and B are incorrect because Aurora and RDS support only the relational model and not the graph model. Option C is incorrect because DynamoDB is a NoSQL database that supports graph data but not the relational model. Option E is incorrect because DynamoDB fulfills the NoSQL database requirements but not the relational model, while Neptune supports only the graph model. Option F is partially correct because DynamoDB supports both relational and graph models, but it does not fulfill the relational database requirements on its own.
