DBS-C01 Practice Online

Question 1

A company has an AWS CloudFormation stack that defines an Amazon RDS DB instance. The company

accidentally deletes the stack and loses recent data from the DB instance. A database specialist must change

the CloudFormation template for the RDS resource to reduce the chance of accidental data loss from the DB

instance in the future.

Which combination of actions should the database specialist take to meet this requirement? (Choose three.)

A : Set the DeletionProtection property to True.

B : Set the MultiAZ property to True

C : Set the TerminationProtection property to True.

D : Set the DeleteAutomatedBackups property to False.

E : Set the DeletionPolicy attribute to No.

F : Set the DeletionPolicy attribute to Retain.

Answer: A,D

Question 2

A company migrated an on-premises Oracle database to Amazon RDS for Oracle. A database specialist needs to monitor the latency of the database. Which solution will meet this requirement with the LEAST operational overhead?

A :

Publish RDS Performance insights metrics to Amazon CloudWatch. Add AWS CloudTrail filters to monitor database performance

B :

Install Oracle Statspack. Enable the performance statistics feature to collect, store, and display performance data to monitor database performance.

C :

Enable RDS Performance Insights to visualize the database load. Enable Enhanced Monitoring to view how different threads use the CPU

D :

Create a new DB parameter group that includes the AllocatedStorage, DBInstanceClassMemory, and DBInstanceVCPU variables. Enable RDS Performance Insights

Answer: C

Question 3

An international news agency uses Amazon RDS for PostgreSQL in a Multi-AZ setup to manage their daily news articles. Following a significant global event, they observed a spike in database logs due to massive article updates.

The growing logs are rapidly consuming available storage, and projections indicate it might be exhausted within 4 days. To manage this, they need a method to regain the storage occupied by the surging logs without disrupting their global news services.

What measure should be implemented?

A : Change the database storage type to General Purpose (SSD) to enhance log removal rate.

B : Configure the log_truncate_on_rotation parameter to on and adjust log_rotation_age for the logs to be cleared after a specific duration.

C : Modify the log_rotation_age parameter to a shorter duration and promptly reboot the DB instance.

D : Set the log_filename parameter to generate logs with smaller sizes.

Answer: B

Question 4

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 5

A company maintains several databases using Amazon RDS for MySQL and PostgreSQL. Each RDS database generates log files with retention periods set to their default values. The company has now mandated that database logs be maintained for up to 90 days in a centralized repository to facilitate real-time and after-the-fact analyses. What should a Database Specialist do to meet these requirements with minimal effort?

A : Create an AWS Lambda function to pull logs from the RDS databases and consolidate the log files in an Amazon S3 bucket. Set a lifecycle policy to expire the objects after 90 days.

B : Modify the RDS databases to publish log to Amazon CloudWatch Logs. Change the log retention policy for each log group to expire the events after 90 days.

C : Write a stored procedure in each RDS database to download the logs and consolidate the log files in an Amazon S3 bucket. Set a lifecycle policy to expire the objects after 90 days.

D : Create an AWS Lambda function to download the logs from the RDS databases and publish the logs to Amazon CloudWatch Logs. Change the log retention policy for the log group to expire the events after 90 days.

Answer: B

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

Download Demo DBS-C01 Dumps

Create Account

Password Recovery

DBS-C01 Practice Online

Download Demo DBS-C01 Dumps

Member Login

Create Account

Password Recovery

DBS-C01 Practice Online