DBS-C01 · Question #344
A company runs an ecommerce application on premises on Microsoft SQL Server. The company is planning to migrate the application to the AWS Cloud. The application code contains complex T-SQL queries…
The correct answer is C. Migrate the database to Amazon RDS for SQL Server. Turn on Kerberos authentication. Migrate SQL Server to AWS and minimize database maintenance operating costs = RDS SQL T-SQL queries and stored procedures = Support RDS SQL Server Minimize the need to rewrite code as part of the migration effort = RDS SQL Server
Question
A company runs an ecommerce application on premises on Microsoft SQL Server. The company is planning to migrate the application to the AWS Cloud. The application code contains complex T-SQL queries and stored procedures. The company wants to minimize database server maintenance and operating costs after the migration is completed. The company also wants to minimize the need to rewrite code as part of the migration effort. Which solution will meet these requirements?
Options
- AMigrate the database to Amazon Aurora PostgreSQL. Turn on Babelfish.
- BMigrate the database to Amazon S3. Use Amazon Redshift Spectrum for query processing.
- CMigrate the database to Amazon RDS for SQL Server. Turn on Kerberos authentication.
- DMigrate the database to an Amazon EMR cluster that includes multiple primary nodes.
How the community answered
(42 responses)- A5% (2)
- B7% (3)
- C86% (36)
- D2% (1)
Explanation
Migrate SQL Server to AWS and minimize database maintenance operating costs = RDS SQL T-SQL queries and stored procedures = Support RDS SQL Server Minimize the need to rewrite code as part of the migration effort = RDS SQL Server
Topics
Community Discussion
No community discussion yet for this question.