Database Specialty (Page 4)

A large gaming company is creating a centralized solution to store player session state for multiple online games.The workload required key-value storage with low latency and will be an equal mix of reads and writes.Data should be written into the AWS Region closest to the user across the games’ geographically distributed user base.The architecture should minimize the amount of overhead required to manage the replication of data between Regions.Which solution meets these requirements?Read More →

An ecommerce company is using Amazon DynamoDB as the backend for its order-processing application.The steady increase in the number of orders is resulting in increased DynamoDB costs.Order verification and reporting perform many repeated GetItem functions that pull similar datasets, and this read activity is contributing to the increased costs.The company wants to control these costs without significant development efforts.How should a Database Specialist address these requirements?Read More →

A database specialist is creating an AWS CloudFormation stack.The database specialist wants to prevent accidental deletion of an Amazon RDSProductionDatabase resource in the stack.Which solution will meet this requirement?Read More →

A financial services company is developing a shared data service that supports different applications from throughout the company.A Database Specialist designed a solution to leverage Amazon ElastiCache for Redis with cluster mode enabled to enhance performance and scalability.The cluster is configured to listen on port 6379.Which combination of steps should the Database Specialist take to secure the cache data and protect it from unauthorized access? (Choose three.)Read More →

A company is running an Amazon RDS for PostgreSQL DB instance and wants to migrate it to an Amazon Aurora PostgreSQL DB cluster.The current database is 1 TB in size.The migration needs to have minimal downtime.What is the FASTEST way to accomplish this?Read More →

A database specialist observes several idle connections in an Amazon RDS for MySQL DB instance.The DB instance is using RDS Proxy.An application is configured to connect to the proxy endpoint.What should the database specialist do to control the idle connections in the database?Read More →

An online retailer uses Amazon DynamoDB for its product catalog and order data.Some popular items have led to frequently accessed keys in the data, and the company is using DynamoDB Accelerator (DAX) as the caching solution to cater to the frequently accessed keys.As the number of popular products is growing, the company realizes that more items need to be cached.The company observes a high cache miss rate and needs a solution to address this issue.What should a database specialist do to accommodate the changing requirements for DAX?Read More →

A financial services company is using AWS Database Migration Service (AWS DMS) to migrate its databases from on-premises to AWS.A database administrator is working on replicating a database to AWS from on-premises using full load and change data capture (CDC).During the CDC replication, the database administrator observed that the target latency was high and slowly increasing.What could be the root causes for this high target latency? (Choose two.)Read More →

A company uses an Amazon Aurora MySQL DB cluster.A database specialist has configured the DB cluster to use the automated backup feature with a 10-day retention period.The company wants the database specialist to reduce the cost of the database backup storage as much as possible without causing downtime.It is more important for the company to optimize costs than it is to retain a large set of database backups.Which set of actions should the database specialist take on the DB cluster to meet these requirements?Read More →

A retail company runs its production database on Amazon RDS for SOL Server.The company wants more flexibility in backing up and restoring the database.A database specialist needs to create a native backup and restore strategy.The solution must take native SQL Server backups and store them in a highly scalable manner.Which combination of stops should the database specialist take to meet those requirements? (Choose three.)Read More →