ExamQuestions.com

Register
Login
AWS Certified Big Data Specialty (Expired on July 1, 2020) Exam Questions

Amazon

AWS Certified Big Data Specialty (Expired on July 1, 2020)

208 / 370

Question 208:

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.
MSP Bank is running one of their web application NODE.JS supported by MSSQL relational database. The schema designed is based on 3NF. The Web Application has different user workloads at different parts of the day.
MSP Bank is looking to keep the migration simple. As a part of the migration, MSP bank needs some inputs on migration on the following
Migration of MySQL database to a managed relational database with performance of up to 5 times the existing implementation
Database to support both read and write workloads, with READ queries do not impact write query performance
select 2 options.

Answer options:

A.Migrate MySQL Server to Amazon Aurora database MYSQL version with Aurora supporting read replicas which enables segregation of read and write workloads to primary and read replicas and provides 5 times performance compared to standard MySQL
B.Migrate MySQL Server to Amazon Aurora database PostgreSQL version, as PostgreSQL is more performant compared to MySQL and provides 5 times performance compared to standard MySQL
C.Migrate MySQL Server to Amazon RDS database MYSQL version, with RDS supporting read replicas which enables segregation of read and write workloads to primary and read replicas and provides 5 times performance compared to standard MySQL
D.Migrate MySQL Server to MySQL cluster built on EC2 machines, configure cluster to support read replicas which enables segregation of read and write workloads to primary and read replicas
E.Use Data Migration Service (DMS) to address migration of MySQL database on premise to database on AWS cloud
F.Use Data Migration Service (DMS) and Schema Conversion Tool (SCT) to address migration of MySQL database on premise to database on AWS cloud