DBS-C01 sample questions

Question 1

A large financial services company requires that all data be encrypted in transit. A Developer is attempting to connect to an Amazon RDS DB instance using the company VPC for the first time with credentials provided by a Database Specialist. Other members of the Development team can connect, but this user is consistently receiving an error indicating a communications link failure. The Developer asked the Database Specialist to reset the password a number of times, but the error persists.
Which step should be taken to troubleshoot this issue?

Accepted Answer

Ensure that the RDS DB instance’s subnet group includes a public subnet to allow the Developer to connect

Answer

Ensure that the database option group for the RDS DB instance allows ingress from the Developer machine’s IP address

Answer

Ensure that the RDS DB instance has not reached its maximum connections limit

Answer

Ensure that the connection is using SSL and is addressing the port where the RDS DB instance is listening for encrypted connections

Question 2

A large company is using an Amazon RDS for Oracle Multi-AZ DB instance with a Java application. As a part of its disaster recovery annual testing, the company would like to simulate an Availability Zone failure and record how the application reacts during the DB instance failover activity. The company does not want to make any code changes for this activity.

What should the company do to achieve this in the shortest amount of time?

Accepted Answer

Use RDS fault injection queries to simulate the primary node failure

Answer

Use a blue-green deployment with a complete application-level failover test

Answer

Use the RDS console to reboot the DB instance by choosing the option to reboot with failover

Answer

Add a rule to the NACL to deny all traffic on the subnets associated with a single Availability Zone

Question 3

A database specialist is building a system that uses a static vendor dataset of postal codes and related territory information that is less than 1 GB in size. The dataset is loaded into the application’s cache at start up. The company needs to store this data in a way that provides the lowest cost with a low application startup time.

Which approach will meet these requirements?

Accepted Answer

Use an Amazon RDS DB instance. Shut down the instance once the data has been read.

Answer

Use Amazon Aurora Serverless. Allow the service to spin resources up and down, as needed.

Answer

Use Amazon DynamoDB in on-demand capacity mode.

Answer

Use Amazon S3 and load the data from flat files.

Question 4

A media company is using Amazon RDS for PostgreSQL to store user data. The RDS DB instance currently has a publicly accessible setting enabled and is hosted in a public subnet. Following a recent AWS Well-Architected Framework review, a Database Specialist was given new security requirements.

•Only certain on-premises corporate network IPs should connect to the DB instance.
•Connectivity is allowed from the corporate network only.

Which combination of steps does the Database Specialist need to take to meet these new requirements? (Choose three.)

Accepted Answer

Enable VPC peering between the application host running on the corporate network and the VPC associated with the DB instance.

Accepted Answer

Disable the publicly accessible setting.

Accepted Answer

Connect to the DB instance using private IPs and a VPN.

Answer

Modify the pg_hba.conf file. Add the required corporate network IPs and remove the unwanted IPs.

Answer

Modify the associated security group. Add the required corporate network IPs and remove the unwanted IPs.

Answer

Move the DB instance to a private subnet using AWS DMS.

Question 5

A company just migrated to Amazon Aurora PostgreSQL from an on-premises Oracle database. After the migration, the company discovered there is a period of time every day around 3:00 PM where the response time of the application is noticeably slower. The company has narrowed down the cause of this issue to the database and not the application.
Which set of steps should the Database Specialist take to most efficiently find the problematic PostgreSQL query?

Accepted Answer

Enable Amazon RDS Performance Insights on the PostgreSQL database. Use the metrics to identify any queries that are related to spikes in the graph during the next slow period.

Answer

Create an Amazon CloudWatch dashboard to show the number of connections, CPU usage, and disk space consumption. Watch these dashboards during the next slow period.

Answer

Launch an Amazon EC2 instance, and install and configure an open-source PostgreSQL monitoring tool that will run reports based on the output error logs.

Answer

Modify the logging database parameter to log all the queries related to locking in the database and then check the logs after the next slow period for this information.

Question 6

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

Accepted Answer

Long-running statements on the master

Answer

New volumes created from snapshots load lazily in the background

Answer

Insufficient resources on the master

Answer

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

DBS-C01 Sample Questions & Answers

Free DBS-C01 Sample Questions with Answers

Ready for the real thing?

DBS-C01 Sample Questions & Answers

Related practice tests

Ready for the real thing?