Practice DBS-C01 Exam Online

Question 1

A Database Specialist is performing a proof of concept with Amazon Aurora using a small instance to confirm a simple database behavior. When loading a large dataset and creating the index, the Database Specialist encounters the following error message from Aurora: ERROR: cloud not write block 7507718 of temporary file: No space left on device What is the cause of this error and what should the Database Specialist do to resolve this issue?

A : The scaling of Aurora storage cannot catch up with the data loading. The Database Specialist needs to modify the workload to load the data slowly.

B : The scaling of Aurora storage cannot catch up with the data loading. The Database Specialist needs to enable Aurora storage scaling.

C : The local storage used to store temporary tables is full. The Database Specialist needs to scale up the instance.

D : The local storage used to store temporary tables is full. The Database Specialist needs to enable local storage scaling.

Answer: C

Question 2

On a single Amazon RDS DB instance, a business hosts a MySQL database for its ecommerce application. Automatically saving application purchases to the database results in high-volume writes. Employees routinely create purchase reports for the company. The organization wants to boost database performance and minimize downtime associated with upgrade patching.

Which technique will satisfy these criteria with the LEAST amount of operational overhead?

A : Enable a Multi-AZ deployment of the RDS for MySQL DB instance, and enable Memcached in the MySQL option group.

B : Enable a Multi-AZ deployment of the RDS for MySQL DB instance, and set up replication to a MySQL DB instance running on Amazon EC2.

C : Enable a Multi-AZ deployment of the RDS for MySQL DB instance, and add a read replica.

D : Add a read replica and promote it to an Amazon Aurora MySQL DB cluster master. Then enable Amazon Aurora Serverless.

Answer: C

Question 3

A company’s development team needs to have production data restored in a staging AWS account. The

production database is running on an Amazon RDS for PostgreSQL Multi-AZ DB instance, which has AWS

KMS encryption enabled using the default KMS key. A database specialist planned to share the most recent

automated snapshot with the staging account, but discovered that the option to share snapshots is disabled in

the AWS Management Console.

What should the database specialist do to resolve this?

A : Disable automated backups in the DB instance. Share both the automated snapshot and the default KMS key with the staging account. Restore the snapshot in the staging account and enable automated backups.

B : Copy the automated snapshot specifying a custom KMS encryption key. Share both the copied snapshot and the custom KMS encryption key with the staging account. Restore the snapshot to the staging account within the same Region.

C : Modify the DB instance to use a custom KMS encryption key. Share both the automated snapshot and the custom KMS encryption key with the staging account. Restore the snapshot in the staging account

D : Copy the automated snapshot while keeping the default KMS key. Share both the snapshot and the default KMS key with the staging account. Restore the snapshot in the staging account.

Answer: B

Question 4

A Database Specialist is migrating a 2 TB Amazon RDS for Oracle DB instance to an RDS for PostgreSQL DB instance using AWS DMS. The source RDS Oracle DB instance is in a VPC in the us-east-1 Region. The target RDS for PostgreSQL DB instance is in a VPC in the use-west-2 Region. Where should the AWS DMS replication instance be placed for the MOST optimal performance?

A : In the same Region and VPC of the source DB instance

B : In the same Region and VPC as the target DB instance

C : In the same VPC and Availability Zone as the target DB instance

D : In the same VPC and Availability Zone as the source DB instance

Answer: C

Question 5

A database specialist is creating an AWS CloudFormation stack. The database specialist wants

to prevent accidental deletion of an Amazon RDS ProductionDatabase resource in the stack.

Which solution will meet this requirement?

A : Create a stack policy to prevent updates. Include “Effect” : “ProductionDatabase” and “Resource” : “Deny” in the policy.

B : Create an AWS CloudFormation stack in XML format. Set xAttribute as false.

C : Create an RDS DB instance without the DeletionPolicy attribute. Disable termination protection.

D : Create a stack policy to prevent updates. Include “Effect” : “Deny” and “Resource” : “ProductionDatabase” in the policy.

Answer: D

Name:	AWS Certified Database - Specialty
Exam Code:	DBS-C01
Certification:	AWS Certified Database
Vendor:	Amazon
Total Questions:	459
Last Updated:	Apr 24, 2024

Amazon DBS-C01