Database Specialty (Page 16)

A database specialist manages a critical Amazon RDS for MySQL DB instance for a company.The data stored daily could vary from .01% to 10% of the current database size.The database specialist needs to ensure that the DB instance storage grows as needed.What is the MOST operationally efficient and cost-effective solution?Read More →

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.)Read More →

A large company has a variety of Amazon DB clusters.Each of these clusters has various configurations that adhere to various requirements.Depending on the team and use case, these configurations can be organized into broader categories.A database administrator wants to make the process of storing and modifying these parameters more systematic.The database administrator also wants to ensure that changes to individual categories of configurations are automatically applied to all instances when required.Which AWS service or feature will help automate and achieve this objective?Read More →

A company uses a single-node Amazon RDS for MySQL DB instance for its production database.The DB instance runs in an AWS Region in the United States.A week before a big sales event, a new maintenance update is available for the DB instance.The maintenance update is marked as required.The company wants to minimize downtime for the DB instance and asks a database specialist to make the DB instance highly available until the sales event ends.Which solution will meet these requirements?Read More →

A company is migrating its on-premises database workloads to the AWS Cloud.A database specialist performing the move has chosen AWS DMS to migrate anOracle database with a large table to Amazon RDS.The database specialist notices that AWS DMS is taking significant time to migrate the data.Which actions would improve the data migration speed? (Choose three.)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 →

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 →

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 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 →

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 →