A large IT hardware manufacturing company wants to deploy a MySQL database solution in the AWS Cloud. The solution should quickly create copies of the company's production databases for test purposes. The solution must deploy the test databases in minutes, and the test data should match the latest production data as closely as possible. Developers must also be able to make changes in the test database and delete the instances afterward.
Which solution meets these requirements?

1. A. Leverage Amazon RDS for MySQL with write-enabled replicas running on Amazon EC2. Create the test copies using a mysqidump backup from the RDS for MySQL DB instances and importing them into the new EC2 instances.
2. B. Leverage Amazon Aurora MySQ
3. C. Use database cloning to create multiple test copies of the production DB clusters.
4. D. Leverage Amazon Aurora MySQ
5. E. Restore previous production DB instance snapshots into new test copies of Aurora MySQL DB clusters to allow them to make changes.
6. F. Leverage Amazon RDS for MySQ
7. G. Use database cloning to create multiple developer copies of the production DB instance.

Correct Answer: B

A company's database specialist implements an AWS Database Migration Service (AWS DMS) task for change data capture (CDC) to replicate data from an on- premises Oracle database to Amazon S3. When usage of the company's application increases, the database specialist notices multiple hours of latency with the CDC.
Which solutions will reduce this latency? (Choose two.)

1. A. Configure the DMS task to run in full large binary object (LOB) mode.
2. B. Configure the DMS task to run in limited large binary object (LOB) mode.
3. C. Create a Multi-AZ replication instance.
4. D. Load tables in parallel by creating multiple replication instances for sets of tables that participate in common transactions.
5. E. Replicate tables in parallel by creating multiple DMS tasks for sets of tables that do not participate in common transactions.

Correct Answer: BE

A Database Specialist is working with a company to launch a new website built on Amazon Aurora with several Aurora Replicas. This new website will replace an on-premises website connected to a legacy relational database. Due to stability issues in the legacy database, the company would like to test the resiliency of Aurora.
Which action can the Database Specialist take to test the resiliency of the Aurora DB cluster?

1. A. Stop the DB cluster and analyze how the website responds
2. B. Use Aurora fault injection to crash the master DB instance
3. C. Remove the DB cluster endpoint to simulate a master DB instance failure
4. D. Use Aurora Backtrack to crash the DB cluster

Correct Answer: B
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Managing.FaultInjectionQu "You can test the fault tolerance of your Amazon Aurora DB cluster by using fault injection queries. Fault injection queries are issued as SQL commands to an Amazon Aurora instance and they enable you to schedule a simulated occurrence of one of the following events: A crash of a writer or reader DB instance A failure of an Aurora Replica A disk failure Disk congestion When a fault injection query specifies a crash, it forces a crash of the Aurora DB instance. The other fault injection queries result in simulations of failure events, but don't cause the event to occur. When you submit a fault injection query, you also specify an amount of time for the failure event simulation to occur for."

A company developed a new application that is deployed on Amazon EC2 instances behind an Application Load Balancer. The EC2 instances use the security group named sg-application-servers. The company needs a database to store the data from the application and decides to use an Amazon RDS for MySQL DB instance. The DB instance is deployed in private DB subnet.
What is the MOST restrictive configuration for the DB instance security group?

1. A. Only allow incoming traffic from the sg-application-servers security group on port 3306.
2. B. Only allow incoming traffic from the sg-application-servers security group on port 443.
3. C. Only allow incoming traffic from the subnet of the application servers on port 3306.
4. D. Only allow incoming traffic from the subnet of the application servers on port 443.

Correct Answer: A
most restrictive approach is to allow only incoming connections from SG of EC2 instance on port 3306

A Database Specialist is creating a new Amazon Neptune DB cluster, and is attempting to load fata from Amazon S3 into the Neptune DB cluster using the Neptune bulk loader API. The Database Specialist receives the following error:
“Unable to connect to s3 endpoint. Provided source = s3://mybucket/graphdata/ and region = us-east-1. Please verify your S3 configuration.”
Which combination of actions should the Database Specialist take to troubleshoot the problem? (Choose two.)

1. A. Check that Amazon S3 has an IAM role granting read access to Neptune
2. B. Check that an Amazon S3 VPC endpoint exists
3. C. Check that a Neptune VPC endpoint exists
4. D. Check that Amazon EC2 has an IAM role granting read access to Amazon S3
5. E. Check that Neptune has an IAM role granting read access to Amazon S3

Correct Answer: BD