DBS-C01 Practice Test

A retail company is about to migrate its online and mobile store to AWS. The company’s CEO has strategic
plans to grow the brand globally. A Database Specialist has been challenged to provide predictable read and
write database performance with minimal operational overhead.
What should the Database Specialist do to meet these requirements?

A.

Use Amazon DynamoDB global tables to synchronize transactions

B.

Use Amazon EMR to copy the orders table data across Regions

C.

Use Amazon Aurora Global Database to synchronize all transactions

D.

Use Amazon DynamoDB Streams to replicate all DynamoDB transactions and sync them

A financial company has allocated an Amazon RDS MariaDB DB instance with large storage capacity to
accommodate migration efforts. Post-migration, the company purged unwanted data from the instance. The
company now want to downsize storage to save money. The solution must have the least impact on production
and near-zero downtime.
Which solution would meet these requirements?

A.

Create a snapshot of the old databases and restore the snapshot with the required storage

B.

Create a new RDS DB instance with the required storage and move the databases from the old
instancesto the new instance using AWS DMS

C.

Create a new database using native backup and restore

D.

Create a new read replica and make it the primary by terminating the existing primary

An ecommerce company has tasked a Database Specialist with creating a reporting dashboard that visualizes
critical business metrics that will be pulled from the core production database running on Amazon Aurora.
Data that is read by the dashboard should be available within 100 milliseconds of an update.
The Database Specialist needs to review the current configuration of the Aurora DB cluster and develop a
cost-effective solution. The solution needs to accommodate the unpredictable read workload from the
reporting dashboard without any impact on the write availability and performance of the DB cluster.
Which solution meets these requirements?

A.

Turn on the serverless option in the DB cluster so it can automatically scale based on demand.

B.

Provision a clone of the existing DB cluster for the new Application team.

C.

Create a separate DB cluster for the new workload, refresh from the source DB cluster, and set up ongoingreplication using AWS DMS change data capture (CDC).

D.

Add an automatic scaling policy to the DB cluster to add Aurora Replicas to the cluster based on
CPUconsumption.

A company is building a new web platform where user requests trigger an AWS Lambda function that
performs an insert into an Amazon Aurora MySQL DB cluster. Initial tests with less than 10 users on the new
platform yielded successful execution and fast response times. However, upon more extensive tests with the
actual target of 3,000 concurrent users, Lambda functions are unable to connect to the DB cluster and receive
too many connections errors.
Which of the following will resolve this issue?

A.

Edit the my.cnf file for the DB cluster to increase max_connections

B.

Increase the instance size of the DB cluster

C.

Change the DB cluster to Multi-AZ

D.

Increase the number of Aurora Replica

A company has multiple applications serving data from a secure on-premises database. The company is
migrating all applications and databases to the AWS Cloud. The IT Risk and Compliance department requires
that auditing be enabled on all secure databases to capture all log ins, log outs, failed logins, permission
changes, and database schema changes. A Database Specialist has recommended Amazon Aurora MySQL as
the migration target, and leveraging the Advanced Auditing feature in Aurora.
Which events need to be specified in the Advanced Auditing configuration to satisfy the minimum auditing
requirements? (Choose three.)

A.

CONNECT

B.

QUERY_DCL

C.

QUERY_DDL

D.

QUERY_DML

E.

TABLE

F.

QUERY