A company is running its customer feedback application on Amazon Aurora MySQL. The company runs a report every day to extract customer feedback, and a team reads the feedback to determine if the customer comments are positive or negative. It sometimes takes days before the company can contact unhappy customers and take corrective measures. The company wants to use machine learning to automate this workflow.
Which solution meets this requirement with the LEAST amount of effort?

1. A. Export the Aurora MySQL database to Amazon S3 by using AWS Database Migration Service (AWS DMS). Use Amazon Comprehend to run sentiment analysis on the exported files.
2. B. Export the Aurora MySQL database to Amazon S3 by using AWS Database Migration Service (AWS DMS). Use Amazon SageMaker to run sentiment analysis on the exported files.
3. C. Set up Aurora native integration with Amazon Comprehen
4. D. Use SQL functions to extract sentiment analysis.
5. E. Set up Aurora native integration with Amazon SageMake
6. F. Use SQL functions to extract sentiment analysis.

Correct Answer: C
For details about using Aurora and Amazon Comprehend together, see Using Amazon Comprehend for
sentiment detection. Aurora machine learning uses a highly optimized integration between the Aurora database and the AWS machine learning (ML) services SageMaker and Amazon Comprehend.
https://www.stackovercloud.com/2019/11/27/new-for-amazon-aurora-use-machine-learning-directly-from-your

The website of a manufacturing firm makes use of an Amazon Aurora PostgreSQL database cluster. Which settings will result in the LEAST amount of downtime for the application during failover? (Select
three.)

1. A. Use the provided read and write Aurora endpoints to establish a connection to the Aurora DB cluster.
2. B. Create an Amazon CloudWatch alert triggering a restore in another Availability Zone when the primary Aurora DB cluster is unreachable.
3. C. Edit and enable Aurora DB cluster cache management in parameter groups.
4. D. Set TCP keepalive parameters to a high value.
5. E. Set JDBC connection string timeout variables to a low value.
6. F. Set Java DNS caching timeouts to a high value.

Correct Answer: ACE
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.BestPractices.html https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.cluster-cache-mgmt.htm https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.BestPractices.html#Aur

A startup company is building a new application to allow users to visualize their on-premises and cloud networking components. The company expects billions of components to be stored and requires responses in milliseconds. The application should be able to identify:
The networks and routes affected if a particular component fails.
The networks that have redundant routes between them.
The networks that do not have redundant routes between them.
The fastest path between two networks.
Which database engine meets these requirements?

1. A. Amazon Aurora MySQL
2. B. Amazon Neptune
3. C. Amazon ElastiCache for Redis
4. D. Amazon DynamoDB

Correct Answer: B

A company is running a finance application on an Amazon RDS for MySQL DB instance. The application is governed by multiple financial regulatory agencies. The RDS DB instance is set up with security groups to allow access to certain Amazon EC2 servers only. AWS KMS is used for encryption at rest.
Which step will provide additional security?

1. A. Set up NACLs that allow the entire EC2 subnet to access the DB instance
2. B. Disable the master user account
3. C. Set up a security group that blocks SSH to the DB instance
4. D. Set up RDS to use SSL for data in transit

Correct Answer: D

An online gaming company is planning to launch a new game with Amazon DynamoDB as its data store. The database should be designated to support the following use cases:
Update scores in real time whenever a player is playing the game. Retrieve a player’s score details for a specific game session.
A Database Specialist decides to implement a DynamoDB table. Each player has a unique user_id and each game has a unique game_id.
Which choice of keys is recommended for the DynamoDB table?

1. A. Create a global secondary index with game_id as the partition key
2. B. Create a global secondary index with user_id as the partition key
3. C. Create a composite primary key with game_id as the partition key and user_id as the sort key
4. D. Create a composite primary key with user_id as the partition key and game_id as the sort key

Correct Answer: D
https://aws.amazon.com/blogs/database/amazon-dynamodb-gaming-use-cases-and-design-patterns/ "EA uses the user ID as the partition key and primary key (a 1:1 modeling pattern)."
https://aws.amazon.com/blogs/database/choosing-the-right-dynamodb-partition-key/
"Partition key and sort key: Referred to as a composite primary key, this type of key is composed of two attributes. The first attribute is the partition key, and the second attribute is the sort key."