CertsTopics Logo

Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

AWS Certified Database DBS-C01 Book

Page: 23 / 24
Total 324 questions
Get DBS-C01 Full Access Download DBS-C01 PDF

AWS Certified Database - Specialty Questions and Answers

Question 89

After restoring an Amazon RDS snapshot from 3 days ago, a company’s Development team cannot connect to the restored RDS DB instance. What is the likely cause of this problem?

Options:

A.

The restored DB instance does not have Enhanced Monitoring enabled

B.

The production DB instance is using a custom parameter group

C.

The restored DB instance is using the default security group

D.

The production DB instance is using a custom option group

Question 90

A company has deployed an application that uses an Amazon RDS for MySQL DB cluster. The DB cluster uses three read replicas. The primary DB instance is an

8XL-sized instance, and the read replicas are each XL-sized instances.

Users report that database queries are returning stale data. The replication lag indicates that the replicas are 5 minutes behind the primary DB instance. Status queries on the replicas show that the SQL_THREAD is 10 binlogs behind the IO_THREAD and that the IO_THREAD is 1 binlog behind the primary.

Which changes will reduce the lag? (Choose two.)

Options:

A.

Deploy two additional read replicas matching the existing replica DB instance size.

B.

Migrate the primary DB instance to an Amazon Aurora MySQL DB cluster and add three Aurora Replicas.

C.

Move the read replicas to the same Availability Zone as the primary DB instance.

D.

Increase the instance size of the primary DB instance within the same instance class.

E.

Increase the instance size of the read replicas to the same size and class as the primary DB instance.

Question 91

An information management services company is storing JSON documents on premises. The company is using a MongoDB 3.6 database but wants to migrate to

AWS. The solution must be compatible, scalable, and fully managed. The solution also must result in as little downtime as possible during the migration.

Which solution meets these requirements?

Options:

A.

Create an AWS Database Migration Service (AWS DMS) replication instance, a source endpoint for MongoDB, and a target endpoint of Amazon DocumentDB (with MongoDB compatibility).

B.

Create an AWS Database Migration Service (AWS DMS) replication instance, a source endpoint for MongoDB, and a target endpoint of a MongoDB image that is hosted on Amazon EC2

C.

Use the mongodump and mongorestore tools to migrate the data from the source MongoDB deployment to Amazon DocumentDB (with MongoDB compatibility).

D.

Use the mongodump and mongorestore tools to migrate the data from the source MongoDB deployment to a MongoDB image that is hosted on Amazon EC2.

Question 92

A company is using an Amazon ElastiCache for Redis cluster to host its online shopping website. Shoppers receive the following error when the website's application queries the cluster:

Which solutions will resolve this memory issues with the LEAST amount of effort? (Choose three.)

Options:

A.

Reduce the TTL value for keys on the node.

B.

Choose a larger node type.

C.

Test different values in the parameter group for the maxmemory-policy parameter to find the ideal value to use.

D.

Increase the number of nodes.

E.

Monitor the EngineCPUUtilization Amazon CloudWatch metric. Create an AWS Lambda function to delete keys on nodes when a threshold is reached.

F.

Increase the TTL value for keys on the node.

Page: 23 / 24
Total 324 questions
Get DBS-C01 Full Access Download DBS-C01 PDF