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?

1. A. Create a DynamoDB stream that is processed by an AWS Lambda function that copies the data to a DynamoDB table in another Region.
2. B. Use a DynamoDB global table replica in another Regio
3. C. Enable point-in-time recovery for both tables.
4. D. Use a DynamoDB Accelerator table in another Regio
5. E. Enable point-in-time recovery for the table.
6. F. Create an AWS Backup plan and assign the DynamoDB table as a resource.

Correct Answer: C

An ecommerce company has tasked a Database Specialist with creating a reporting dashboard that visualizes critical business metrics that will be pulled from the core production database running on Amazon Aurora. Data that is read by the dashboard should be available within 100 milliseconds of an update.
The Database Specialist needs to review the current configuration of the Aurora DB cluster and develop a cost-effective solution. The solution needs to accommodate the unpredictable read workload from the
reporting dashboard without any impact on the write availability and performance of the DB cluster.
Which solution meets these requirements?

1. A. Turn on the serverless option in the DB cluster so it can automatically scale based on demand.
2. B. Provision a clone of the existing DB cluster for the new Application team.
3. C. Create a separate DB cluster for the new workload, refresh from the source DB cluster, and set up ongoing replication using AWS DMS change data capture (CDC).
4. D. Add an automatic scaling policy to the DB cluster to add Aurora Replicas to the cluster based on CPU consumption.

Correct Answer: A

A company wants to migrate its on-premises MySQL databases to Amazon RDS for MySQL. To comply with the company’s security policy, all databases must be encrypted at rest. RDS DB instance snapshots must also be shared across various accounts to provision testing and staging environments.
Which solution meets these requirements?

1. A. Create an RDS for MySQL DB instance with an AWS Key Management Service (AWS KMS) customer managed CM
2. B. Update the key policy to include the Amazon Resource Name (ARN) of the other AWS accounts as a principal, and then allow the kms:CreateGrant action.
3. C. Create an RDS for MySQL DB instance with an AWS managed CM
4. D. Create a new key policy to include the Amazon Resource Name (ARN) of the other AWS accounts as a principal, and then allow the kms:CreateGrant action.
5. E. Create an RDS for MySQL DB instance with an AWS owned CM
6. F. Create a new key policy to include the administrator user name of the other AWS accounts as a principal, and then allow the kms:CreateGrant action.
7. G. Create an RDS for MySQL DB instance with an AWS CloudHSM ke
8. H. Update the key policy to include the Amazon Resource Name (ARN) of the other AWS accounts as a principal, and then allow the kms:CreateGrant action.

Correct Answer: A
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ShareSnapshot.html

A company is running Amazon RDS for MySQL for its workloads. There is downtime when AWS operating system patches are applied during the Amazon RDS-specified maintenance window.
What is the MOST cost-effective action that should be taken to avoid downtime?

1. A. Migrate the workloads from Amazon RDS for MySQL to Amazon DynamoDB
2. B. Enable cross-Region read replicas and direct read traffic to then when Amazon RDS is down
3. C. Enable a read replicas and direct read traffic to it when Amazon RDS is down
4. D. Enable an Amazon RDS for MySQL Multi-AZ configuration

Correct Answer: D
https://aws.amazon.com/premiumsupport/knowledge-center/rds-required-maintenance/
To minimize downtime, modify the Amazon RDS DB instance to a Multi-AZ deployment. For Multi-AZ deployments, OS maintenance is applied to the secondary instance first, then the instance fails over, and then the primary instance is updated. The downtime is during failover. For more information, see Maintenance for Multi-AZ Deployments. https://aws.amazon.com/rds/faqs/ The availability benefits of Multi-AZ also extend to planned maintenance. For example, with automated backups, I/O activity is no longer suspended on your primary during your preferred backup window, since backups are taken from the standby. In the case of patching or DB instance class scaling, these operations occur first on the standby, prior to automatic fail over. As a result, your availability impact is limited to the time required for automatic failover to complete.

A database expert is responsible for building a highly available online transaction processing (OLTP) solution that makes use of Amazon RDS for MySQL production databases. Disaster recovery criteria include a cross-regional deployment and an RPO and RTO of 5 and 30 minutes, respectively.
What should the database professional do to ensure that the database meets the criteria for high availability and disaster recovery?

1. A. Use a Multi-AZ deployment in each Region.
2. B. Use read replica deployments in all Availability Zones of the secondary Region.
3. C. Use Multi-AZ and read replica deployments within a Region.
4. D. Use Multi-AZ and deploy a read replica in a secondary Region.

Correct Answer: D