DBS-C01 · Question #366
DBS-C01 Question #366: Real Exam Question with Answer & Explanation
The correct answer is B: Use AWS Database Migration Service (DMS) to migrate to an RDS for PostgreSQL Multi-AZ. To reduce the cost of a highly available Amazon RDS for SQL Server database with the least effort, while maintaining support for T-SQL and TDS, migrating to Amazon RDS for PostgreSQL (specifically, Aurora PostgreSQL with Babelfish) is the most suitable solution.
Question
A database specialist needs to reduce the cost of an application's database. The database is running on a Multi-AZ deployment of an Amazon RDS for Microsoft SQL Server DB instance. The application requires the database to support stored procedures, SQL Server Wire Protocol (TDS), and T-SQL. The database must also be highly available. The database specialist is using AWS Database Migration Service (AWS DMS) to migrate the database to a new data store. Which solution will reduce the cost of the database with the LEAST effort?
Options
- AUse AWS Database Migration Service (DMS) to migrate to an RDS for MySQL Multi-AZ
- BUse AWS Database Migration Service (DMS) to migrate to an RDS for PostgreSQL Multi-AZ
- CUse AWS Database Migration Service (DMS) to migrate to an RDS for SQL Server Single-AZ
- DUse AWS Database Migration Service (DMS) to migrate the database to Amazon Aurora
Explanation
To reduce the cost of a highly available Amazon RDS for SQL Server database with the least effort, while maintaining support for T-SQL and TDS, migrating to Amazon RDS for PostgreSQL (specifically, Aurora PostgreSQL with Babelfish) is the most suitable solution.
Common mistakes.
- A. Migrating to RDS for MySQL would require extensive refactoring of T-SQL stored procedures and application code, making it a high-effort solution that does not directly support SQL Server Wire Protocol (TDS).
- C. Migrating to an RDS for SQL Server Single-AZ deployment would reduce costs but would violate the requirement for the database to be highly available, as Single-AZ does not provide automatic failover.
- D. While migrating to Amazon Aurora generally offers cost benefits and high availability, the option "Amazon Aurora" is too generic. Aurora has different engine types (MySQL, PostgreSQL), and without specifying Babelfish or PostgreSQL, it doesn't clearly address the T-SQL and TDS compatibility requirements with least effort.
Concept tested. SQL Server migration to open-source, cost reduction, T-SQL/TDS compatibility, Babelfish
Reference. https://aws.amazon.com/rds/aurora/babelfish/
Topics
Community Discussion
No community discussion yet for this question.