DBS-C01 Practice Test

A company has a database monitoring solution that uses Amazon CloudWatch for its Amazon RDS for SQL
Server environment. The cause of a recent spike in CPU utilization was not determined using the standard
metrics that were collected. The CPU spike caused the application to perform poorly, impacting users. A
Database Specialist needs to determine what caused the CPU spike.
Which combination of steps should be taken to provide more visibility into the processes and queries running
during an increase in CPU load? (Choose two.)

A.

Enable Amazon CloudWatch Events and view the incoming T-SQL statements causing the CPU to spike.

B.

Enable Enhanced Monitoring metrics to view CPU utilization at the RDS SQL Server DB instance level.
I

C.

mplement a caching layer to help with repeated queries on the RDS SQL Server DB instance.

D.

Use Amazon QuickSight to view the SQL statement being run.

E.

Enable Amazon RDS Performance Insights to view the database load and filter the load by waits,
SQLstatements, hosts, or users.

A company is using Amazon RDS for MySQL to redesign its business application. A Database Specialist has
noticed that the Development team is restoring their MySQL database multiple times a day when Developers
make mistakes in their schema updates. The Developers sometimes need to wait hours to the restores to
complete.
Multiple team members are working on the project, making it difficult to find the correct restore point for each
mistake.
Which approach should the Database Specialist take to reduce downtime?

A.

Deploy multiple read replicas and have the team members make changes to separate replica instances

B.

Migrate to Amazon RDS for SQL Server, take a snapshot, and restore from the snapshot

C.

Migrate to Amazon Aurora MySQL and enable the Aurora Backtrack feature

D.

Enable the Amazon RDS for MySQL Backtrack feature

A company is using Amazon RDS for PostgreSQL. The Security team wants all database connection requests
to be logged and retained for 180 days. The RDS for PostgreSQL DB instance is currently using the default
parameter group. A Database Specialist has identified that setting the log_connections parameter to 1 will
enable connections logging.
Which combination of steps should the Database Specialist take to meet the logging and retention
requirements? (Choose two.)

A.

Update the log_connections parameter in the default parameter group

B.

Create a custom parameter group, update the log_connections parameter, and associate the parameterwith the DB instance

C.

Enable publishing of database engine logs to Amazon CloudWatch Logs and set the event expiration
to180 days

D.

Enable publishing of database engine logs to an Amazon S3 bucket and set the lifecycle policy to 180
days

E.

Connect to the RDS PostgreSQL host and update the log_connections parameter in the postgresql.conf
file

A gaming company is designing a mobile gaming app that will be accessed by many users across the globe.
The company wants to have replication and full support for multi-master writes. The company also wants to
ensure low latency and consistent performance for app users.
Which solution meets these requirements?

A.

Use Amazon DynamoDB global tables for storage and enable DynamoDB automatic scaling

B.

Use Amazon Aurora for storage and enable cross-Region Aurora Replicas

C.

Use Amazon Aurora for storage and cache the user content with Amazon ElastiCache

D.

Use Amazon Neptune for storage

A Database Specialist needs to speed up any failover that might occur on an Amazon Aurora PostgreSQL DB
cluster. The Aurora DB cluster currently includes the primary instance and three Aurora Replicas.
How can the Database Specialist ensure that failovers occur with the least amount of downtime for the
application?

A.

Set the TCP keepalive parameters low

B.

Call the AWS CLI failover-db-cluster command

C.

Enable Enhanced Monitoring on the DB cluster

D.

Start a database activity stream on the DB cluster