Recently, a financial institution created a portfolio management service. The application's backend is powered by Amazon Aurora, which supports MySQL.
The firm demands a response time of five minutes and a response time of five minutes. A database professional must create a disaster recovery system that is both efficient and has a low replication latency.
How should the database professional tackle these requirements?

1. A. Configure AWS Database Migration Service (AWS DMS) and create a replica in a different AWS Region.
2. B. Configure an Amazon Aurora global database and add a different AWS Region.
3. C. Configure a binlog and create a replica in a different AWS Region.
4. D. Configure a cross-Region read replica.

Correct Answer: B
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-global-database-disaster-recovery.ht https://aws.amazon.com/blogs/database/how-to-choose-the-best-disaster-recovery-option-for-your-amazon-auro
https://aws.amazon.com/about-aws/whats-new/2019/11/aurora-supports-in-place-conversion-to-global-database/

A company maintains several databases using Amazon RDS for MySQL and PostgreSQL. Each RDS database generates log files with retention periods set to their default values. The company has now mandated that database logs be maintained for up to 90 days in a centralized repository to facilitate real-time and afterthe-fact analyses.
What should a Database Specialist do to meet these requirements with minimal effort?

1. A. Create an AWS Lambda function to pull logs from the RDS databases and consolidate the log files in an Amazon S3 bucke
2. B. Set a lifecycle policy to expire the objects after 90 days.
3. C. Modify the RDS databases to publish log to Amazon CloudWatch Log
4. D. Change the log retention policy for each log group to expire the events after 90 days.
5. E. Write a stored procedure in each RDS database to download the logs and consolidate the log files in an Amazon S3 bucke
6. F. Set a lifecycle policy to expire the objects after 90 days.
7. G. Create an AWS Lambda function to download the logs from the RDS databases and publish the logs to Amazon CloudWatch Log
8. H. Change the log retention policy for the log group to expire the events after 90 days.

Correct Answer: B
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.html https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_LogAccess.Procedural.UploadtoCloudWat https://aws.amazon.com/premiumsupport/knowledge-center/rds-aurora-mysql-logs-cloudwatch/ https://docs.aws.amazon.com/AmazonCloudWatchLogs/latest/APIReference/API_PutRetentionPolicy.html

An AWS CloudFormation stack that included an Amazon RDS DB instance was accidentally deleted and recent data was lost. A Database Specialist needs to add RDS settings to the CloudFormation template to reduce the chance of accidental instance data loss in the future.
Which settings will meet this requirement? (Choose three.)

1. A. Set DeletionProtection to True
2. B. Set MultiAZ to True
3. C. Set TerminationProtection to True
4. D. Set DeleteAutomatedBackups to False
5. E. Set DeletionPolicy to Delete
6. F. Set DeletionPolicy to Retain

Correct Answer: ACF

A Database Specialist needs to define a database migration strategy to migrate an on-premises Oracle database to an Amazon Aurora MySQL DB cluster. The company requires near-zero downtime for the data migration. The solution must also be cost-effective.
Which approach should the Database Specialist take?

1. A. Dump all the tables from the Oracle database into an Amazon S3 bucket using datapump (expdp). Run data transformations in AWS Glu
2. B. Load the data from the S3 bucket to the Aurora DB cluster.
3. C. Order an AWS Snowball appliance and copy the Oracle backup to the Snowball applianc
4. D. Once the Snowball data is delivered to Amazon S3, create a new Aurora DB cluste
5. E. Enable the S3 integration to migrate the data directly from Amazon S3 to Amazon RDS.
6. F. Use the AWS Schema Conversion Tool (AWS SCT) to help rewrite database objects to MySQL during the schema migratio
7. G. Use AWS DMS to perform the full load and change data capture (CDC) tasks.
8. H. Use AWS Server Migration Service (AWS SMS) to import the Oracle virtual machine image as an Amazon EC2 instanc
9. I. Use the Oracle Logical Dump utility to migrate the Oracle data from Amazon EC2 to an Aurora DB cluster.

Correct Answer: C
https://aws.amazon.com/blogs/database/migrating-oracle-databases-with-near-zero-downtime-using-aws-dms/

A business is transferring its on-premises database workloads to the Amazon Web Services (AWS) Cloud. A database professional migrating an Oracle database with a huge table to Amazon RDS has picked AWS DMS. The database professional observes that AWS DMS is consuming considerable time migrating the data.
Which activities would increase the pace of data migration? (Select three.)

1. A. Create multiple AWS DMS tasks to migrate the large table.
2. B. Configure the AWS DMS replication instance with Multi-AZ.
3. C. Increase the capacity of the AWS DMS replication server.
4. D. Establish an AWS Direct Connect connection between the on-premises data center and AWS.
5. E. Enable an Amazon RDS Multi-AZ configuration.
6. F. Enable full large binary object (LOB) mode to migrate all LOB data for all large tables.

Correct Answer: ACD
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.LOBSupport.html