DBS-C01 (Page 16)

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 →

An ecommerce company is running Amazon RDS for Microsoft SQL Server.The company is planning to perform testing in a development environment with production data.The development environment and the production environment are in separate AWS accounts.Both environments use AWS Key Management Service (AWS KMS) encrypted databases with both manual and automated snapshots.A database specialist needs to share a KMS encrypted production RDS snapshot with the development account.Which combination of steps should the database specialist take to meet these requirements? (Choose three.)Read More →

A company has an ecommerce website that runs on AWS.The website uses an Amazon RDS for MySQL database.A database specialist wants to enforce the use of temporary credentials to access the database.Which solution will meet this requirement?Read More →

A company has an application that uses an Amazon DynamoDB table as its data store.During normal business days, the throughput requirements from the application are uniform and consist of 5 standard write calls per second to the DynamoDB table.Each write call has 2 KB of data.For 1 hour each day, the company runs an additional automated job on the DynamoDB table that makes 20 write requests per second.No other application writes to the DynamoDB table.The DynamoDB table does not have to meet any additional capacity requirements.How should a database specialist configure the DynamoDB table’s capacity to meet these requirements MOST cost-effectively?Read More →