DBS-C01 Practice Test

A Database Specialist must create a read replica to isolate read-only queries for an Amazon RDS for
MySQLDB instance. Immediately after creating the read replica, users that query it report slow response
times.
What could be causing these slow response times?

A.

New volumes created from snapshots load lazily in the background

B.

Long-running statements on the master

C.

Insufficient resources on the master

D.

Overload of a single replication thread by excessive writes on the master

A Database Specialist is migrating an on-premises Microsoft SQL Server application database to Amazon
RDS for PostgreSQL using AWS DMS. The application requires minimal downtime when the RDS DB
instance goes live.
What change should the Database Specialist make to enable the migration?

A.

Configure the on-premises application database to act as a source for an AWS DMS full load with
ongoing change data capture (CDC)

B.

Configure the AWS DMS replication instance to allow both full load and ongoing change data
capture(CDC)

C.

Configure the AWS DMS task to generate full logs to allow for ongoing change data capture (CDC)

D.

Configure the AWS DMS connections to allow two-way communication to allow for ongoing change
datacapture (CDC)

A company is running an Amazon RDS for PostgeSQL DB instance and wants to migrate it to an Amazon
Aurora PostgreSQL DB cluster. The current database is 1 TB in size. The migration needs to have minimal
downtime.
What is the FASTEST way to accomplish this?

A.

Create an Aurora PostgreSQL DB cluster. Set up replication from the source RDS for PostgreSQL DB
instance using AWS DMS to the target DB cluster.

B.

Use the pg_dump and pg_restore utilities to extract and restore the RDS for PostgreSQL DB instance to
the Aurora PostgreSQL DB cluster.

C.

Create a database snapshot of the RDS for PostgreSQL DB instance and use this snapshot to create the
Aurora PostgreSQL DB cluster.

D.

Migrate data from the RDS for PostgreSQL DB instance to an Aurora PostgreSQL DB cluster using an
Aurora Replica. Promote the replica during the cutover.

A team of Database Specialists is currently investigating performance issues on an Amazon RDS for MySQL
DB instance and is reviewing related metrics. The team wants to narrow the possibilities down to specific
database wait events to better understand the situation.
How can the Database Specialists accomplish this?

A.

Enable the option to push all database logs to Amazon CloudWatch for advanced analysis

B.

Create appropriate Amazon CloudWatch dashboards to contain specific periods of time

C.

Enable Amazon RDS Performance Insights and review the appropriate dashboard

D.

Enable Enhanced Monitoring will the appropriate settings

A company is using 5 TB Amazon RDS DB instances and needs to maintain 5 years of monthly databasebackups for compliance purposes. A Database Administrator must provide Auditors with data within 24 hours.
Which solution will meet these requirements and is the MOST operationally efficient?

A.

Create an AWS Lambda function to run on the first day of every month to take a manual RDS
snapshot.Move the snapshot to the company’s Amazon S3 bucket.

B.

Create an AWS Lambda function to run on the first day of every month to take a manual RDS snapshot.

C.

Create an RDS snapshot schedule from the AWS Management Console to take a snapshot every 30
days.

D.

Create an AWS Lambda function to run on the first day of every month to create an automated
RDSsnapshot