Free Online Amazon DBS-C01 Practice Test

Prepare Your Amazon DBS-C01 Exam Questions with Free online DBS-C01 Practice Test. Get Brilliant AWS Certified Database - Specialty Exam Results with Valid DBS C01 Exam Dumps.

Page: 1 / 92

Total 459 Questions | Updated On: Apr 25, 2024

Question 1

Amazon Aurora MySQL is being used by an ecommerce business to migrate its main application database. The firm is now doing OLTP stress testing using concurrent database connections. A database professional detected sluggish performance for several particular write operations during the first round of testing.

Examining the Amazon CloudWatch stats for the Aurora DB cluster revealed a CPU usage of 90%.

Which actions should the database professional take to determine the main cause of excessive CPU use and sluggish performance most effectively? (Select two.)

A : Enable Enhanced Monitoring at less than 30 seconds of granularity to review the operating system metrics before the next round of tests.

B : Review the VolumeBytesUsed metric in CloudWatch to see if there is a spike in write I/O.

C : Review Amazon RDS Performance Insights to identify the top SQL statements and wait events.

D : Review Amazon RDS API calls in AWS CloudTrail to identify long-running queries.

E : Enable Advance Auditing to log QUERY events in Amazon CloudWatch before the next round of tests.

Answer: A,C

Question 2

A Database Specialist is creating a new Amazon Neptune DB cluster, and is attempting to load fata from Amazon S3 into the Neptune DB cluster using the Neptune bulk loader API. The Database Specialist receives the following error:

“Unable to connect to s3 endpoint. Provided source = s3://mybucket/graphdata/ and region = us-east-1. Please verify your S3 configuration.”

Which combination of actions should the Database Specialist take to troubleshoot the problem? (Choose two.)

A : Check that Amazon S3 has an IAM role granting read access to Neptune

B : Check that an Amazon S3 VPC endpoint exists

C : Check that a Neptune VPC endpoint exists

D : Check that Amazon EC2 has an IAM role granting read access to Amazon S3

E : Check that Neptune has an IAM role granting read access to Amazon S3

Answer: B,D

Question 3

A global enterprise wants to deploy Amazon RDS databases across various departments, each having its own AWS account. They want a standardized configuration to maintain company-wide compliance standards. No data sharing or replication is required among these databases. The company wants to deploy the databases within a 24-hour timeframe.

What is the BEST approach to achieve this?

A : Use AWS CloudFormation StackSets to deploy RDS resources across multiple accounts with a single standardized template.

B : Develop a Lambda function to initiate RDS instances with standardized configurations and invoke this Lambda across all AWS accounts.

C : Manually configure RDS databases in each account following the compliance blueprint documented by the central IT team.

D : Generate an RDS snapshot from an existing compliant database and replicate the snapshot across the accounts. Each department then creates an RDS instance from the shared snapshot.

Answer: A

Question 4

A streaming company uses Amazon RDS for MariaDB in a Multi-AZ deployment for their platform. After a special global event, they noticed a sudden increase in the database logs. This surge is causing the available storage to deplete, and they anticipate it running out in 3 days.

They need a solution to recapture the storage used by these additional logs without affecting the ongoing streaming service.

Which action should they undertake?

A : Modify the binlog retention hours to a smaller figure, anticipating a swift recovery of the space.

B : Adjust the rds.log_retention_period parameter to 1440. Wait up to 24 hours for the excess database logs to be automatically cleared.

C : Adjust the rds.log_retention_period parameter to a value of 0, then initiate an immediate reboot of the DB instance.

D : Convert the database storage type to Provisioned IOPS to speed up log removal processes.

Answer: B

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

Page: 1 / 92

Total 459 Questions | Updated On: Apr 25, 2024