Which step will provide additional security?

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

November 4, 2020 No Comments READ MORE +

Which combination of steps would allow the Database Specialist to accomplish this?

A company is load testing its three-tier production web application deployed with an AWS CloudFormation template on AWS. The Application team is making changes to deploy additional Amazon EC2 and AWS Lambda resources to expand the load testing capacity. A Database Specialist wants to ensure that the changes made by...

November 3, 2020 No Comments READ MORE +

Which solution meets these requirements?

A company needs a data warehouse solution that keeps data in a consistent, highly structured format. The company requires fast responses for end-user queries when looking at data from the current year, and users must have access to the full 15-year dataset, when needed. This solution also needs to handle...

November 2, 2020 No Comments READ MORE +

Which solution will meet these requirements with minimal effort?

A company has an on-premises system that tracks various database operations that occur over the lifetime of a database, including database shutdown, deletion, creation, and backup. The company recently moved two databases to Amazon RDS and is looking at a solution that would satisfy these requirements. The data could be...

November 2, 2020 No Comments READ MORE +

Which configurations will result in the LEAST application downtime during a failover?

A manufacturing company’s website uses an Amazon Aurora PostgreSQL DB cluster. Which configurations will result in the LEAST application downtime during a failover? (Choose three.)A . Use the provided read and write Aurora endpoints to establish a connection to the Aurora DB cluster.B . Create an Amazon CloudWatch alert triggering...

November 2, 2020 No Comments READ MORE +

Which approach should the Database Specialist take to reduce downtime?

A company is using Amazon RDS for MySQL to redesign its business application. A Database Specialist has noticed that the Development team is restoring their MySQL database multiple times a day when Developers make mistakes in their schema updates. The Developers sometimes need to wait hours to the restores to...

November 1, 2020 No Comments READ MORE +

Which settings will meet this requirement?

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

November 1, 2020 No Comments READ MORE +

Which combination of steps should the Database Specialist take to secure the cache data and protect it from unauthorized access?

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

October 31, 2020 No Comments READ MORE +

Which solution would meet these requirements and deploy the DynamoDB tables?

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. A Database Specialist needs to design a solution to automate the deployment of the database with identical configurations in additional Regions, as needed. The...

October 31, 2020 No Comments READ MORE +

Which migration method should a Database Specialist use?

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?A . Take a snapshot of the...

October 30, 2020 No Comments READ MORE +