DBS-C01 sample questions

Question 1

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

Question 2

A company is going through a security audit. The audit team has identified cleartext master user password in the AWS CloudFormation templates for Amazon RDS for MySQL DB instances. The audit team has flagged this as a security risk to the database team.

What should a database specialist do to mitigate this risk?

Accepted Answer

Remove the passwords from the CloudFormation templates so Amazon RDS prompts for the password when the database is being created.

Answer

Change all the databases to use AWS 1AM for authentication and remove all the cleartext passwords in CloudFormation templates.

Answer

Use an AWS Secrets Manager resource to generate a random password and reference the secret in the CloudFormation template.

Answer

Remove the passwords from the CloudFormation template and store them in a separate file. Replace the passwords by running CloudFormation using a sed command.

Question 3

A database specialist is responsible for an Amazon RDS for MySQL DB instance with one read replica. The DB instance and the read replica are assigned to the default parameter group. The database team currently runs test queries against a read replica. The database team wants to create additional tables in the read replica that will only be accessible from the read replica to benefit the tests.

Which should the database specialist do to allow the database team to create the test tables?

Accepted Answer

Contact AWS Support to disable read-only mode on the read replica. Reboot the read replica. Connect to the read replica and create the tables.

Answer

Change the read_only parameter to false (read_only=0) in the default parameter group of the read replica. Perform a reboot without failover. Connect to the read replica and create the tables using the local_only MySQL option.

Answer

Change the read_only parameter to false (read_only=0) in the default parameter group. Reboot the read replica. Connect to the read replica and create the tables.

Answer

Create a new DB parameter group. Change the read_only parameter to false (read_only=0). Associate the read replica with the new group. Reboot the read replica. Connect to the read replica and create the tables.

Question 4

A company has a production Amazon Aurora Db cluster that serves both online transaction processing (OLTP) transactions and compute-intensive reports. The reports run for 10% of the total cluster uptime while the OLTP transactions run all the time. The company has benchmarked its workload and determined that a six-node Aurora DB cluster is appropriate for the peak workload.
The company is now looking at cutting costs for this DB cluster, but needs to have a sufficient number of nodes in the cluster to support the workload at different times. The workload has not changed since the previous benchmarking exercise.

How can a Database Specialist address these requirements with minimal user involvement?

Accepted Answer

Set up automatic scaling on the DB cluster. This will allow the number of reader nodes to adjust automatically to the reporting workload, when needed.

Answer

Split up the DB cluster into two different clusters: one for OLTP and the other for reporting. Monitor and set up replication between the two clusters to keep data consistent.

Answer

Review all evaluate the peak combined workload. Ensure that utilization of the DB cluster node is at an acceptable level. Adjust the number of instances, if necessary.

Answer

Use the stop cluster functionality to stop all the nodes of the DB cluster during times of minimal workload. The cluster can be restarted again depending on the workload at the time.

Question 5

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 6

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)

DBS-C01 Database Specialty Practice Questions

Create an account to continue.

Create an account to continue.

Related exams