DBS-C01 Practice Test

A Database Specialist modified an existing parameter group currently associated with a production Amazon
RDS for SQL Server Multi-AZ DB instance. The change is associated with a static parameter type, which
controls the number of user connections allowed on the most critical RDS SQL Server DB instance for the
company. This change has been approved for a specific maintenance window to help minimize the impact on
users.
How should the Database Specialist apply the parameter group change for the DB instance?

A.

Select the option to apply the change immediately

B.

Allow the preconfigured RDS maintenance window for the given DB instance to control when the change is applied

C.

Apply the change manually by rebooting the DB instance during the approved maintenance window

D.

Reboot the secondary Multi-AZ DB instance

A Database Specialist is migrating a 2 TB Amazon RDS for Oracle DB instance to an RDS for PostgreSQL
DB instance using AWS DMS. The source RDS Oracle DB instance is in a VPC in the us-east-1 Region. The
target RDS for PostgreSQL DB instance is in a VPC in the use-west-2 Region.
Where should the AWS DMS replication instance be placed for the MOST optimal performance?

A.

In the same Region and VPC of the source DB instance

B.

In the same Region and VPC as the target DB instance

C.

In the same VPC and Availability Zone as the target DB instance

D.

In the same VPC and Availability Zone as the source DB instance

A Database Specialist is setting up a new Amazon Aurora DB cluster with one primary instance and three
Aurora Replicas for a highly intensive, business-critical application. The Aurora DB cluster has one
mediumsized primary instance, one large-sized replica, and two medium sized replicas. The Database
Specialist did not assign a promotion tier to the replicas.
In the event of a primary failure, what will occur?

A.

Aurora will promote an Aurora Replica that is of the same size as the primary instance

B.

Aurora will promote an arbitrary Aurora Replica

C.

Aurora will promote the largest-sized Aurora Replica

D.

Aurora will not promote an Aurora Replica

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 global secondary index with game_id as the partition 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 composite primary key with user_id as the partition key and game_id as the sort key

An ecommerce company is using Amazon DynamoDB as the backend for its order-processing application.
The steady increase in the number of orders is resulting in increased DynamoDB costs. Order verification and
reporting perform many repeated GetItem functions that pull similar datasets, and this read activity is
contributing to the increased costs. The company wants to control these costs without significant development
efforts.
How should a Database Specialist address these requirements?

A.

Use AWS DMS to migrate data from DynamoDB to Amazon DocumentDB

B.

Use Amazon DynamoDB Streams and Amazon Kinesis Data Firehose to push the data into
AmazonRedshift

C.

Use an Amazon ElastiCache for Redis in front of DynamoDB to boost read performance

D.

Use DynamoDB Accelerator to offload the reads