DBS-C01 sample questions

Question 1

A gaming company wants to deploy a game in multiple Regions. The company plans to save local high scores in Amazon DynamoDB tables in each Region. A Database Specialist needs to design a solution to automate the deployment of the database with identical configurations in additional Regions, as needed. The solution should also automate configuration changes across all Regions.

Which solution would meet these requirements and deploy the DynamoDB tables?

Accepted Answer

Create an AWS CloudFormation template and deploy the template to all the Regions.

Answer

Create an AWS CLI command to deploy the DynamoDB table to all the Regions and save it for future deployments.

Answer

Create an AWS CloudFormation template and use a stack set to deploy the template to all the Regions.

Answer

Create DynamoDB tables using the AWS Management Console in all the Regions and create a step-by-step guide for future deployments.

Question 2

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?

Accepted Answer

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

Answer

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

Answer

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

Answer

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

Question 3

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?

Accepted Answer

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

Answer

Increase the size of the DB instance storage

Answer

Disable EBS optimization on the DB instance

Answer

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

Question 4

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 5

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 6

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.

AWS Certified Database Specialty Free Sample Questions

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Lifetime One

Two

Pro Four

Premium Twelve

DBS-C01 Sample Questions

Trusted by professionals at