AWS Certified Database - Specialty (Planning and Designing Databases on AWS) Quiz Questions and Answers

A retail organization is developing a data lake solution utilizing Amazon S3 to store a large amount of data. The solution must be accessible via SQL queries. The organization wants to minimize infrastructure costs. What AWS service should be part of their solution?

Answer :
  • Amazon Athena for the data discovery activities

A company has LAMP (Linux, Apache, MySQL, PHP) stack application deployed to AWS. The availability requirements for their backend database specify automatic failover in case of disaster recovery. What is the optimal solution that meets this requirement?

Answer :
  • RDS with Multi-AZ deployment

A developer is implementing an AWS Lambda function that will read data from an Amazon DynamoDB table. What is the most secure method of providing the Lambda function access permissions to the DynamoDB table?

Answer :
  • Create an IAM role. Create IAM policy granting necessary access permissions to the dynamoDB table. Assign the IAM policy to the IAM role. Assign the IAM role to the Lambda Execution Role.

An IoT application has a requirement to collect data from a large number of devices. The data needs to be ingested quickly with very low latency. What would be the recommended option for the database in this scenario?

Answer :
  • Amazon DynamoDB

A company security team wants to implement a solution for securely storing database credentials. The solution should provide automatic rotation of database credentials. What AWS service can the team use to meet these requirements?

Answer :
  • AWS Secrets Manager

What AWS service can be used to generate a database migration assessment report with recommendations regarding schema conversion, database object compatibility, and conversion effort estimates?

Answer :
  • AWS SCT

A solution architect is migrating an enterprise Oracle database to EBS backed EC2 instances requiring 24,000 IOPS. Which EBS volume type would be appropriate for this scenario?

Answer :
  • io1

A company is migrating its on-premise Teradata data warehouse system to AWS. What AWS service offers columnar data store suitable for data warehousing?

Answer :
  • Amazon Redshift

Which of the following is an example of a good DynamoDB hash key?

Answer :
  • International Standard Book Number (ISBN)

A development team is experiencing performance issues with their Amazon RDS instance. They wish to measure database load and identify SQL commands with a high CPU load. What service can the team use to help them solve this issue?

Answer :
  • RDS performance Insights