DBS-C01 Practice Test

A financial services company is developing a shared data service that supports different applications from
throughout the company. A Database Specialist designed a solution to leverage Amazon ElastiCache for Redis
with cluster mode enabled to enhance performance and scalability. The cluster is configured to listen on port
6379.
Which combination of steps should the Database Specialist take to secure the cache data and protect it from
unauthorized access? (Choose three.)

A.

Enable in-transit and at-rest encryption on the ElastiCache cluster.

B.

Ensure that Amazon CloudWatch metrics are configured in the ElastiCache cluster.

C.

Ensure the security group for the ElastiCache cluster allows all inbound traffic from itself and inbound
traffic on TCP port 6379 from trusted clients only.

D.

Create an IAM policy to allow the application service roles to access all ElastiCache API actions.

E.

Ensure the security group for the ElastiCache clients authorize inbound TCP port 6379 and port 22
traffic from the trusted ElastiCache cluster’s security group.

F.

Ensure the cluster is created with the auth-token parameter and that the parameter is used in all
subsequent commands.

A company is looking to move an on-premises IBM Db2 database running AIX on an IBM POWER7 server.
Due to escalating support and maintenance costs, the company is exploring the option of moving the workload
to an Amazon Aurora PostgreSQL DB cluster.
What is the quickest way for the company to gather data on the migration compatibility?

A.

Perform a logical dump from the Db2 database and restore it to an Aurora DB cluster. Identify the gaps
andcompatibility of the objects migrated by comparing row counts from source and target tables.

B.

Run AWS DMS from the Db2 database to an Aurora DB cluster. Identify the gaps and compatibility of
theobjects migrated by comparing the row counts from source and target tables.

C.

Run native PostgreSQL logical replication from the Db2 database to an Aurora DB cluster to evaluate
themigration compatibility.

D.

Run the AWS Schema Conversion Tool (AWS SCT) from the Db2 database to an Aurora DB cluster.Create a migration assessment report to evaluate the migration compatibility.

A company is planning to close for several days. A Database Specialist needs to stop all applications
alongwith the DB instances to ensure employees do not have access to the systems during this time. All
databasesare running on Amazon RDS for MySQL.
The Database Specialist wrote and executed a script to stop all the DB instances. When reviewing the logs,the
Database Specialist found that Amazon RDS DB instances with read replicas did not stop.
How should the Database Specialist edit the script to fix this issue?

A.

Stop the source instances before stopping their read replicas

B.

Delete each read replica before stopping its corresponding source instance

C.

Stop the read replicas before stopping their source instances

D.

Use the AWS CLI to stop each read replica and source instance at the same

An Amazon RDS EBS-optimized instance with Provisioned IOPS (PIOPS) storage is using less than half of its
allocated IOPS over the course of several hours under constant load. The RDS instance exhibits multi-second
read and write latency, and uses all of its maximum bandwidth for read throughput, yet the instance uses less
than half of its CPU and RAM resources.
What should a Database Specialist do in this situation to increase performance and return latency to
sub-second levels?

A.

Increase the size of the DB instance storage

B.

Change the underlying EBS storage type to General Purpose SSD (gp2)

C.

Disable EBS optimization on the DB instance

D.

Change the DB instance to an instance class with a higher maximum bandwidth

A Database Specialist is troubleshooting an application connection failure on an Amazon Aurora DB cluster
with multiple Aurora Replicas that had been running with no issues for the past 2 months. The connection
failure lasted for 5 minutes and corrected itself after that. The Database Specialist reviewed the Amazon RDS
events and determined a failover event occurred at that time. The failover process took around 15 seconds to
complete.
What is the MOST likely cause of the 5-minute connection outage?

A.

After a database crash, Aurora needed to replay the redo log from the last database checkpoint

B.

The client-side application is caching the DNS data and its TTL is set too high

C.

After failover, the Aurora DB cluster needs time to warm up before accepting client connections

D.

There were no active Aurora Replicas in the Aurora DB cluster