Database Specialty (Page 15)

A gaming company uses Amazon Aurora Serverless for one of its internal applications.The company’s developers use Amazon RDS Data API to work with theAurora Serverless DB cluster.After a recent security review, the company is mandating security enhancements.A database specialist must ensure that access toRDS Data API is private and never passes through the public internet.What should the database specialist do to meet this requirement?Read More →

An online retail company is planning a multi-day flash sale that must support processing of up to 5,000 orders per second.The number of orders and exact schedule for the sale will vary each day.During the sale, approximately 10,000 concurrent users will look at the deals before buying items.Outside of the sale, the traffic volume is very low.The acceptable performance for read/write queries should be under 25 ms.Order items are about 2 KB in size and have a unique identifier.The company requires the most cost-effective solution that will automatically scale and is highly available.Which solution meets these requirements?Read More →

A gaming company is developing a new mobile game and decides to store the data for each user in Amazon DynamoDB.To make the registration process as easy as possible, users can log in with their existing Facebook or Amazon accounts.The company expects more than 10,000 users.How should a database specialist implement access control with the LEAST operational effort?Read More →

A database specialist is working with a company to launch a new website.The website accesses a database on an Amazon Aurora MySQL DB cluster that is configured with several Aurora Replicas.The website will replace an on-premises website that is connected to a legacy relational database.Because of stability issues in the legacy database, the company wants to test the resiliency of the Aurora cluster.Which action can the database specialist take to test the resiliency of the Aurora cluster?Read More →

A company is using Amazon Redshift.A database specialist needs to allow an existing Redshift cluster to access data from other Redshift clusters.Amazon RDS for PostgreSQL databases, and AWS Glue Data Catalog tables.Which combination of steps will meet these requirements with the MOST operational efficiency? (Choose three.)Read More →

A company wants to migrate its on-premises MySQL databases to Amazon RDS for MySQL.To comply with the company’s security policy, all databases must be encrypted at rest.RDS DB instance snapshots must also be shared across various accounts to provision testing and staging environments.Which solution meets these requirements?Read More →

A gaming company is evaluating Amazon ElastiCache as a solution to manage player leaderboards.Millions of players around the world will complete in annual tournaments.The company wants to implement an architecture that is highly available.The company also wants to ensure that maintenance activities have minimal impact on the availability of the gaming platform.Which combination of steps should the company take to meet these requirements? (Choose two.)Read More →

A company has a database fleet that includes an Amazon RDS for MySQL DB instance.During an audit, the company discovered that the data that is stored on the DB instance is unencrypted.A database specialist must enable encryption for the DB instance.The database specialist also must encrypt all connections to the DB instance.Which combination of actions should the database specialist take to meet these requirements? (Choose three.)Read More →

A finance company migrated its 3 ׀¢׀’ on-premises PostgreSQL database to an Amazon Aurora PostgreSQL DB cluster.During a review after the migration, a database specialist discovers that the database is not encrypted at rest.The database must be encrypted at rest as soon as possible to meet security requirements.The database specialist must enable encryption for the DB cluster with minimal downtime.Which solution will meet these requirements?Read More →

Developers have requested a new Amazon Redshift cluster so they can load new third-party marketing data.The new cluster is ready and the user credentials are given to the developers.The developers indicate that their copy jobs fail with the following error message:`Amazon Invalid operation: S3ServiceException:Access Denied,Status 403,Error AccessDenied.`The developers need to load this data soon, so a database specialist must act quickly to solve this issue.What is the MOST secure solution?Read More →