Database Specialty (Page 9)

A company is running an on-premises application comprised of a web tier, an application tier, and a MySQL database tier.The database is used primarily during business hours with random activity peaks throughout the day.A database specialist needs to improve the availability and reduce the cost of the MySQL database tier as part of the company’s migration to AWS.Which MySQL database option would meet these requirements?Read More →

A company is moving its fraud detection application from on premises to the AWS Cloud and is using Amazon Neptune for data storage.The company has set up a 1 Gbps AWS Direct Connect connection to migrate 25 TB of fraud detection data from the on-premises data center to a Neptune DB instance.The company already has an Amazon S3 bucket and an S3 VPC endpoint, and 80% of the company’s network bandwidth is available.How should the company perform this data load?Read More →

A company maintains several databases using Amazon RDS for MySQL and PostgreSQL.Each RDS database generates log files with retention periods set to their default values.The company has now mandated that database logs be maintained for up to 90 days in a centralized repository to facilitate real-time and after-the-fact analyses.What should a Database Specialist do to meet these requirements with minimal effort?Read More →

A company is running its line of business application on AWS, which uses Amazon RDS for MySQL at the persistent data store.The company wants to minimize downtime when it migrates the database to Amazon Aurora.Which migration method should a Database Specialist use?Read More →

A team of Database Specialists is currently investigating performance issues on an Amazon RDS for MySQL DB instance and is reviewing related metrics.The team wants to narrow the possibilities down to specific database wait events to better understand the situation.How can the Database Specialists accomplish this?Read More →

A gaming company wants to deploy a game in multiple Regions.The company plans to save local high scores in Amazon DynamoDB tables in each Region.ADatabase Specialist needs to design a solution to automate the deployment of the database with identical configurations in additional Regions, as needed.The solution should also automate configuration changes across all Regions.Which solution would meet these requirements and deploy the DynamoDB tables?Read More →

A company is running a finance application on an Amazon RDS for MySQL DB instance.The application is governed by multiple financial regulatory agencies.The RDS DB instance is set up with security groups to allow access to certain Amazon EC2 servers only.AWS KMS is used for encryption at rest.Which step will provide additional security?Read More →

A clothing company uses a custom ecommerce application and a PostgreSQL database to sell clothes to thousands of users from multiple countries.The company is migrating its application and database from its on-premises data center to the AWS Cloud.The company has selected Amazon EC2 for the application and Amazon RDS for PostgreSQL for the database.The company requires database passwords to be changed every 60 days.A Database Specialist needs to ensure that the credentials used by the web application to connect to the database are managed securely.Which approach should the Database Specialist take to securely manage the database credentials?Read More →

A company is concerned about the cost of a large-scale, transactional application using Amazon DynamoDB that only needs to store data for 2 days before it is deleted.In looking at the tables, a Database Specialist notices that much of the data is months old, and goes back to when the application was first deployed.What can the Database Specialist do to reduce the overall cost?Read More →

A company is deploying a solution in Amazon Aurora by migrating from an on-premises system.The IT department has established an AWS Direct Connect link from the company’s data center.The company’s Database Specialist has selected the option to require SSL/TLS for connectivity to prevent plaintext data from being set over the network.The migration appears to be working successfully, and the data can be queried from a desktop machine.Two Data Analysts have been asked to query and validate the data in the new Aurora DB cluster.Both Analysts are unable to connect to Aurora.Their user names and passwords have been verified as valid and the Database Specialist can connect to the DB cluster using their accounts.The Database Specialist also verified that the security group configuration allows network from all corporate IP addresses.What should the Database Specialist do to correct the Data Analysts’ inability to connect?Read More →