AWS-Certified-Database-Specialty Free Practice Test

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.)

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

Correct Answer: AB
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-replicas-adding.html

A clothing company uses a custom ecommerce application and a PostgreSQL database to sell clothes to thousands of users from multiple countries. The company is migrating its application and database from its on- premises data center to the AWS Cloud. The company has selected Amazon EC2 for the application and Amazon RDS for PostgreSQL for the database. The company requires database passwords to be changed every 60 days. A Database Specialist needs to ensure that the credentials used by the web application to connect to the database are managed securely.
Which approach should the Database Specialist take to securely manage the database credentials?

1. A. Store the credentials in a text file in an Amazon S3 bucke
2. B. Restrict permissions on the bucket to the IAM role associated with the instance profile onl
3. C. Modify the application to download the text file and retrieve the credentials on start u
4. D. Update the text file every 60 days.
5. E. Configure IAM database authentication for the application to connect to the databas
6. F. Create an IAM user and map it to a separate database user for each ecommerce use
7. G. Require users to update their passwords every 60 days.
8. H. Store the credentials in AWS Secrets Manage
9. I. Restrict permissions on the secret to only the IAM role associated with the instance profil
10. J. Modify the application to retrieve the credentials from Secrets Manager on start u
11. K. Configure the rotation interval to 60 days.
12. L. Store the credentials in an encrypted text file in the application AM
13. M. Use AWS KMS to store the key for decrypting the text fil
14. N. Modify the application to decrypt the text file and retrieve the credentials on start u
15. O. Update the text file and publish a new AMI every 60 days.

Correct Answer: C

A company is releasing a new mobile game featuring a team play mode. As a group of mobile device users play together, an item containing their statuses is updated in an Amazon DynamoDB table. Periodically, the other users’ devices read the latest statuses of their teammates from the table using the BatchGetltemn operation.
Prior to launch, some testers submitted bug reports claiming that the status data they were seeing in the game was not up-to-date. The developers are unable to replicate this issue and have asked a database specialist for a recommendation.
Which recommendation would resolve this issue?

1. A. Ensure the DynamoDB table is configured to be always consistent.
2. B. Ensure the BatchGetltem operation is called with the ConsistentRead parameter set to false.
3. C. Enable a stream on the DynamoDB table and subscribe each device to the stream to ensure all devices receive up-to-date status information.
4. D. Ensure the BatchGetltem operation is called with the ConsistentRead parameter set to true.

Correct Answer: D
https://docs.aws.amazon.com/ja_jp/amazondynamodb/latest/developerguide/API_BatchGetItem_v20111205.htm By default, BatchGetItem performs eventually consistent reads on every table in the request. If you want strongly consistent reads instead, you can set ConsistentRead to true for any or all tables.

A company runs a customer relationship management (CRM) system that is hosted on-premises with a MySQL database as the backend. A custom stored procedure is used to send email notifications to another system when data is inserted into a table. The company has noticed that the performance of the CRM system has decreased due to database reporting applications used by various teams. The company requires an AWS solution that would reduce maintenance, improve performance, and accommodate the email notification feature.
Which AWS solution meets these requirements?

1. A. Use MySQL running on an Amazon EC2 instance with Auto Scaling to accommodate the reporting application
2. B. Configure a stored procedure and an AWS Lambda function that uses Amazon SES to send email notifications to the other system.
3. C. Use Amazon Aurora MySQL in a multi-master cluster to accommodate the reporting applications.Configure Amazon RDS event subscriptions to publish a message to an Amazon SNS topic and subscribe the other system's email address to the topic.
4. D. Use MySQL running on an Amazon EC2 instance with a read replica to accommodate the reporting application
5. E. Configure Amazon SES integration to send email notifications to the other system.
6. F. Use Amazon Aurora MySQL with a read replica for the reporting application
7. G. Configure a stored procedure and an AWS Lambda function to publish a message to an Amazon SNS topi
8. H. Subscribe the other system's email address to the topic.

Correct Answer: D
RDS event subscriptions do not cover "data is inserted into a table" - see https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_Events.Messages.html We can use stored procedure to invoke Lambda function - https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Integrating.Lambda.html

A small startup company is looking to migrate a 4 TB on-premises MySQL database to AWS using an Amazon RDS for MySQL DB instance.
Which strategy would allow for a successful migration with the LEAST amount of downtime?

1. A. Deploy a new RDS for MySQL DB instance and configure it for access from the on-premises data cente
2. B. Use the mysqldump utility to create an initial snapshot from the on-premises MySQL server, and copy it to an Amazon S3 bucke
3. C. Import the snapshot into the DB instance utilizing the MySQL utilities running on an Amazon EC2 instanc
4. D. Immediately point the application to the DB instance.
5. E. Deploy a new Amazon EC2 instance, install the MySQL software on the EC2 instance, and configure networking for access from the on-premises data cente
6. F. Use the mysqldump utility to create a snapshot of the on-premises MySQL serve
7. G. Copy the snapshot into the EC2 instance and restore it into the EC2 MySQL instanc
8. H. Use AWS DMS to migrate data into a new RDS for MySQL DB instanc
9. I. Point the application to the DB instance.
10. J. Deploy a new Amazon EC2 instance, install the MySQL software on the EC2 instance, and configure networking for access from the on-premises data cente
11. K. Use the mysqldump utility to create a snapshot of the on-premises MySQL serve
12. L. Copy the snapshot into an Amazon S3 bucket and import the snapshot into a new RDS for MySQL DB instance using the MySQL utilities running on an EC2 instanc
13. M. Point the application to the DB instance.
14. N. Deploy a new RDS for MySQL DB instance and configure it for access from the on-premises data cente
15. O. Use the mysqldump utility to create an initial snapshot from the on-premises MySQL server, and copy it to an Amazon S3 bucke
16. P. Import the snapshot into the DB instance using the MySQL utilities running on an Amazon EC2 instanc
17. Q. Establish replication into the new DB instance using MySQL replicatio
18. R. Stop application access to the on-premises MySQL server and let the remaining transactions replicate ove
19. S. Point the application to the DB instance.

Correct Answer: B