A company is looking to migrate a 1 TB Oracle database from on-premises to an Amazon Aurora PostgreSQL DB cluster. The company’s Database Specialist discovered that the Oracle database is storing 100 GB of large binary objects (LOBs) across multiple tables. The Oracle database has a maximum LOB size of 500 MB with an average LOB size of 350 MB. The Database Specialist has chosen AWS DMS to migrate the data with the largest replication instances.
How should the Database Specialist optimize the database migration using AWS DMS?

1. A. Create a single task using full LOB mode with a LOB chunk size of 500 MB to migrate the data and LOBs together
2. B. Create two tasks: task1 with LOB tables using full LOB mode with a LOB chunk size of 500 MB and task2 without LOBs
3. C. Create two tasks: task1 with LOB tables using limited LOB mode with a maximum LOB size of 500 MB and task 2 without LOBs
4. D. Create a single task using limited LOB mode with a maximum LOB size of 500 MB to migrate data and LOBs together

Correct Answer: C

A company is using Amazon RDS for MySQL to redesign its business application. A Database Specialist has noticed that the Development team is restoring their MySQL database multiple times a day when Developers make mistakes in their schema updates. The Developers sometimes need to wait hours to the restores to complete.
Multiple team members are working on the project, making it difficult to find the correct restore point for each mistake.
Which approach should the Database Specialist take to reduce downtime?

1. A. Deploy multiple read replicas and have the team members make changes to separate replica instances
2. B. Migrate to Amazon RDS for SQL Server, take a snapshot, and restore from the snapshot
3. C. Migrate to Amazon Aurora MySQL and enable the Aurora Backtrack feature
4. D. Enable the Amazon RDS for MySQL Backtrack feature

Correct Answer: C
"Amazon Aurora, a fully-managed relational database service in AWS, is now offering a backtrack feature. With Amazon Aurora with MySQL compatibility, users can backtrack, or "rewind", a database cluster to a specific point in time, without restoring data from a backup. The backtrack process allows a point in time to be specified with one second resolution, and the rewind process typically takes minutes. This new feature facilitates developers in undoing mistakes like deleting data inappropriately or dropping the wrong table."

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

A company’s database specialist disabled TLS on an Amazon DocumentDB cluster to perform benchmarking tests. A few days after this change was implemented, a database specialist trainee accidentally deleted multiple tables. The database specialist restored the database from available snapshots. An hour after restoring the cluster, the database specialist is still unable to connect to the new cluster endpoint.
What should the database specialist do to connect to the new, restored Amazon DocumentDB cluster?

1. A. Change the restored cluster’s parameter group to the original cluster’s custom parameter group.
2. B. Change the restored cluster’s parameter group to the Amazon DocumentDB default parameter group.
3. C. Configure the interface VPC endpoint and associate the new Amazon DocumentDB cluster.
4. D. Run the syncInstances command in AWS DataSync.

Correct Answer: A
You can't modify the parameter settings of the default parameter groups. You can use a DB parameter group to act as a container for engine configuration values that are applied to one or more DB instances. If you create a DB instance without specifying a DB parameter group, the DB instance uses a default DB parameter group. Each default DB parameter group contains database engine defaults and Amazon RDS system defaults. You can't modify the parameter settings of a default parameter group. Instead, you create your own parameter group where you choose your own parameter settings. Not all DB engine parameters can be changed in a parameter group that you create.

On AWS, a business is developing a web application. The application needs that the database supports concurrent read and write activities in several AWS Regions. Additionally, the database must communicate data changes across Regions as they occur. The application must be highly available and have a latency of less than a few hundred milliseconds.
Which solution satisfies these criteria?

1. A. Amazon DynamoDB global tables
2. B. Amazon DynamoDB streams with AWS Lambda to replicate the data
3. C. An Amazon ElastiCache for Redis cluster with cluster mode enabled and multiple shards
4. D. An Amazon Aurora global database

Correct Answer: A
Aurora Global Databases provides a writer and a reader endpoints in the primary region but only a reader endpoints in other region. Although strongly consistent, it does not fulfill the requirements that "there are plenty of read / write activities" in all regions.