A company has applications running on Amazon EC2 instances in a private subnet with no internet connectivity. The company deployed a new application that uses Amazon DynamoDB, but the application cannot connect to the DynamoDB tables. A developer already checked that all permissions are set correctly.
What should a database specialist do to resolve this issue while minimizing access to external resources?

• A.Add a route to an internet gateway in the subnet's route table.
• B.Add a route to a NAT gateway in the subnet's route table.
• C.Assign a new security group to the EC2 instances with an outbound rule to ports 80 and 443.
• D.Create a VPC endpoint for DynamoDB and add a route to the endpoint in the subnet's route table.

Comment: *

Name: *

Email: *

Verification: *

A company is building a software as a service application. As part of the new user sign-on workflow, a Python script invokes the CreateTable operation using the Amazon DynamoDB API. After the call returns, the script attempts to call PutItem.
Occasionally, the PutItem request fails with a ResourceNotFoundException error, which causes the workflow to fail. The development team has confirmed that the same table name is used in the two API calls.
How should a database specialist fix this issue?

• A.Add an allow statement for the dynamodb:PutItem action in a policy attached to the role used by the application creating the table.
• B.Set the StreamEnabled property of the StreamSpecification parameter to true, then call PutItem.
• C.Change the application to call DescribeTable periodically until the TableStatus is ACTIVE, then call PutItem.
• D.Add a ConditionExpression parameter in the PutItem request.

Comment: *

Name: *

Email: *

Verification: *

A company is running an on-premises application comprised of a web tier, an application tier, and a MySQL database tier. The database is used primarily during business hours with random activity peaks throughout the day. A database specialist needs to improve the availability and reduce the cost of the MySQL database tier as part of the company's migration to AWS.
Which MySQL database option would meet these requirements?

• A.Amazon Aurora Serverless MySQL cluster
• B.Amazon Aurora MySQL cluster
• C.Amazon RDS for MySQL with read replica
• D.Amazon RDS for MySQL with Multi-AZ

Comment: *

Name: *

Email: *

Verification: *

A company has an existing system that uses a single-instance Amazon DocumentDB (with MongoDB compatibility) cluster. Read requests account for 75% of the system queries. Write requests are expected to increase by 50% after an upcoming global release. A database specialist needs to design a solution that improves the overall database performance without creating additional application overhead.
Which solution will meet these requirements?

• A.Recreate the cluster with a shared cluster volume. Add two instances to serve both read requests and write requests.
• B.Add one read replica instance. Activate a shared cluster volume. Route all read queries to the read replica instance.
• C.Add one read replica instance. Set the read preference to secondary preferred.
• D.Add one read replica instance. Update the application to route all read queries to the read replica instance.

Comment: *

Name: *

Email: *

Verification: *

An Amazon RDS EBS-optimized instance with Provisioned IOPS (PIOPS) storage is using less than half of its allocated IOPS over the course of several hours under constant load. The RDS instance exhibits multi-second read and write latency, and uses all of its maximum bandwidth for read throughput, yet the instance uses less than half of its CPU and RAM resources.
What should a Database Specialist do in this situation to increase performance and return latency to sub- second levels?

• A.Increase the size of the DB instance storage
• B.Change the underlying EBS storage type to General Purpose SSD (gp2)
• C.Disable EBS optimization on the DB instance
• D.Change the DB instance to an instance class with a higher maximum bandwidth

Comment: *

Name: *

Email: *

Verification: *