Free AWS-Certified-Database-Specialty Exam Braindumps

A financial organization must ensure that the most current 90 days of MySQL database backups are accessible. Amazon RDS for MySQL DB instances are used to host all MySQL databases. A database expert must create
a solution that satisfies the criteria for backup retention with the least amount of development work feasible. Which strategy should the database administrator take?

1. A. Use AWS Backup to build a backup plan for the required retention perio
2. B. Assign the DB instances to the backup plan.
3. C. Modify the DB instances to enable the automated backup optio
4. D. Select the required backup retention period.
5. E. Automate a daily cron job on an Amazon EC2 instance to create MySQL dumps, transfer to Amazon S3, and implement an S3 Lifecycle policy to meet the retention requirement.
6. F. Use AWS Lambda to schedule a daily manual snapshot of the DB instance
7. G. Delete snapshots that exceed the retention requirement.

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

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

A Database Specialist has migrated an on-premises Oracle database to Amazon Aurora PostgreSQL. The schema and the data have been migrated successfully. The on-premises database server was also being used to run database maintenance cron jobs written in Python to perform tasks including data purging and generating data exports. The logs for these jobs show that, most of the time, the jobs completed within 5 minutes, but a few jobs took up to 10 minutes to complete. These maintenance jobs need to be set up for Aurora PostgreSQL.
How can the Database Specialist schedule these jobs so the setup requires minimal maintenance and provides high availability?

1. A. Create cron jobs on an Amazon EC2 instance to run the maintenance jobs following the required schedule.
2. B. Connect to the Aurora host and create cron jobs to run the maintenance jobs following the required schedule.
3. C. Create AWS Lambda functions to run the maintenance jobs and schedule them with Amazon CloudWatch Events.
4. D. Create the maintenance job using the Amazon CloudWatch job scheduling plugin.

Correct Answer: C
https://docs.aws.amazon.com/AmazonCloudWatch/latest/events/Create-CloudWatch-Events-Scheduled-Rule.ht https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/schedule-jobs-for-amazon-rds-and-aurora-pos a job for data extraction or a job for data purging can easily be scheduled using cron. For these jobs, database credentials are typically either hard-coded or stored in a properties file. However, when you migrate to Amazon Relational Database Service (Amazon RDS) or Amazon Aurora PostgreSQL, you lose the ability to log in to the host instance to schedule cron jobs. This pattern describes how to use AWS Lambda and AWS Secrets Manager to schedule jobs for Amazon RDS and Aurora PostgreSQL databases after migration.
https://docs.aws.amazon.com/AmazonCloudWatch/latest/events/RunLambdaSchedule.html

A manufacturing company’s website uses an Amazon Aurora PostgreSQL DB cluster.
Which configurations will result in the LEAST application downtime during a failover? (Choose three.)

1. A. Use the provided read and write Aurora endpoints to establish a connection to the Aurora DB cluster.
2. B. Create an Amazon CloudWatch alert triggering a restore in another Availability Zone when the primary Aurora DB cluster is unreachable.
3. C. Edit and enable Aurora DB cluster cache management in parameter groups.
4. D. Set TCP keepalive parameters to a high value.
5. E. Set JDBC connection string timeout variables to a low value.
6. F. Set Java DNS caching timeouts to a high value.

Correct Answer: ABC

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