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/

An online gaming company is planning to launch a new game with Amazon DynamoDB as its data store. The database should be designated to support the following use cases:
Update scores in real time whenever a player is playing the game. Retrieve a player’s score details for a specific game session.
A Database Specialist decides to implement a DynamoDB table. Each player has a unique user_id and each game has a unique game_id.
Which choice of keys is recommended for the DynamoDB table?

1. A. Create a global secondary index with game_id as the partition key
2. B. Create a global secondary index with user_id as the partition key
3. C. Create a composite primary key with game_id as the partition key and user_id as the sort key
4. D. Create a composite primary key with user_id as the partition key and game_id as the sort key

Correct Answer: D
https://aws.amazon.com/blogs/database/amazon-dynamodb-gaming-use-cases-and-design-patterns/ "EA uses the user ID as the partition key and primary key (a 1:1 modeling pattern)."
https://aws.amazon.com/blogs/database/choosing-the-right-dynamodb-partition-key/
"Partition key and sort key: Referred to as a composite primary key, this type of key is composed of two attributes. The first attribute is the partition key, and the second attribute is the sort key."

A company uses Amazon Aurora for secure financial transactions. The data must always be encrypted at rest and in transit to meet compliance requirements.
Which combination of actions should a database specialist take to meet these requirements? (Choose two.)

1. A. Create an Aurora Replica with encryption enabled using AWS Key Management Service (AWS KMS).Then promote the replica to master.
2. B. Use SSL/TLS to secure the in-transit connection between the financial application and the Aurora DB cluster.
3. C. Modify the existing Aurora DB cluster and enable encryption using an AWS Key Management Service (AWS KMS) encryption ke
4. D. Apply the changes immediately.
5. E. Take a snapshot of the Aurora DB cluster and encrypt the snapshot using an AWS Key Management Service (AWS KMS) encryption ke
6. F. Restore the snapshot to a new DB cluster and update the financial application database endpoints.
7. G. Use AWS Key Management Service (AWS KMS) to secure the in-transit connection between the financial application and the Aurora DB cluster.

Correct Answer: AB
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-replicas-adding.html

A company is migrating its on-premises database workloads to the AWS Cloud. A database specialist
performing the move has chosen AWS DMS to migrate an Oracle database with a large table to Amazon RDS. The database specialist notices that AWS DMS is taking significant time to migrate the data.
Which actions would improve the data migration speed? (Choose 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: CDE

A global digital advertising company captures browsing metadata to contextually display relevant images, pages, and links to targeted users. A single page load can generate multiple events that need to be stored individually. The maximum size of an event is 200 KB and the average size is 10 KB. Each page load must query the user’s browsing history to provide targeting recommendations. The advertising company expects over 1 billion page visits per day from users in the United States, Europe, Hong Kong, and India. The structure of the metadata varies depending on the event. Additionally, the browsing metadata must be written and read with very low latency to ensure a good viewing experience for the users.
Which database solution meets these requirements?

1. A. Amazon DocumentDB
2. B. Amazon RDS Multi-AZ deployment
3. C. Amazon DynamoDB global table
4. D. Amazon Aurora Global Database

Correct Answer: C