DBS-C01 (Page 29)

A company is running an Amazon RDS for PostgreSQL DB instance and wants to migrate it to an Amazon Aurora PostgreSQL DB cluster.The current database is 1 TB in size.The migration needs to have minimal downtime.What is the FASTEST way to accomplish this?Read More →

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 Specialist take to secure the cache data and protect it from unauthorized access? (Choose three.)Read More →

A database specialist is creating an AWS CloudFormation stack.The database specialist wants to prevent accidental deletion of an Amazon RDSProductionDatabase resource in the stack.Which solution will meet this requirement?Read More →

An ecommerce company is using Amazon DynamoDB as the backend for its order-processing application.The steady increase in the number of orders is resulting in increased DynamoDB costs.Order verification and reporting perform many repeated GetItem functions that pull similar datasets, and this read activity is contributing to the increased costs.The company wants to control these costs without significant development efforts.How should a Database Specialist address these requirements?Read More →

A large gaming company is creating a centralized solution to store player session state for multiple online games.The workload required key-value storage with low latency and will be an equal mix of reads and writes.Data should be written into the AWS Region closest to the user across the games’ geographically distributed user base.The architecture should minimize the amount of overhead required to manage the replication of data between Regions.Which solution meets these requirements?Read More →

A company is developing a multi-tier web application hosted on AWS using Amazon Aurora as the database.The application needs to be deployed to production and other non-production environments.A Database Specialist needs to specify different MasterUsername and MasterUserPassword properties in the AWSCloudFormation templates used for automated deployment.The CloudFormation templates are version controlled in the company’s code repository.The company also needs to meet compliance requirement by routinely rotating its database master password for production.What is most secure solution to store the master password?Read More →

A Database Specialist needs to define a database migration strategy to migrate an on-premises Oracle database to an Amazon Aurora MySQL DB cluster.The company requires near-zero downtime for the data migration.The solution must also be cost-effective.Which approach should the Database Specialist take?Read More →

A company is using Amazon with Aurora Replicas for read-only workload scaling.A Database Specialist needs to split up two read-only applications so each application always connects to a dedicated replica.The Database Specialist wants to implement load balancing and high availability for the read-only applications.Which solution meets these requirements?Read More →

A company is using an Amazon Aurora MySQL database with Performance Insights enabled.A database specialist is checking Performance Insights and observes an alert message that starts with the following phrase: `Performance Insights is unable to collect SQL Digest statistics on new queries`¦`Which action will resolve this alert message?Read More →

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 AWSKMS.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 AWS Management Console to meet the disaster recovery requirements?Read More →