Ends in
00
days
00
hrs
00
mins
00
secs
SHOP NOW

ALL AWS Specialty Practice Exams for only $17.99 $13.99 each!

Find answers, ask questions, and connect with our
community around the world.

Home Forums AWS AWS Certified Solutions Architect Professional Timed Mode Diagnostic Test – Question 4 further explanation

  • Timed Mode Diagnostic Test – Question 4 further explanation

  • johara

    Member
    July 28, 2022 at 7:17 pm

    Hi folks! This question has confused me. Why would you convert the database to MySQL? AWS RDS supports SQL Server. My guess is ‘save on operational overhead costs’ implies that using managed MySQL over managed SQL Server would have notable cost savings. Thoughts?

    ————–

    A large company runs its mission-critical Microsoft SQL Server Always On cluster in its on-premises data center servers. The management is planning to migrate its core applications including the database servers to the AWS cloud. The management specifically requested to use AWS managed services whenever possible to save on operational overhead costs. The Solutions Architect must create a heterogeneous database migration strategy to AWS.

    Which of the following options is the recommended solution that will meet the above requirements?

    Answer: Install the AWS Schema Conversion Tool on the on-premises datacenter to convert the database schema from Microsoft SQL Server to MySQL. Create an Amazon RDS for MySQL instance. Migrate the on-premises database to the RDS instance using AWS Database Migration Service (DMS).

  • loh

    Member
    July 31, 2022 at 9:15 pm

    My thinking is that Mysql(open-source) costs less to scale compared to mssql on RDS. With schema conversion provided an easy way, it makes monetary sense to convert into mysql database.

  • Kenneth-Samonte-Tutorials-Dojo

    Member
    August 14, 2022 at 7:49 pm

    Hi Johara,

    Thanks for the feedback.

    My guess is ‘save on operational overhead costs’ implies that using managed MySQL over managed SQL Server would have notable cost savings.

    >> Yes, the migration to RDS is to satisfy the requirement for lesser operational overhead and lesser cost as there is no licensing fee associated with MySQL compared to MS SQL.

    Additionally, the question states “heterogeneous database migration strategy to AWS”, this also implies that they want to change the database solution during the migration. Thus, a combination of SCT (to convert the database) and DMS (to migrate the database) is used as a solution.

    Hope this helps.

    Let us know if you need further assistance. The Tutorials Dojo team is dedicated to helping you pass your AWS exam!

    Regards,

    Kenneth Samonte @ Tutorials Dojo

Viewing 1 - 3 of 3 replies

Log in to reply.

Original Post
0 of 0 posts June 2018
Now