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

A developer is implementing an IoT application using DynamoDB as the data store for device event data. An application requirement is to automatically purge all event data older than 30 days. What is the optimal option to implement this requirement?

Answer :
  • Enable TTL on the dynamoDB table and store the expiration timestamp in the TTL attribute in the epoch format

Explanation :

Time to Live (TTL) for Amazon DynamoDB is functionality that enables automatic deletion of items after 1 specified expiration time defined by 1 timestamp in the TTL attribute

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

Explanation :

www.docs.amazon.com

A multimedia company based in Singapore wants to build a highly available database solution in AWS. It will be used for a content management application that expects high-volume requests and hence, can scale depending on the read throughput. The fully-managed database service will store data in JSON-like documents with attribute value sizes as large as 16 MB. Which database service would best fit the company's needs?

Answer :
  • Amazon DocumentDB

Explanation :

www.docs.amazon.com

A Database Specialist plans to migrate an on-premises non-relational key-value database to a fully-managed AWS service that can take care of tasks such as scaling databases and hardware provisioning. The Application Manager also requires a cost-effective database that could manage unknown workloads and unpredictable user traffic. Which solution should the Database Specialist consider first?

Answer :
  • Amazon DynamoDB table with on-demand capacity mode

Explanation :

www.docs.amazon.com

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

Explanation :

www.docs.amazon.com

An application uses the RDF model to describe relationships between graph objects stored in Amazon Neptune. What query language should be used in this scenario?

Answer :
  • SPARQL

Explanation :

www.docs.amazon.com

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

Explanation :

www.docs.amazon.com

What is the maximum size of an item in a DynamoDB table?

Answer :
  • 400 KB

Explanation :

www.docs.amazon.com

A solution architect would like to integrate Amazon RDS for SQL Server instance with an existing Active Directory Domain. What service would enable the solution architect to implement a solution?

Answer :
  • AWS Directory Service

Explanation :

www.docs.amazon.com

A developer is doing some testing on an application using the Amazon Aurora database. During the testing activities, the developer accidentally executes a DELETE statement without a WHERE clause. They wish to undo this action. What is the optimal solution to revert the database to the correct state with minimal effort?

Answer :
  • Use Amazon Aurora Backtracking Feature

Explanation :

www.docs.amazon.com