AWS Certified Database Specialty-(DBS-C01)

The AWS Certified Database Specialty-(DBS-C01) were last updated on today.

Viewing page 9 out of 68 pages.
Viewing questions 41-45 out of 340 questions

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.and Azure
- Trademarks, certification & product names are used for reference only and belong to Amazon.and Azure

Topic 1 - Exam A

Question #41 Topic 1

A company plans to migrate a MySQL-based application from an on-premises environment to AWS. The application performs database joins across several tables and uses indexes for faster query response times. The company needs the database to be highly available with automatic failover. Which solution on AWS will meet these requirements with the LEAST operational overhead?

A Deploy an Amazon RDS DB instance with a read replica.
B Deploy an Amazon RDS Multi-AZ DB instance.
C Deploy Amazon DynamoDB global tables.
D Deploy multiple Amazon RDS DB instances. Use Amazon Route 53 DNS with failover health checks configured.

Suggested Answer: D
NOTE:

Question #42 Topic 1

A database specialist is designing an enterprise application for a large company. The application uses Amazon DynamoDB with DynamoDB Accelerator (DAX). The database specialist observes that most of the queries are not found in the DAX cache and that they still require DynamoDB table reads. What should the database specialist review first to improve the utility of DAX?

A The DynamoDB ConsumedReadCapacityUnits metric
B The trust relationship to perform the DynamoDB API calls
C The DAX cluster's TTL setting
D The validity of customer-specified AWS Key Management Service (AWS KMS) keys for DAX encryption at rest

Suggested Answer: A
NOTE: Reference: https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/metrics-dimensions.html

Question #43 Topic 1

A company requires near-real-time notifications when changes are made to Amazon RDS DB security groups. Which solution will meet this requirement with the LEAST operational overhead?

A Configure an RDS event notification subscription for DB security group events.
B Create an AWS Lambda function that monitors DB security group changes. Create an Amazon Simple Notification Service (Amazon SNS) topic for notification.
C Turn on AWS CloudTrail. Configure notifications for the detection of changes to DB security groups.
D Configure an Amazon CloudWatch alarm for RDS metrics about changes to DB security groups.

Suggested Answer: D
NOTE: Reference: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/rds-cloudwatch-events.sample.html

Question #44 Topic 1

An online gaming company is using an Amazon DynamoDB table in on-demand mode to store game scores. After an intensive advertisement campaign in South America, the average number of concurrent users rapidly increases from 100,000 to 500,000 in less than 10 minutes every day around 5 PM. The on-call software reliability engineer has observed that the application logs contain a high number of DynamoDB throttling exceptions caused by game score insertions around 5 PM. Customer service has also reported that several users are complaining about their scores not being registered. How should the database administrator remediate this issue at the lowest cost?

A Enable auto scaling and set the target usage rate to 90%.
B Switch the table to provisioned mode and enable auto scaling.
C Switch the table to provisioned mode and set the throughput to the peak value.
D Create a DynamoDB Accelerator cluster and use it to access the DynamoDB table.

Suggested Answer: B
NOTE:

Question #45 Topic 1

A company stores critical data for a department in Amazon RDS for MySQL DB instances. The department was closed for 3 weeks and notified a database specialist that access to the RDS DB instances should not be granted to anyone during this time. To meet this requirement, the database specialist stopped all the DB instances used by the department but did not select the option to create a snapshot. Before the 3 weeks expired, the database specialist discovered that users could connect to the database successfully. What could be the reason for this?

A When stopping the DB instance, the option to create a snapshot should have been selected.
B When stopping the DB instance, the duration for stopping the DB instance should have been selected.
C Stopped DB instances will automatically restart if the number of attempted connections exceeds the threshold set.
D Stopped DB instances will automatically restart if the instance is not manually started after 7 days.

Suggested Answer: A
NOTE: