In North America, a business launched a mobile game that swiftly expanded to 10 million daily active players.
The game's backend is hosted on AWS and makes considerable use of a TTL-configured Amazon DynamoDB table.
When an item is added or changed, its TTL is set to 600 seconds plus the current epoch time. The game logic is reliant on the purging of outdated data in order to compute rewards points properly. At times, items from the table are read that are many hours beyond their TTL expiration.
How should a database administrator resolve this issue?

• A.Use a client library that supports the TTL functionality for DynamoDB.
• B.Include a query filter expression to ignore items with an expired TTL.
• C.Set the ConsistentRead parameter to true when querying the table.
• D.Create a local secondary index on the TTL attribute.

Comment: *

Name: *

Email: *

Verification: *

A business uses Amazon EC2 instances in VPC A to serve an internal file-sharing application. This application is supported by an Amazon ElastiCache cluster in VPC B that is peering with VPC A.
The corporation migrates the instances of its applications from VPC A to VPC B.
The file-sharing application is no longer able to connect to the ElastiCache cluster, as shown by the logs.
What is the best course of action for a database professional to take in order to remedy this issue?

• A.Create a second security group on the EC2 instances. Add an outbound rule to allow traffic from the ElastiCache cluster security group.
• B.Delete the ElastiCache security group. Add an interface VPC endpoint to enable the EC2 instances to connect to the ElastiCache cluster.
• C.Modify the ElastiCache security group by adding outbound rules that allow traffic to VPC CIDR blocks from the ElastiCache cluster.
• D.Modify the ElastiCache security group by adding an inbound rule that allows traffic from the EC2 instances security group to the ElastiCache cluster.

Comment: *

Name: *

Email: *

Verification: *

A company has an on-premises system that tracks various database operations that occur over the lifetime of a database, including database shutdown, deletion, creation, and backup.
The company recently moved two databases to Amazon RDS and is looking at a solution that would satisfy these requirements. The data could be used by other systems within the company.
Which solution will meet these requirements with minimal effort?

• A.Write RDS logs to Amazon Kinesis Data Firehose. Create an AWS Lambda function to act on these rules and write the output to the tracking systems.
• B.Create RDS event subscriptions. Have the tracking systems subscribe to specific RDS event system notifications.
• C.Create an AWS Lambda function to trigger on AWS CloudTrail API calls. Filter on specific RDS API calls and write the output to the tracking systems.
• D.Create an Amazon Cloudwatch Events rule with the operations that need to be tracked on Amazon RDS.
  Create an AWS Lambda function to act on these rules and write the output to the tracking systems.

Comment: *

Name: *

Email: *

Verification: *

A large financial services company requires that all data be encrypted in transit. A Developer is attempting to connect to an Amazon RDS DB instance using the company VPC for the first time with credentials provided by a Database Specialist. Other members of the Development team can connect, but this user is consistently receiving an error indicating a communications link failure. The Developer asked the Database Specialist to reset the password a number of times, but the error persists.
Which step should be taken to troubleshoot this issue?

• A.Ensure that the database option group for the RDS DB instance allows ingress from the Developer machine's IP address
• B.Ensure that the RDS DB instance's subnet group includes a public subnet to allow the Developer to connect
• C.Ensure that the RDS DB instance has not reached its maximum connections limit
• D.Ensure that the connection is using SSL and is addressing the port where the RDS DB instance is listening for encrypted connections

Comment: *

Name: *

Email: *

Verification: *

A company uses Amazon Aurora for secure financial transactions. The data must always be encrypted at rest and in transit to meet compliance requirements.
Which combination of actions should a database specialist take to meet these requirements? (Choose two.)

• A.Create an Aurora Replica with encryption enabled using AWS Key Management Service (AWS KMS).
  Then promote the replica to master.
• B.Use SSL/TLS to secure the in-transit connection between the financial application and the Aurora DB cluster.
• C.Modify the existing Aurora DB cluster and enable encryption using an AWS Key Management Service (AWS KMS) encryption key. Apply the changes immediately.
• D.Take a snapshot of the Aurora DB cluster and encrypt the snapshot using an AWS Key Management Service (AWS KMS) encryption key. Restore the snapshot to a new DB cluster and update the financial application database endpoints.
• E.Use AWS Key Management Service (AWS KMS) to secure the in-transit connection between the financial application and the Aurora DB cluster.

Comment: *

Name: *

Email: *

Verification: *