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?

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

Comment: *

Name: *

Email: *

Verification: *

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?

• A.Run the master in Amazon Aurora MySQL. Create 12 Aurora Replicas in VPC_TEST, and script thereplicas to be deleted and re-created nightly.
• B.Run the master in Amazon Aurora MySQL. Take a nightly snapshot, and restore it into 12 databases inVPC_TEST using Aurora Serverless.
• C.Run the master in Amazon Aurora MySQL using Aurora Serverless. Create 12 clones in VPC_TEST, andscript the clones to be deleted and re-created nightly.
• D.Run the master in Amazon Aurora MySQL. Create 12 clones in VPC_TEST, and script the clones to bedeleted and re-created nightly.

Comment: *

Name: *

Email: *

Verification: *

A company developed a new application that is deployed on Amazon EC2 instances behind an Application Load Balancer. The EC2 instances use the security group named sg-application-servers. The company needs a database to store the data from the application and decides to use an Amazon RDS for MySQL DB instance. The DB instance is deployed in private DB subnet.
What is the MOST restrictive configuration for the DB instance security group?

• A.Only allow incoming traffic from the subnet of the application servers on port 3306.
• B.Only allow incoming traffic from the sg-application-servers security group on port 3306.
• C.Only allow incoming traffic from the subnet of the application servers on port 443.
• D.Only allow incoming traffic from the sg-application-servers security group on port 443.

Comment: *

Name: *

Email: *

Verification: *

A company is running its line of business application on AWS, which uses Amazon RDS for MySQL at the persistent data store. The company wants to minimize downtime when it migrates the database to Amazon Aurora.
Which migration method should a Database Specialist use?

• A.Take a snapshot of the RDS for MySQL DB instance and create a new Aurora DB cluster with the option to migrate snapshots.
• B.Create an Aurora Replica from the RDS for MySQL DB instance and promote the Aurora DB cluster.
• C.Make a backup of the RDS for MySQL DB instance using the mysqldump utility, create a new Aurora DB cluster, and restore the backup.
• D.Create a clone of the RDS for MySQL DB instance and promote the Aurora DB cluster.

Comment: *

Name: *

Email: *

Verification: *

A media company is using Amazon RDS for PostgreSQL to store user dat
a. The RDS DB instance currently has a publicly accessible setting enabled and is hosted in a public subnet. Following a recent AWS Well- Architected Framework review, a Database Specialist was given new security requirements.
Only certain on-premises corporate network IPs should connect to the DB instance. Connectivity is allowed from the corporate network only.
Which combination of steps does the Database Specialist need to take to meet these new requirements? (Choose three.)

• A.Enable VPC peering between the application host running on the corporate network and the VPC associated with the DB instance.
• B.Disable the publicly accessible setting.
• C.Modify the pg_hba.conf file. Add the required corporate network IPs and remove the unwanted IPs.
• D.Modify the associated security group. Add the required corporate network IPs and remove the unwanted IPs.
• E.Move the DB instance to a private subnet using AWS DMS.
• F.Connect to the DB instance using private IPs and a VPN.

Comment: *

Name: *

Email: *

Verification: *