PrepAway - Latest Free Exam Questions & Answers

Category: AWS Certified Database – Specialty

Exam AWS Certified Database – Specialty

PrepAway - Latest Free Exam Questions & Answers

How can a Database Specialist address these requirements with minimal user involvement?

A company has a production Amazon Aurora Db cluster that serves both online transaction processing (OLTP) transactions and compute-intensive reports. The reports run for 10% of the total cluster uptime while the OLTP transactions run all the time. The company has benchmarked its workload and determined that a six-node Aurora DB cluster is appropriate for […]

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

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


Page 1 of 212