A company has an application that uses an Amazon DynamoDB table to store user data. Every morning, a single-threaded process calls the DynamoDB API Scan operation to scan the entire table and generate a critical start-of-day report for management. A successful marketing campaign recently doubled the number of items in the table, and now the process takes too long to run and the report is not generated in time.
A database specialist needs to improve the performance of the process. The database specialist notes that, when the process is running, 15% of the table’s provisioned read capacity units (RCUs) are being used.
What should the database specialist do?

1. A. Enable auto scaling for the DynamoDB table.
2. B. Use four threads and parallel DynamoDB API Scan operations.
3. C. Double the table’s provisioned RCUs.
4. D. Set the Limit and Offset parameters before every call to the API.

Correct Answer: B
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Scan.html#Scan.ParallelScan

A database specialist is constructing an AWS CloudFormation stack using AWS CloudFormation. The database expert wishes to avoid the stack's Amazon RDS ProductionDatabase resource being accidentally deleted.
Which solution will satisfy this criterion?

1. A. Create a stack policy to prevent update
2. B. Include €Effect€ : €ProductionDatabase€ and €Resource€€Deny€ in the policy.
3. C. Create an AWS CloudFormation stack in XML forma
4. D. Set xAttribute as false.
5. E. Create an RDS DB instance without the DeletionPolicy attribut
6. F. Disable termination protection.
7. G. Create a stack policy to prevent update
8. H. Include Effect, Deny, and Resource :ProductionDatabase in the policy.

Correct Answer: D
https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/protect-stack-resources.html "When you set a stack policy, all resources are protected by default. To allow updates on all resources, we add an Allow statement that allows all actions on all resources. Although the Allow statement specifies all resources, the explicit Deny statement overrides it for the resource with the ProductionDatabase logical ID. This Deny statement prevents all update actions, such as replacement or deletion, on the ProductionDatabase resource."

An online shopping company has a large inflow of shopping requests daily. As a result, there is a consistent load on the company’s Amazon RDS database. A database specialist needs to ensure the database is up and running at all times. The database specialist wants an automatic notification system for issues that may cause database downtime or for configuration changes made to the database.
What should the database specialist do to achieve this? (Choose two.)

1. A. Create an Amazon CloudWatch Events event to send a notification using Amazon SNS on every API call logged in AWS CloudTrail.
2. B. Subscribe to an RDS event subscription and configure it to use an Amazon SNS topic to send notifications.
3. C. Use Amazon SES to send notifications based on configured Amazon CloudWatch Events events.
4. D. Configure Amazon CloudWatch alarms on various metrics, such as FreeStorageSpace for the RDS instance.
5. E. Enable email notifications for AWS Trusted Advisor.

Correct Answer: BD

A business's mission-critical production workload is being operated on a 500 GB Amazon Aurora MySQL DB cluster. A database engineer must migrate the workload without causing data loss to a new Amazon Aurora Serverless MySQL DB cluster.
Which approach will result in the LEAST amount of downtime and the LEAST amount of application impact?

1. A. Modify the existing DB cluster and update the Aurora configuration to Serverless.
2. B. Create a snapshot of the existing DB cluster and restore it to a new Aurora Serverless DB cluster.
3. C. Create an Aurora Serverless replica from the existing DB cluster and promote it to primary when the replica lag is minimal.
4. D. Replicate the data between the existing DB cluster and a new Aurora Serverless DB cluster by using AWS Database Migration Service (AWS DMS) with change data capture (CDC) enabled.

Correct Answer: D
https://medium.com/@souri29/how-to-migrate-from-amazon-rds-aurora-or-mysql-to-amazon-aurora-serverless

A company is hosting critical business data in an Amazon Redshift cluster. Due to the sensitive nature of the data, the cluster is encrypted at rest using AWS KMS. As a part of disaster recovery requirements, the company needs to copy the Amazon Redshift snapshots to another Region.
Which steps should be taken in the AWS Management Console to meet the disaster recovery requirements?

1. A. Create a new KMS customer master key in the source Regio
2. B. Switch to the destination Region, enable Amazon Redshift cross-Region snapshots, and use the KMS key of the source Region.
3. C. Create a new IAM role with access to the KMS ke
4. D. Enable Amazon Redshift cross-Region replication using the new IAM role, and use the KMS key of the source Region.
5. E. Enable Amazon Redshift cross-Region snapshots in the source Region, and create a snapshot copy grant and use a KMS key in the destination Region.
6. F. Create a new KMS customer master key in the destination Region and create a new IAM role with access to the new KMS ke
7. G. Enable Amazon Redshift cross-Region replication in the source Region anduse the KMS key of the destination Region.

Correct Answer: C
If you want to enable cross-Region snapshot copy for an AWS KMS–encrypted cluster, you must configure a snapshot copy grant for a root key in the destination AWS Region Source-Region : configure a cross-Region snapshot for an AWS KMS–encrypted cluster In Destination AWS Region : choose the AWS Region to which to copy snapshots.
https://docs.aws.amazon.com/redshift/latest/mgmt/managing-snapshots-console.html#xregioncopy-kms-encrypt