DBS-C01 (Page 24)

A team of Database Specialists is currently investigating performance issues on an Amazon RDS for MySQL DB instance and is reviewing related metrics.The team wants to narrow the possibilities down to specific database wait events to better understand the situation.How can the Database Specialists accomplish this?Read More →

A company is running its line of business application on AWS, which uses Amazon RDS for MySQL at the persistent data store.The company wants to minimize downtime when it migrates the database to Amazon Aurora.Which migration method should a Database Specialist use?Read More →

A company maintains several databases using Amazon RDS for MySQL and PostgreSQL.Each RDS database generates log files with retention periods set to their default values.The company has now mandated that database logs be maintained for up to 90 days in a centralized repository to facilitate real-time and after-the-fact analyses.What should a Database Specialist do to meet these requirements with minimal effort?Read More →

A company is moving its fraud detection application from on premises to the AWS Cloud and is using Amazon Neptune for data storage.The company has set up a 1 Gbps AWS Direct Connect connection to migrate 25 TB of fraud detection data from the on-premises data center to a Neptune DB instance.The company already has an Amazon S3 bucket and an S3 VPC endpoint, and 80% of the company’s network bandwidth is available.How should the company perform this data load?Read More →

A company is running an on-premises application comprised of a web tier, an application tier, and a MySQL database tier.The database is used primarily during business hours with random activity peaks throughout the day.A database specialist needs to improve the availability and reduce the cost of the MySQL database tier as part of the company’s migration to AWS.Which MySQL database option would meet these requirements?Read More →

An online advertising website uses an Amazon DynamoDB table with on-demand capacity mode as its data store.The website also has a DynamoDB Accelerator(DAX) cluster in the same VPC as its web application server.The application needs to perform infrequent writes and many strongly consistent reads from the data store by querying the DAX cluster.During a performance audit, a systems administrator notices that the application can look up items by using the DAX cluster.However, the QueryCacheHits metric for the DAX cluster consistently shows 0 while the QueryCacheMisses metric continuously keeps growing in Amazon CloudWatch.What is the MOST likely reason for this occurrence?Read More →

A company is building a web application on AWS.The application requires the database to support read and write operations in multiple AWS Regions simultaneously.The database also needs to propagate data changes between Regions as the changes occur.The application must be highly available and must provide latency of single-digit milliseconds.Which solution meets these requirements?Read More →

A company migrated one of its business-critical database workloads to an Amazon Aurora Multi-AZ DB cluster.The company requires a very low RTO and needs to improve the application recovery time after database failovers.Which approach meets these requirements?Read More →

A company is using an Amazon RDS for MySQL DB instance for its internal applications.A security audit shows that the DB instance is not encrypted at rest.The company’s application team needs to encrypt the DB instance.What should the team do to meet this requirement?Read More →

A vehicle insurance company needs to choose a highly available database to track vehicle owners and their insurance details.The persisted data should be immutable in the database, including the complete and sequenced history of changes over time with all the owners and insurance transfer details for a vehicle.The data should be easily verifiable for the data lineage of an insurance claim.Which approach meets these requirements with MINIMAL effort?Read More →