Database Specialty (Page 16)

A Database Specialist is performing a proof of concept with Amazon Aurora using a small instance to confirm a simple database behavior.When loading a large dataset and creating the index, the Database Specialist encounters the following error message from Aurora:ERROR: cloud not write block 7507718 of temporary file: No space left on deviceWhat is the cause of this error and what should the Database Specialist do to resolve this issue?Read More →

A company wants to migrate its existing on-premises Oracle database to Amazon Aurora PostgreSQL.The migration must be completed with minimal downtime using AWS DMS.A Database Specialist must validate that the data was migrated accurately from the source to the target before the cutover.The migration must have minimal impact on the performance of the source database.Which approach will MOST effectively meet these requirements?Read More →

An online shopping company has a large inflow of shopping requests daily.As a result, there is a consistent load on the company’s Amazon RDS database.A database specialist needs to ensure the database is up and running at all times.The database specialist wants an automatic notification system for issues that may cause database downtime or for configuration changes made to the database.What should the database specialist do to achieve this? (Choose two.)Read More →

A company recently acquired a new business.A database specialist must migrate an unencrypted 12 TB Amazon RDS for MySQL DB instance to a new AWS account.The database specialist needs to minimize the amount of time required to migrate the database.Which solution meets these requirements?Read More →

An AWS CloudFormation stack that included an Amazon RDS DB instance was accidentally deleted and recent data was lost.A Database Specialist needs to addRDS settings to the CloudFormation template to reduce the chance of accidental instance data loss in the future.Which settings will meet this requirement? (Choose three.)Read More →

A company is launching a new Amazon RDS for MySQL Multi-AZ DB instance to be used as a data store for a custom-built application.After a series of tests with point-in-time recovery disabled, the company decides that it must have point-in-time recovery reenabled before using the DB instance to store production data.What should a database specialist do so that point-in-time recovery can be successful?Read More →

A company is using Amazon DynamoDB global tables for an online gaming application.The game has players around the world.As the game has become more popular, the volume of requests to DynamoDB has increased significantly.Recently, players have reported that the game state is inconsistent between players in different countries.A database specialist observes that the ReplicationLatency metric for some of the replica tables is too high.Which approach will alleviate the problem?Read More →

An online advertising company is implementing an application that displays advertisements to its users.The application uses an Amazon DynamoDB table as a data store.The application also uses a DynamoDB Accelerator (DAX) cluster to cache its reads.Most of the reads are from the GetItem query and theBatchGetItem query.Consistency of reads is not a requirement for this application.Upon deployment, the application cache is not performing as expected.Specific strongly consistent queries that run against the DAX cluster are taking many milliseconds to respond instead of microseconds.How can the company improve the cache behavior to increase application performance?Read More →

A bank plans to use an Amazon RDS for MySQL DB instance.The database should support read-intensive traffic with very few repeated queries.Which solution meets these requirements?Read More →

A database specialist is designing an enterprise application for a large company.The application uses Amazon DynamoDB with DynamoDB Accelerator (DAX).The database specialist observes that most of the queries are not found in the DAX cache and that they still require DynamoDB table reads.What should the database specialist review first to improve the utility of DAX?Read More →