DBS-C01 (Page 3)

A database specialist needs to delete user data and sensor data 1 year after it was loaded in an Amazon DynamoDB table.TTL is enabled on one of the attributes.The database specialist monitors TTL rates on the Amazon CloudWatch metrics for the table and observes that items are not being deleted as expected.What is the MOST likely reason that the items are not being deleted?Read More →

A company is using a Single-AZ Amazon RDS for MySQL DB instance for development.The DB instance is experiencing slow performance when queries run.Amazon CloudWatch metrics indicate that the instance requires more I/O capacity.Which actions can a database specialist perform to resolve this issue? (Choose two.)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 →

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 →

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

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