PrepAway - Latest Free Exam Questions & Answers

Category: AWS Certified Database – Specialty (beta)

Exam: AWS Certified Database – Specialty (beta)

Which steps should be taken in the AWS Management Console to meet the disaster recovery requirements?

A company is hosting critical business data in an Amazon Redshift cluster. Due to the sensitive nature of the data, the cluster is encrypted at rest using AWS KMS. As a part of disaster recovery requirements, the company needs to copy the Amazon Redshift snapshots to another Region. Which steps should be taken in the […]

PrepAway - Latest Free Exam Questions & Answers

Which configurations will result in the LEAST application downtime during a failover? (Choose three.)

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 a restore in another Availability […]

Which combination of steps would allow the Database Specialist to accomplish this? (Choose two.)

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 the Application team will not […]

How can the Database Specialist accomplish this?

The Development team recently executed a database script containing several data definition language (DDL) and data manipulation language (DML) statements on an Amazon Aurora MySQL DB cluster. The release accidentally deleted thousands of rows from an important table and broke some application functionality. This was discovered 4 hours after the release. Upon investigation, a Database […]

Where should the AWS DMS replication instance be placed for the MOST optimal performance?

A Database Specialist is migrating a 2 TB Amazon RDS for Oracle DB instance to an RDS for PostgreSQL DB instance using AWS DMS. The source RDS Oracle DB instance is in a VPC in the us-east-1 Region. The target RDS for PostgreSQL DB instance is in a VPC in the use-west-2 Region. Where should […]

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

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 […]

Which approach should the Database Specialist take to securely manage the database credentials?

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 […]

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 used by other systems within […]

What can the Database Specialist do to reduce the overall cost?

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. […]


Page 1 of 212