A company is building a new web platform where user requests trigger an AWS Lambda function that performs an insert into an Amazon Aurora MySQL DB cluster. Initial tests with less than 10 users on the new platform yielded successful execution and fast response times. However, upon more extensive tests with the actual target of 3,000 concurrent users, Lambda functions are unable to connect to the DB cluster and receive too many connections errors.
Which of the following will resolve this issue?

1. A. Edit the my.cnf file for the DB cluster to increase max_connections
2. B. Increase the instance size of the DB cluster
3. C. Change the DB cluster to Multi-AZ
4. D. Increase the number of Aurora Replicas

Correct Answer: B
Max_connection is a formula in RDS parameter group: GREATEST({log(DBInstanceClassMemory/805306368)*45},{log(DBInstanceClassMemory/8187281408)*100
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Managing.Performance.htm You can increase the maximum number of connections to your Aurora MySQL DB instance by scaling the instance up to a DB instance class with more memory, or by setting a larger value for the max_connections parameter in the DB parameter group for your instance, up to 16,000. You must change a larger value for the max_connections parameter in the DB parameter group, not edit my.cnf, it is not physical server hosting MySQL.

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."

A company is closing one of its remote data centers. This site runs a 100 TB on-premises data warehouse solution. The company plans to use the AWS Schema Conversion Tool (AWS SCT) and AWS DMS for the migration to AWS. The site network bandwidth is 500 Mbps. A Database Specialist wants to migrate the on- premises data using Amazon S3 as the data lake and Amazon Redshift as the data warehouse. This move must take place during a 2-week period when source systems are shut down for maintenance. The data should stay encrypted at rest and in transit.
Which approach has the least risk and the highest likelihood of a successful data transfer?

1. A. Set up a VPN tunnel for encrypting data over the network from the data center to AW
2. B. Leverage AWS SCT and apply the converted schema to Amazon Redshif
3. C. Once complete, start an AWS DMS task tomove the data from the source to Amazon S3. Use AWS Glue to load the data from Amazon S3 to Amazon Redshift.
4. D. Leverage AWS SCT and apply the converted schema to Amazon Redshif
5. E. Start an AWS DMS task with two AWS Snowball Edge devices to copy data from on-premises to Amazon S3 with AWS KMS encryptio
6. F. Use AWS DMS to finish copying data to Amazon Redshift.
7. G. Leverage AWS SCT and apply the converted schema to Amazon Redshif
8. H. Once complete, use a fleet of 10 TB dedicated encrypted drives using the AWS Import/Export feature to copy data from on-premises to Amazon S3 with AWS KMS encryptio
9. I. Use AWS Glue to load the data to Amazon redshift.
10. J. Set up a VPN tunnel for encrypting data over the network from the data center to AW
11. K. Leverage a native database export feature to export the data and compress the file
12. L. Use the aws S3 cp multi-port upload command to upload these files to Amazon S3 with AWS KMS encryptio
13. M. Once complete, load the data to Amazon Redshift using AWS Glue.

Correct Answer: B
https://aws.amazon.com/blogs/database/new-aws-dms-and-aws-snowball-integration-enables-mass-database-mi

A small startup firm wishes to move a 4 TB MySQL database from on-premises to AWS through an Amazon RDS for MySQL DB instance.
Which migration approach would result in the LEAST amount of downtime?

1. A. Deploy a new RDS for MySQL DB instance and configure it for access from the on-premises data cente
2. B. Use the mysqldump utility to create an initial snapshot from the on-premises MySQL server, andcopy it to an Amazon S3 bucke
3. C. Import the snapshot into the DB instance utilizing the MySQL utilities running on an Amazon EC2 instanc
4. D. Immediately point the application to the DB instance.
5. E. Deploy a new Amazon EC2 instance, install the MySQL software on the EC2 instance, and configure networking for access from the on-premises data cente
6. F. Use the mysqldump utility to create a snapshot of the on-premises MySQL serve
7. G. Copy the snapshot into the EC2 instance and restore it into the EC2 MySQL instanc
8. H. Use AWS DMS to migrate data into a new RDS for MySQL DB instanc
9. I. Point the application to the DB instance.
10. J. Deploy a new Amazon EC2 instance, install the MySQL software on the EC2 instance, and configure networking for access from the on-premises data cente
11. K. Use the mysqldump utility to create a snapshot of the on-premises MySQL serve
12. L. Copy the snapshot into an Amazon S3 bucket and import the snapshot into a new RDS for MySQL DB instance using the MySQL utilities running on an EC2 instanc
13. M. Point the application to the DB instance.
14. N. Deploy a new RDS for MySQL DB instance and configure it for access from the on-premises data cente
15. O. Use the mysqldump utility to create an initial snapshot from the on-premises MySQL server, and copy it to an Amazon S3 bucke
16. P. Import the snapshot into the DB instance using the MySQL utilities running on an Amazon EC2 instanc
17. Q. Establish replication into the new DB instance using MySQL replicatio
18. R. Stop application access to the on-premises MySQL server and let the remaining transactions replicate ove
19. S. Point the application to the DB instance.

Correct Answer: D
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.NonRDSRepl.html https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.External.Repl.html

A database specialist was alerted that a production Amazon RDS MariaDB instance with 100 GB of storage was out of space. In response, the database specialist modified the DB instance and added 50 GB of storage capacity. Three hours later, a new alert is generated due to a lack of free space on the same DB instance. The database specialist decides to modify the instance immediately to increase its storage capacity by 20 GB.
What will happen when the modification is submitted?

1. A. The request will fail because this storage capacity is too large.
2. B. The request will succeed only if the primary instance is in active status.
3. C. The request will succeed only if CPU utilization is less than 10%.
4. D. The request will fail as the most recent modification was too soon.

Correct Answer: D
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PIOPS.StorageTypes.html