QUESTION: 37

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 eachgame has a unique game_id.

Which choice of keys is recommended for the DynamoDB table?

Create a global secondary index with game_id as the partition key
Create a global secondary index with user_id as the partition key
Create a composite primary key with game_id as the partition key and user_id as the sort key
Create a composite primary key with user_id as the partition key and game_id as the sort key

Answer(s): D

Reference:

https://aws.amazon.com/blogs/database/amazon-dynamodb-gaming-use-cases-and-design- patterns/

Reveal Solution Next Question

QUESTION: 38

A Database Specialist migrated an existing production MySQL database from on-premises to an Amazon RDS for MySQL DB instance. However, after the migration, the database needed to be encrypted at rest using AWS KMS. Due to the size of the database, reloading, the data into an encrypted database would be too time- consuming, so it is not an option.
How should the Database Specialist satisfy this new requirement?

Create a snapshot of the unencrypted RDS DB instance. Create an encrypted copy of the unencrypted snapshot. Restore the encrypted snapshot copy.
Modify the RDS DB instance. Enable the AWS KMS encryption option that leverages the AWS CLI.
Restore an unencrypted snapshot into a MySQL RDS DB instance that is encrypted.
Create an encrypted read replica of the RDS DB instance. Promote it the master.

Answer(s): A

Reveal Solution Next Question

QUESTION: 39

A Database Specialist is planning to create a read replica of an existing Amazon RDS for MySQL Multi-AZ DB instance.
When using the AWS Management Console to conduct this task, the Database Specialist discovers that the source RDS DB instance does not appear in the read replica source selection box, so the read replica cannot be created.
What is the most likely reason for this?

The source DB instance has to be converted to Single-AZ first to create a read replica from it.
Enhanced Monitoring is not enabled on the source DB instance.
The minor MySQL version in the source DB instance does not support read replicas.
Automated backups are not enabled on the source DB instance.

Answer(s): D

Explanation:

Reference:

https://aws.amazon.com/rds/features/read-replicas/

Reveal Solution Next Question

QUESTION: 40

A Database Specialist has migrated an on-premises Oracle database to Amazon Aurora PostgreSQL. The schema and the data have been migrated successfully. The on-premises database server was also being used to run database maintenance cron jobs written in Python to perform tasks including data purging and generating data exports. The logs for these jobs show that, most of the time, the jobs completed within 5 minutes, but a few jobs took up to 10 minutes to complete. These maintenance jobs need to be set up for Aurora PostgreSQL.
How can the Database Specialist schedule these jobs so the setup requires minimal maintenance and provides high availability?

Create cron jobs on an Amazon EC2 instance to run the maintenance jobs following the required schedule.
Connect to the Aurora host and create cron jobs to run the maintenance jobs following the required schedule.
Create AWS Lambda functions to run the maintenance jobs and schedule them with Amazon CloudWatch Events.
Create the maintenance job using the Amazon CloudWatch job scheduling plugin.

Answer(s): C

Reference:

https://docs.aws.amazon.com/systems-manager/latest/userguide/mw-cli-task-options.html

Reveal Solution Next Question

Free DBS-C01 Exam Braindumps (page: 10)

QUESTION: 37

Reference:

QUESTION: 38

QUESTION: 39

Explanation:

Reference:

QUESTION: 40

Reference: