DBS-C01 (Page 13)

A company wants to migrate its Microsoft SQL Server Enterprise Edition database instance from on-premises to AWS.A deep review is performed and the AWSSchema Conversion Tool (AWS SCT) provides options for running this workload on Amazon RDS for SQL Server Enterprise Edition, Amazon RDS for SQL ServerStandard Edition, Amazon Aurora MySQL, and Amazon Aurora PostgreSQL.The company does not want to use its own SQL server license and does not want to change from Microsoft SQL Server.What is the MOST cost-effective and operationally efficient solution?Read More →

A database specialist deployed an Amazon RDS DB instance in Dev-VPC1 used by their development team.Dev-VPC1 has a peering connection with Dev-VPC2 that belongs to a different development team in the same department.The networking team confirmed that the routing between VPCs is correct; however, the database engineers in Dev-VPC2 are getting a timeout connections error when trying to connect to the database in Dev-VPC1.What is likely causing the timeouts?Read More →

A small startup company is looking to migrate a 4 TB on-premises MySQL database to AWS using an Amazon RDS for MySQL DB instance.Which strategy would allow for a successful migration with the LEAST amount of downtime?Read More →

A database specialist at a large multi-national financial company is in charge of designing the disaster recovery strategy for a highly available application that is in development.The application uses an Amazon DynamoDB table as its data store.The application requires a recovery time objective (RTO) of 1 minute and a recovery point objective (RPO) of 2 minutes.Which operationally efficient disaster recovery strategy should the database specialist recommend for the DynamoDB table?Read More →

A retail company with its main office in New York and another office in Tokyo plans to build a database solution on AWS.The company’s main workload consists of a mission-critical application that updates its application data in a data store.The team at the Tokyo office is building dashboards with complex analytical queries using the application data.The dashboards will be used to make buying decisions, so they need to have access to the application data in less than 1 second.Which solution meets these requirements?Read More →

An application reads and writes data to an Amazon RDS for MySQL DB instance.A new reporting dashboard needs read-only access to the database.When the application and reports are both under heavy load, the database experiences performance degradation.A database specialist needs to improve the database performance.What should the database specialist do to meet these requirements?Read More →

A media company wants to use zero-downtime patching (ZDP) for its Amazon Aurora MySQL database.Multiple processing applications are using SSL certificates to connect to database endpoints and the read replicas.Which factor will have the LEAST impact on the success of ZDP?Read More →

A company is load testing its three-tier production web application deployed with an AWS CloudFormation template on AWS.The Application team is making changes to deploy additional Amazon EC2 and AWS Lambda resources to expand the load testing capacity.A Database Specialist wants to ensure that the changes made by the Application team will not change the Amazon RDS database resources already deployed.Which combination of steps would allow the Database Specialist to accomplish this? (Choose two.)Read More →

A manufacturing company’s website uses an Amazon Aurora PostgreSQL DB cluster.Which configurations will result in the LEAST application downtime during a failover? (Choose three.)Read More →

A company is running its production databases in a 3 TB Amazon Aurora MySQL DB cluster.The DB cluster is deployed to the us-east-1 Region.For disaster recovery (DR) purposes, the company’s database specialist needs to make the DB cluster rapidly available in another AWS Region to cover the production load with an RTO of less than 2 hours.What is the MOST operationally efficient solution to meet these requirements?Read More →