A company has migrated a single MySQL database to Amazon Aurora. The production data is hosted in a DB cluster in VPC_PROD, and 12 testing environments are hosted in VPC_TEST using the same AWS account. Testing results in minimal changes to the test data. The Development team wants each environment refreshed nightly so each test database contains fresh production data every day.
Which migration approach will be the fastest and most cost-effective to implement?

1. A. Run the master in Amazon Aurora MySQ
2. B. Create 12 clones in VPC_TEST, and script the clones to be deleted and re-created nightly.
3. C. Run the master in Amazon Aurora MySQ
4. D. Take a nightly snapshot, and restore it into 12 databases in VPC_TEST using Aurora Serverless.
5. E. Run the master in Amazon Aurora MySQ
6. F. Create 12 Aurora Replicas in VPC_TEST, and script the replicas to be deleted and re-created nightly.
7. G. Run the master in Amazon Aurora MySQL using Aurora Serverles
8. H. Create 12 clones in VPC_TEST, and script the clones to be deleted and re-created nightly.

Correct Answer: A

A financial company wants to store sensitive user data in an Amazon Aurora PostgreSQL DB cluster. The database will be accessed by multiple applications across the company. The company has mandated that all communications to the database be encrypted and the server identity must be validated. Any non-SSL-based connections should be disallowed access to the database.
Which solution addresses these requirements?

1. A. Set the rds.force_ssl=0 parameter in DB parameter group
2. B. Download and use the Amazon RDS certificate bundle and configure the PostgreSQL connection string with sslmode=allow.
3. C. Set the rds.force_ssl=1 parameter in DB parameter group
4. D. Download and use the Amazon RDS certificate bundle and configure the PostgreSQL connection string with sslmode=disable.
5. E. Set the rds.force_ssl=0 parameter in DB parameter group
6. F. Download and use the Amazon RDS certificate bundle and configure the PostgreSQL connection string with sslmode=verify-ca.
7. G. Set the rds.force_ssl=1 parameter in DB parameter group
8. H. Download and use the Amazon RDS certificate bundle and configure the PostgreSQL connection string with sslmode=verify-full.

Correct Answer: D
PostgreSQL: sslrootcert=rds-cert.pem sslmode=[verify-ca | verify-full]

A business that specializes in internet advertising is developing an application that will show adverts to its customers. The program stores data in an Amazon DynamoDB database. Additionally, the application caches its reads using a DynamoDB Accelerator (DAX) cluster. The majority of reads come via the GetItem and BatchGetItem queries. The application does not need consistency of readings.
The application cache does not behave as intended after deployment. Specific extremely consistent queries to the DAX cluster are responding in several milliseconds rather than microseconds.
How can the business optimize cache behavior in order to boost application performance?

1. A. Increase the size of the DAX cluster.
2. B. Configure DAX to be an item cache with no query cache
3. C. Use eventually consistent reads instead of strongly consistent reads.
4. D. Create a new DAX cluster with a higher TTL for the item cache.

Correct Answer: C

Recently, a gaming firm purchased a popular iOS game that is especially popular during the Christmas season. The business has opted to include a leaderboard into the game, which will be powered by Amazon DynamoDB. The application's load is likely to increase significantly throughout the Christmas season.
Which solution satisfies these criteria at the lowest possible cost?

1. A. DynamoDB Streams
2. B. DynamoDB with DynamoDB Accelerator
3. C. DynamoDB with on-demand capacity mode
4. D. DynamoDB with provisioned capacity mode with Auto Scaling

Correct Answer: D
"On-demand is ideal for bursty, new, or unpredictable workloads whose traffic can spike in seconds or minutes"
vs.
'DynamoDB released auto scaling to make it easier for you to manage capacity efficiently, and auto scaling continues to help DynamoDB users lower the cost of workloads that have a predictable traffic pattern."
https://aws.amazon.com/blogs/database/amazon-dynamodb-auto-scaling-performance-and-cost-optimization-at

A business's production database is hosted on a single-node Amazon RDS for MySQL DB instance. The database instance is hosted in a United States AWS Region.
A week before a significant sales event, a fresh database maintenance update is released. The maintenance update has been designated as necessary. The firm want to minimize the database instance's downtime and requests that a database expert make the database instance highly accessible until the sales event concludes.
Which solution will satisfy these criteria?

1. A. Defer the maintenance update until the sales event is over.
2. B. Create a read replica with the latest updat
3. C. Initiate a failover before the sales event.
4. D. Create a read replica with the latest updat
5. E. Transfer all read-only traffic to the read replica during the sales event.
6. F. Convert the DB instance into a Multi-AZ deploymen
7. G. Apply the maintenance update.

Correct Answer: D
https://aws.amazon.com/premiumsupport/knowledge-center/rds-required-maintenance/