Free AWS-Certified-Database-Specialty Exam Braindumps

A large retail company recently migrated its three-tier ecommerce applications to AWS. The company’s backend database is hosted on Amazon Aurora PostgreSQL. During peak times, users complain about longer page load times. A database specialist reviewed Amazon RDS Performance Insights and found a spike in IO:XactSync wait events. The SQL attached to the wait events are all single INSERT statements.
How should this issue be resolved?

1. A. Modify the application to commit transactions in batches
2. B. Add a new Aurora Replica to the Aurora DB cluster.
3. C. Add an Amazon ElastiCache for Redis cluster and change the application to write through.
4. D. Change the Aurora DB cluster storage to Provisioned IOPS (PIOPS).

Correct Answer: A
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Reference.html "This wait most often arises when there is a very high rate of commit activity on the system. You can
sometimes alleviate this wait by modifying applications to commit transactions in batches. "
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/apg-waits.xactsync.html

Developers have requested a new Amazon Redshift cluster so they can load new third-party marketing data. The new cluster is ready and the user credentials are given to the developers. The developers indicate that their copy jobs fail with the following error message:
“Amazon Invalid operation: S3ServiceException:Access Denied,Status 403,Error AccessDenied.”
The developers need to load this data soon, so a database specialist must act quickly to solve this issue. What is the MOST secure solution?

1. A. Create a new IAM role with the same user name as the Amazon Redshift developer user I
2. B. Provide the IAM role with read-only access to Amazon S3 with the assume role action.
3. C. Create a new IAM role with read-only access to the Amazon S3 bucket and include the assume role actio
4. D. Modify the Amazon Redshift cluster to add the IAM role.
5. E. Create a new IAM role with read-only access to the Amazon S3 bucket with the assume role actio
6. F. Add this role to the developer IAM user ID used for the copy job that ended with an error message.
7. G. Create a new IAM user with access keys and a new role with read-only access to the Amazon S3 bucket.Add this role to the Amazon Redshift cluste
8. H. Change the copy job to use the access keys created.

Correct Answer: B
https://docs.aws.amazon.com/redshift/latest/gsg/rs-gsg-create-an-iam-role.html
"Now that you have created the new role, your next step is to attach it to your cluster. You can attach the role when you launch a new cluster or you can attach it to an existing cluster. In the next step, you attach the role to a new cluster."
https://docs.aws.amazon.com/redshift/latest/dg/copy-usage_notes-access-permissions.html

A business uses Amazon EC2 instances in VPC A to serve an internal file-sharing application. This application is supported by an Amazon ElastiCache cluster in VPC B that is peering with VPC A. The corporation migrates the instances of its applications from VPC A to VPC B. The file-sharing application is no longer able to connect to the ElastiCache cluster, as shown by the logs.
What is the best course of action for a database professional to take in order to remedy this issue?

1. A. Create a second security group on the EC2 instance
2. B. Add an outbound rule to allow traffic from the ElastiCache cluster security group.
3. C. Delete the ElastiCache security grou
4. D. Add an interface VPC endpoint to enable the EC2 instances to connect to the ElastiCache cluster.
5. E. Modify the ElastiCache security group by adding outbound rules that allow traffic to VPC CIDR blocks from the ElastiCache cluster.
6. F. Modify the ElastiCache security group by adding an inbound rule that allows traffic from the EC2 instances security group to the ElastiCache cluster.

Correct Answer: D
https://docs.aws.amazon.com/vpc/latest/peering/vpc-peering-security-groups.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

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?

1. A. The database is deployed in a VPC that is in a different Region.
2. B. The database is deployed in a VPC that is in a different Availability Zone.
3. C. The database is deployed with misconfigured security groups.
4. D. The database is deployed with the wrong client connect timeout configuration.

Correct Answer: C
"A VPC peering connection is a networking connection between two VPCs that enables you to route traffic between them using private IP addresses. Instances in either VPC can communicate with each other as if they are within the same network. You can create a VPC peering connection between your own VPCs, with a VPC in another AWS account, or with a VPC in a different AWS Region." https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_VPC.Scenarios.html